⟩ Tell me how is file locking handled in Clipper?
if flock()=.T. then
else
endif
if flock()=.T. then
else
endif
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?
Name a tablespace automatically created when you create a database.