Sail E0 Webinar

MCQs

Total Questions : 286 | Page 18 of 29 pages
Question 171. 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 172. 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 173. 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 174. 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 175. 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 176. 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 177. 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
Question 178. 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 179. When you have finished entering information into a form
  1.    the template is written to the data file
  2.    the contents of the form are written to the data file
  3.    the contents of the form can be printed
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> the contents of the form are written to the data file
Question 180. A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
  1.    the pin code
  2.    the last name
  3.    a compound key consisting of the first name and the last name
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> a compound key consisting of the first name and the last name

Latest Videos

Latest Test Papers