Sail E0 Webinar

MCQs

Total Questions : 262 | Page 2 of 27 pages
Question 11. Sort/report generators
  1.    require more disk space than index/report generators
  2.    none of the listed here
  3.    do not need to sort before generating a report
  4.    are faster than index/report generators
 Discuss Question
Answer: Option A. -> require more disk space than index/report generators
Question 12. The data dictionary tells the DBMS
  1.    what attribute are possessed by the data
  2.    what these files contain
  3.    what files are in the database
  4.    All of the listed here
 Discuss Question
Answer: Option D. -> All of the listed here
Question 13. The relational model uses some unfamiliar terminology. A tuple is equivalent to a
  1.    field
  2.    data item
  3.    record
  4.    data base
 Discuss Question
Answer: Option C. -> record
Question 14. If the record management system allows you to edit values before they are recorded on disk, you can
  1.    All of the listed here
  2.    correct spelling changes before they are recorded
  3.    change the name of a field
  4.    change the width of a field
 Discuss Question
Answer: Option B. -> correct spelling changes before they are recorded
Question 15. In SQL, which command(s) is(are) used to enable/disable a database trigger?
  1.    ALTER TRIGGER
  2.    All of the listed here
  3.    CHANGE USER
  4.    MODIFY USER
 Discuss Question
Answer: Option A. -> ALTER TRIGGER
Question 16. A top-to-bottom relationship among the items in a database is established by a
  1.    All of the listed here
  2.    Hierarchical schema
  3.    Network schema
  4.    Relational schema
 Discuss Question
Answer: Option B. -> Hierarchical schema
Question 17. The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
  1.    Characters
  2.    Data field
  3.    None of the listed here
  4.    Bits
 Discuss Question
Answer: Option B. -> Data field
Question 18. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
  1.    Full media
  2.    Graphics media
  3.    Hypertext
  4.    Multimedia
 Discuss Question
Answer: Option D. -> Multimedia
Question 19. An-owner-member set in the CODASYL specifications may have
  1.    more than one member but only one occurrence per member
  2.    All of the listed here
  3.    only one member but many member occurrence
  4.    only one owner but many owner occurrences
 Discuss Question
Answer: Option D. -> only one owner but many owner occurrences
Question 20. Which command is used to remove an index from the database in SQL?
  1.    REMOVE INDEX
  2.    DELETE INDEX
  3.    ROLL BACK INDEX
  4.    DROP INDEX
 Discuss Question
Answer: Option D. -> DROP INDEX

Latest Videos

Latest Test Papers