Sail E0 Webinar

MCQs

Total Questions : 46 | Page 4 of 5 pages
Question 31.  Metadata enables database designers and users to do all of the following except:
  1.    sample data.
  2.    understand what data exist.
  3.    what the fine distinctions are between similar data items.
  4.    what the data mean.
 Discuss Question
Answer: Option A. -> sample data.
Question 32.  A data warehouse uses:
  1.    partial operational data.
  2.    historical operational data.
  3.    future operational data.
  4.    health care data.
 Discuss Question
Answer: Option B. -> historical operational data.
Question 33.  Duplicate data often results in loss of data integrity because:
  1.    the data formats may be inconsistent.
  2.    data values may not agree.
  3.    Both A & B.
  4.    Neither A & B.
 Discuss Question
Answer: Option C. -> Both A & B.
Question 34.  A database management system (DBMS) is a:
  1.    hardware system used to create, maintain, and provide controlled access to a database.
  2.    hardware system used to create, maintain, and provide uncontrolled access to a database.
  3.    software system used to create, maintain, and provide controlled access to a database.
  4.    software system used to create, maintain, and provide uncontrolled access to a database.
 Discuss Question
Answer: Option C. -> software system used to create, maintain, and provide controlled access to a database.
Question 35.  Legacy data is which of the following?
  1.    Data contained in a newly-installed system
  2.    Data rejected during the installation of a new system
  3.    Data contained in a file system
  4.    Data contained by a system used prior to the installation of a new system
 Discuss Question
Answer: Option D. -> Data contained by a system used prior to the installation of a new system
Question 36.  An enterprise data model is:
  1.    a graphical model that shows the high-level entities for an organization.
  2.    a graphical model that shows all entities for an organization.
  3.    a non-graphical model that shows the high-level entities for an organization.
  4.    a non-graphical model that shows the all entities for an organization.
 Discuss Question
Answer: Option A. -> a graphical model that shows the high-level entities for an organization.
Question 37.  A database application can perform which of the following activities?
  1.    Add records
  2.    Read records
  3.    Update records
  4.    All of the above.
 Discuss Question
Answer: Option D. -> All of the above.
Question 38.  A shared database should:
  1.    be accurate and available.
  2.    provide for backup and recovery.
  3.    be secure.
  4.    All of the above.
 Discuss Question
Answer: Option D. -> All of the above.
Question 39.  Data administrators are responsible for:
  1.    physical database design.
  2.    managing technical issues in the database environment.
  3.    overall management of data resources in an organization.
  4.    writing application programs.
 Discuss Question
Answer: Option C. -> overall management of data resources in an organization.
Question 40. . Which of the following is true for a relational database?
  1.    Data is represented by tables.
  2.    It is difficult to access data.
  3.    Complex programs have to be written for simple queries.
  4.    All of the above.
 Discuss Question
Answer: Option A. -> Data is represented by tables.

Latest Videos

Latest Test Papers