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

Correct Answer: C. Data field

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

Correct Answer: B. DROP INDEX

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

Correct Answer: A. only one owner but many owner occurrences

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

Correct Answer: C. Multimedia

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

Correct Answer: A. Hierarchical schema

Leave A Comment?

15 − 5 =