Sail E0 Webinar

MCQs

Total Questions : 286 | Page 10 of 29 pages
Question 91. A database management system
  1.    allows simultaneous access to multiple files
  2.    can do more than a record management system
  3.    is a collection of programs for managing data in a single file
  4.    both (a) and (b)
  5.    None of the above
 Discuss Question
Answer: Option D. -> both (a) and (b)
Question 92. Which of the following hardware components is the most important to the operation of a database management system?
  1.    high-resolution video display
  2.    printer
  3.    high speed, large-capacity disk
  4.    plotter
  5.    mouse
 Discuss Question
Answer: Option C. -> high speed, large-capacity disk
Question 93. To have a file hold a list, it is necessary to
  1.    identify the records in the list
  2.    identify the name, width and type of the fields of each record.
  3.    decide which fields will be used as sort or index keys
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 94. The PROJECT command will create new table that has
  1.    more fields than the original table
  2.    more rows than the original table
  3.    both (a) and (b)
  4.    all the fields of master table
  5.    None of the above
 Discuss Question
Answer: Option E. -> None of the above
Question 95. Sophisticated report generators can
  1.    print row-oriented reports
  2.    perform arithmetic operations
  3.    selectively retrieve and print portions of a list
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 96. 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.    Network database
  2.    Relational database
  3.    Distributed database
  4.    Hierarchical database
  5.    None of the above
 Discuss Question
Answer: Option D. -> Hierarchical database
Question 97. Which two files are used during operation of the DBMS?
  1.    query language and utilities
  2.    data manipulation language and query language
  3.    data dictionary and transaction log
  4.    data dictionary and query language
  5.    None of the above
 Discuss Question
Answer: Option C. -> data dictionary and transaction log
Question 98. When using a database management system, the first thing that you must do is to
  1.    create a database file
  2.    activate file editor
  3.    load the software into your micro¬computer
  4.    keep a floppy disk in readiness
  5.    None of the above
 Discuss Question
Answer: Option C. -> load the software into your micro¬computer
Question 99. A network schema
  1.    restricts the structure to a one-to-many relationship
  2.    permits many-to-many relation¬ships
  3.    stores data in tables
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> permits many-to-many relation¬ships
Question 100. Which of the following is not a relational database?
  1.    dBASE IV
  2.    4th Dimension
  3.    FoxPro
  4.    Reflex
  5.    None of the above
 Discuss Question
Answer: Option D. -> Reflex

Latest Videos

Latest Test Papers