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

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    3 × 2 =