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
Advertisement

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
Advertisement

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
Advertisement

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
Advertisement

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
Advertisement

Leave A Comment?