Database Systems – Section 2

6. In SQL, which command is used to changes data in a table?

A. UPDATE
B. INSERT
C. BROWSE
D. APPEND
E. None of the above

Correct Answer: A. UPDATE
Advertisement

7. What name is given to the collection of facts, items of information or data which are related in some way?

A. Database
B. Directory information
C. Information tree
D. Information provider
E. None of the above

Correct Answer: A. Database
Advertisement

8. In a large DBMS

A. each user can “see” only a small part of the entire database
B. each user can access every sub¬schema
C. each subschema contains every field in the logical schema
D. All of the above
E. None of the above

Correct Answer: A. each user can “see” only a small part of the entire database
Advertisement

9. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

A. COMPILE PROCEDURE
B. ALTER PROCEDURE
C. MODIFY PROCEDURE id) All of the above
D. None of the above

Correct Answer: B. ALTER PROCEDURE
Advertisement

10. Internal auditors should review data system design before they are

A. developed
B. implemented
C. modified
D. All of the above
E. None of the above

Correct Answer: D. All of the above
Advertisement

Leave A Comment?