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

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    15 + 3 =