⟩ Explain what are the features of Clipper VO?
There is no Clipper VO; CA Visual Objects is an object oriented Clipper super-set that runs under Windows and creates Windows executables.
There is no Clipper VO; CA Visual Objects is an object oriented Clipper super-set that runs under Windows and creates Windows executables.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What type of index should you use on a fact table?
What is a Segment?
Give the two types of tables involved in producing a star schema and the type of data they hold.
Give the reasoning behind using an index.
Compare and contrast TRUNCATE and DELETE for a table.
What view would you use to determine free space in a tablespace?
What view would you use to look at the size of a data file?
How do you add a data file to a tablespace?
How do you resize a data file?