Sail E0 Webinar

MCQs

Total Questions : 286 | Page 17 of 29 pages
Question 161. Internal auditors should review data system design before they are
  1.    developed
  2.    implemented
  3.    modified
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 162. A _____ means that one record in a particular record type may be related to more than one record of another record type.
  1.    One-to-one relationship
  2.    One-to-many relationship
  3.    Many-to-one relationship
  4.    Many-to many relationship
  5.    None of the above
 Discuss Question
Answer: Option B. -> One-to-many relationship
Question 163. In a large DBMS
  1.    each user can "see" only a small part of the entire database
  2.    each user can access every sub¬schema
  3.    each subschema contains every field in the logical schema
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> each user can "see" only a small part of the entire database
Question 164. An indexing operation
  1.    sorts a file using a single key
  2.    sorts file using two keys
  3.    establishes an index for a file
  4.    both (b) and (c)
  5.    None of the above
 Discuss Question
Answer: Option C. -> establishes an index for a file
Question 165. A race condition occurs when
  1.    Two concurrent activities interact to cause a processing error
  2.    two users of the DBMS are interacting with different files at the same time
  3.    both (a) and (b)
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> Two concurrent activities interact to cause a processing error
Question 166. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
  1.    forecasting report
  2.    exception report
  3.    regularly scheduled report
  4.    on demand report
  5.    None of the above
 Discuss Question
Answer: Option D. -> on demand report
Question 167. In SQL, which command(s) is(are) used to create a synonym for a schema object?
  1.    CREATE SCHEMA
  2.    CREATE SYNONYM
  3.    CREATE SAME
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> CREATE SYNONYM
Question 168. If you want your database to include methods, you should use a _____ database.
  1.    Network
  2.    Distributed
  3.    Hierarchical
  4.    Object-Oriented
  5.    None of the above
 Discuss Question
Answer: Option D. -> Object-Oriented
Question 169. 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 170. 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

Latest Videos

Latest Test Papers