CommerceThe Database Environment MCQs
Practice The Database Environment MCQs for competitive exams.
The Database Environment MCQs
Practice questions from this topic.
Databases that contain historical and summarized information are usually called data warehouses.
- A. True
- B. False
Correct Answer: A
Database management systems were first introduced in the 1950s.
- A. True
- B. False
Correct Answer: B
All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.
- A. True
- B. False
Correct Answer: A
An extranet is which of the following?
- A. The use of Internet protocols with limited access to company data by the company's customers and suppliers.
- B. The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.
- C. The use of Internet protocols with limited access to company data by people within an organization.
- D. The use of Internet protocols with unlimited access to company data by people within an organization.
Correct Answer: A
Structured data may include which of the following?
- A. Photo image
- B. Video clip
- C. Dates
- D. None of the above
Correct Answer: C
An enterprise database is which of the following?
- A. A database designed to support only users external to an organization
- B. A database designed to support an entire organization
- C. A database designed to support a relatively small group
- D. A database designed to support a single PC
Correct Answer: B
Some advantages of the database approach include all, but:
- A. minimal data redundancy.
- B. improved data consistency.
- C. improved data sharing.
- D. program-data dependency.
Correct Answer: D
Which of the following is true for a relational database?
- A. Data is represented by tables.
- B. It is difficult to access data.
- C. Complex programs have to be written for simple queries.
- D. All of the above.
Correct Answer: A
Which of the following types of databases are the most common?
- A. Personal
- B. Workgroup
- C. Department
- D. Enterprise
Correct Answer: C
Data administrators are responsible for:
- A. physical database design.
- B. managing technical issues in the database environment.
- C. overall management of data resources in an organization.
- D. writing application programs.
Correct Answer: C
A shared database should:
- A. be accurate and available.
- B. provide for backup and recovery.
- C. be secure.
- D. All of the above.
Correct Answer: D
An enterprise data model is:
- A. a graphical model that shows the high-level entities for an organization.
- B. a graphical model that shows all entities for an organization.
- C. a non-graphical model that shows the high-level entities for an organization.
- D. a non-graphical model that shows the all entities for an organization.
Correct Answer: A