Database Systems – Section 4

6. In order to use a DBMS, it is important to understand

A. the physical schema
B. all sub-schemas that the system supports
C. one subschema
D. both (a) and (b)
E. None of the above

Correct Answer: C. one subschema

7. In SQL, which command(s) is(are) used to recompile a stored function?

A. SET FUNCTION
B. SET STORED FUNCTION
C. ALTER FUNCTION
D. All of the above
E. None of the above

Correct Answer: C. ALTER FUNCTION

8. Report generators are used to

A. store data input by a user
B. retrieve information from files
C. answer queries
D. both (b) and (c)
E. None of the above

Correct Answer: D. both (b) and (c)

9. Administrate supervision of database activities is the responsibility of the

A. Database administrator
B. DP Manager
C. DB Manager
D. DP administration
E. None of the above

Correct Answer: A. Database administrator

10. Goals for the design of the logical schema include

A. avoiding data inconsistency
B. being able to construct queries easily
C. being able to access data efficiently
D. All of the above
E. None of the above

Correct Answer: D. All of the above

Leave A Comment?

13 − five =