Computer Science - Database Systems

Exercise :: Database Systems - Section 1

16. 

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

A. Bits
B. Characters
C. Data field
D. Schema
E. None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

17. 

Which command is used to remove an index from the database in SQL?

A. DELETE INDEX
B. DROP INDEX
C. REMOVE INDEX
D. ROLL BACK INDEX
E. None of the above

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

18. 

An-owner-member set in the CODASYL specifications may have

A. only one owner but many owner occurrences
B. only one member but many member occurrence
C. more than one member but only one occurrence per member
D. All of the above
E. None of the above

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

19. 

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

A. Full media
B. Graphics media
C. Multimedia
D. Hypertext
E. None of the above

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

20. 

A top-to-bottom relationship among the items in a database is established by a

A. Hierarchical schema
B. Network schema
C. Relational schema
D. All of the above
E. None of the above

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.