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

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

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

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

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

Leave A Comment?

fourteen − six =