The Database Environment(Database ) Questions and Answers

Question 1. A data warehouse uses:
  1.    partial operational data.
  2.    historical operational data.
  3.    future operational data.
  4.    health care data.
Explanation:-
Answer: Option B. -> historical operational data.
Question 2. 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.
Explanation:-
Answer: Option C. -> Both A & B.
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
Explanation:-
Answer: Option D. -> Data contained by a system used prior to the installation of a new system
Question 4. 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.
Explanation:-
Answer: Option C. -> software system used to create, maintain, and provide controlled access to a database.
Question 5. 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.
Explanation:-
Answer: Option A. -> sample data.
Question 6. 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.
Explanation:-
Answer: Option A. -> Data is represented by tables.
Question 7. Structured data may include which of the following?
  1.    Photo image
  2.    Video clip
  3.    Dates
  4.    None of the above
Explanation:-
Answer: Option C. -> Dates
Question 8. Some advantages of the database approach include all, but:
  1.    minimal data redundancy.
  2.    improved data consistency.
  3.    improved data sharing.
  4.    program-data dependency.
Explanation:-
Answer: Option D. -> program-data dependency.
Question 9. An extranet is which of the following?
  1.    The use of Internet protocols with limited access to company data by the company's customers and suppliers.
  2.    The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.
  3.    The use of Internet protocols with limited access to company data by people within an organization.
  4.    The use of Internet protocols with unlimited access to company data by people within an organization.
Explanation:-
Answer: Option A. -> The use of Internet protocols with limited access to company data by the company's customers and suppliers.
Question 10. An enterprise database is which of the following?
  1.    A database designed to support only users external to an organization
  2.    A database designed to support an entire organization
  3.    A database designed to support a relatively small group
  4.    A database designed to support a single PC
Explanation:-
Answer: Option B. -> A database designed to support an entire organization
© Lakshya_Education.com, All Right Reserved.
Contact Us services