Computer Science - Database Systems

Exercise : Database Systems - Section 1
11.
Sort/report generators
are faster than index/report generators
require more disk space than index/report generators
do not need to sort before generating a report
both (a) and (b)
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

12.
The data dictionary tells the DBMS
what files are in the database
what attribute are possessed by the data
what these files contain
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

13.
In SQL, which command(s) is(are) used to enable/disable a database trigger?
MODIFY USER
CHANGE USER
ALTER TRIGGER
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

14.
If the record management system allows you to edit values before they are recorded on disk, you can
correct spelling changes before they are recorded
change the name of a field
change the width of a field
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.

15.
The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
record
field
file
data base
data item
Answer: Option
Explanation:
No answer description is available. Let's discuss.