Sail E0 Webinar

MCQs

Total Questions : 262 | Page 3 of 27 pages
Question 21. A database management system
  1.    None of the listed here
  2.    Both of the listed here
  3.    can do more than a record management system
  4.    allows simultaneous access to multiple files
 Discuss Question
Answer: Option B. -> Both of the listed here
Question 22. To have a file hold a list, it is necessary to
  1.    decide which fields will be used as sort or index keys
  2.    identify the records in the list
  3.    identify the name, width and type of the fields of each record.
  4.    All of the listed here
 Discuss Question
Answer: Option D. -> All of the listed here
Question 23. The PROJECT command will create new table that has
  1.    more rows than the original table
  2.    none of the listed here
  3.    more fields than the original table
  4.    both of the listed here
 Discuss Question
Answer: Option B. -> none of the listed here
Question 24. Which of the following hardware components is the most important to the operation of a database management system?
  1.    printer
  2.    high-resolution video display
  3.    high speed, large-capacity disk
  4.    plotter
 Discuss Question
Answer: Option C. -> high speed, large-capacity disk
Question 25. Sophisticated report generators can
  1.    print row-oriented reports
  2.    selectively retrieve and print portions of a list
  3.    perform arithmetic operations
  4.    All of the listed here
 Discuss Question
Answer: Option D. -> All of the listed here
Question 26. In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
  1.    Relational database
  2.    Network database
  3.    Hierarchical database
  4.    Distributed database
 Discuss Question
Answer: Option C. -> Hierarchical database
Question 27. Which two files are used during operation of the DBMS?
  1.    data dictionary and transaction log
  2.    query language and utilities
  3.    None of the listed here
  4.    data dictionary and query language
 Discuss Question
Answer: Option A. -> data dictionary and transaction log
Question 28. When using a database management system, the first thing that you must do is to
  1.    create a database file
  2.    keep a floppy disk in readiness
  3.    load the software into your micro¬computer
  4.    activate file editor
 Discuss Question
Answer: Option C. -> load the software into your micro¬computer
Question 29. Which of the following is not a relational database?
  1.    dBASE IV
  2.    4th Dimension
  3.    FoxPro
  4.    Reflex
 Discuss Question
Answer: Option D. -> Reflex
Question 30. A network schema
  1.    restricts the structure to a one-to-many relationship
  2.    stores data in tables
  3.    All of the listed here
  4.    permits many-to-many relation¬ships
 Discuss Question
Answer: Option D. -> permits many-to-many relation¬ships

Latest Videos

Latest Test Papers