Sail E0 Webinar

MCQs

Total Questions : 46 | Page 1 of 5 pages
Question 1. 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 2. 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 3. 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 4. 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 5. 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 6. 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 7. 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 8. 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 9. 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 10. Which of the following types of databases are the most common?
  1.    Personal
  2.    Workgroup
  3.    Department
  4.    Enterprise
 Discuss Question
Answer: Option C. -> Department

Latest Videos

Latest Test Papers