Database Systems – Section 2

21. In SQL, which command(s) is(are) used to create a synonym for a schema object?

A. CREATE SCHEMA
B. CREATE SYNONYM
C. CREATE SAME
D. All of the above
E. None of the above

Correct Answer: B. CREATE SYNONYM

22. If you want your database to include methods, you should use a _____ database.

A. Network
B. Distributed
C. Hierarchical
D. Object-Oriented
E. None of the above

Correct Answer: D. Object-Oriented

23. In SQL, which of the following is not a data Manipulation Language Commands?

A. DELETE
B. SELECT
C. UPDATE
D. CREATE
E. None of the above

Correct Answer: D. CREATE

24. Which of the following is not characteristic of a relational database model?

A. tables
B. treelike structure
C. complex logical relationships
D. records
E. None of the above

Correct Answer: B. treelike structure

25. A computer file contains several records. What does each record contain?

A. Bytes
B. Words
C. Fields
D. Database
E. None of the above

Correct Answer: C. Fields

Leave A Comment?

5 + 17 =