Computer Science - Database Systems

Exercise :: Database Systems - Section 1

11. 

Sort/report generators

A. are faster than index/report generators
B. require more disk space than index/report generators
C. do not need to sort before generating a report
D. both (a) and (b)
E. None of the above

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

12. 

The data dictionary tells the DBMS

A. what files are in the database
B. what attribute are possessed by the data
C. what these files contain
D. All of the above
E. None of the above

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

13. 

In SQL, which command(s) is(are) used to enable/disable a database trigger?

A. MODIFY USER
B. CHANGE USER
C. ALTER TRIGGER
D. All of the above
E. None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

14. 

If the record management system allows you to edit values before they are recorded on disk, you can

A. correct spelling changes before they are recorded
B. change the name of a field
C. change the width of a field
D. All of the above
E. None of the above

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

15. 

The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

A. record
B. field
C. file
D. data base
E. data item

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.