⟩ Explain what is the format used for real numbers by Clipper?
Clipper uses binary floating point format for Real Numbers which could result in precision related errors.
Clipper uses binary floating point format for Real Numbers which could result in precision related errors.
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.
When creating a user, what permissions must you grant to allow them to connect to the database?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?