The Database Environment MCQs with Explanations

historical operational data. is the correct answer to “A data warehouse uses:”. This question is standard in competitive examination syllabi for The Database Environment.

sample data. is the correct answer to “Metadata enables database designers and users to do all of the following except:”. This question is standard in competitive examination syllabi for The Database Environment.

Both A & B. is the correct answer to “Duplicate data often results in loss of data integrity because:”. This question is standard in competitive examination syllabi for The Database Environment.

Data contained by a system used prior to the installation of a new system is the correct answer to “Legacy data is which of the following”. This question is standard in competitive examination syllabi for The Database Environment.

software system used to create, maintain, and provide controlled access to a database. is the correct answer to “A database management system (DBMS) is a:”. This question is standard in competitive examination syllabi for The Database Environment.

All of the above. is the correct answer to “A database application can perform which of the following activities”. This question is standard in competitive examination syllabi for The Database Environment.

a graphical model that shows the high-level entities for an organization. is the correct answer to “An enterprise data model is:”. This question is standard in competitive examination syllabi for The Database Environment.

All of the above. is the correct answer to “A shared database should:”. This question is standard in competitive examination syllabi for The Database Environment.

overall management of data resources in an organization. is the correct answer to “Data administrators are responsible for:”. This question is standard in competitive examination syllabi for The Database Environment.

Department is the correct answer to “Which of the following types of databases are the most common”. This question is standard in competitive examination syllabi for The Database Environment.

Data is represented by tables. is the correct answer to “Which of the following is true for a relational database”. This question is standard in competitive examination syllabi for The Database Environment.

program-data dependency. is the correct answer to “Some advantages of the database approach include all, but:”. This question is standard in competitive examination syllabi for The Database Environment.

A database designed to support an entire organization is the correct answer to “An enterprise database is which of the following”. This question is standard in competitive examination syllabi for The Database Environment.

Dates is the correct answer to “Structured data may include which of the following”. This question is standard in competitive examination syllabi for The Database Environment.

The use of Internet protocols with limited access to company data by the company's customers and suppliers. is the correct answer to “An extranet is which of the following”. This question is standard in competitive examination syllabi for The Database Environment.

True is the correct answer to “All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “Database management systems were first introduced in the 1950s.”. This question is standard in competitive examination syllabi for The Database Environment.

True is the correct answer to “Databases that contain historical and summarized information are usually called data warehouses.”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “An advantage of the database approach is the creation of maximum data redundancy.”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “A workgroup typically comprises between 25 and 100 persons.”. This question is standard in competitive examination syllabi for The Database Environment.

True is the correct answer to “The source of the data is sometimes called the system of record.”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003).”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “Stand-alone databases exhibit many of the same advantages common to file processing systems.”. This question is standard in competitive examination syllabi for The Database Environment.

True is the correct answer to “The database approach requires additional costs and risks.”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “Data descriptions are stored in a central location called the depository.”. This question is standard in competitive examination syllabi for The Database Environment.

False is the correct answer to “Stored representations of objects and events that have meaning and importance in the user's environment are known as a database.”. This question is standard in competitive examination syllabi for The Database Environment.

True is the correct answer to “Another name for multimedia data is unstructured data.”. This question is standard in competitive examination syllabi for The Database Environment.

True is the correct answer to “The most common source of database failures in an organization is the failure to implement a strong database administration function.”. This question is standard in competitive examination syllabi for The Database Environment.

True is the correct answer to “The primary mechanism for providing context for data is metadata.”. This question is standard in competitive examination syllabi for The Database Environment.