⟩ Explain what are the operating systems under which Clipper can operate?
MSDOS and clones and emulators.
MSDOS and clones and emulators.
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
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?