The Database Environment MCQ

Test your knowledge with important The Database Environment MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more The Database Environment MCQs at Bissoy

• The primary mechanism for providing context for data is metadata.
  ক

  True

  খ

  False
• The most common source of database failures in an organization is the failure to implement a strong database administration function.
  ক

  True

  খ

  False
• Another name for multimedia data is unstructured data.
  ক

  True

  খ

  False
• Stored representations of objects and events that have meaning and importance in the user's environment are known as a database.
  ক

  True

  খ

  False
• Data descriptions are stored in a central location called the depository.
  ক

  True

  খ

  False
• The database approach requires additional costs and risks.
  ক

  True

  খ

  False
• Stand-alone databases exhibit many of the same advantages common to file processing systems.
  ক

  True

  খ

  False
• Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003).
  ক

  True

  খ

  False
• The source of the data is sometimes called the system of record.
  ক

  True

  খ

  False
• A workgroup typically comprises between 25 and 100 persons.
  ক

  True

  খ

  False
• An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.
  ক

  True

  খ

  False
• An advantage of the database approach is the creation of maximum data redundancy.
  ক

  True

  খ

  False
• Databases that contain historical and summarized information are usually called data warehouses.
  ক

  True

  খ

  False
• Database management systems were first introduced in the 1950s.
  ক

  True

  খ

  False
• All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.
  ক

  True

  খ

  False
• An extranet is which of the following?
  ক

  The use of Internet protocols with limited access to company data by the company's customers and suppliers.

  খ

  The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.

  গ

  The use of Internet protocols with limited access to company data by people within an organization.

  ঘ

  The use of Internet protocols with unlimited access to company data by people within an organization.
• Structured data may include which of the following?
  ক

  Photo image

  খ

  Video clip

  গ

  Dates

  ঘ

  None of the above
• An enterprise database is which of the following?
  ক

  A database designed to support only users external to an organization

  খ

  A database designed to support an entire organization

  গ

  A database designed to support a relatively small group

  ঘ

  A database designed to support a single PC
• Some advantages of the database approach include all, but:
  ক

  minimal data redundancy.

  খ

  improved data consistency.

  গ

  improved data sharing.

  ঘ

  program-data dependency.
• Which of the following is true for a relational database?
  ক

  Data is represented by tables.

  খ

  It is difficult to access data.

  গ

  Complex programs have to be written for simple queries.

  ঘ

  All of the above.
• Which of the following types of databases are the most common?
  ক

  Personal

  খ

  Workgroup

  গ

  Department

  ঘ

  Enterprise
• Data administrators are responsible for:
  ক

  physical database design.

  খ

  managing technical issues in the database environment.

  গ

  overall management of data resources in an organization.

  ঘ

  writing application programs.
• An enterprise data model is:
  ক

  a graphical model that shows the high-level entities for an organization.

  খ

  a graphical model that shows all entities for an organization.

  গ

  a non-graphical model that shows the high-level entities for an organization.

  ঘ

  a non-graphical model that shows the all entities for an organization.
• A database application can perform which of the following activities?
  ক

  Add records

  খ

  Read records

  গ

  Update records

  ঘ

  All of the above.
• A database management system (DBMS) is a:
  ক

  hardware system used to create, maintain, and provide controlled access to a database.

  খ

  hardware system used to create, maintain, and provide uncontrolled access to a database.

  গ

  software system used to create, maintain, and provide controlled access to a database.

  ঘ

  software system used to create, maintain, and provide uncontrolled access to a database.
• Duplicate data often results in loss of data integrity because:
  ক

  the data formats may be inconsistent.

  খ

  data values may not agree.

  গ

  Both A & B.

  ঘ

  Neither A & B.
• Metadata enables database designers and users to do all of the following except:
  ক

  sample data.

  খ

  understand what data exist.

  গ

  what the fine distinctions are between similar data items.

  ঘ

  what the data mean.
• A data warehouse uses:
  ক

  partial operational data.

  খ

  historical operational data.

  গ

  future operational data.

  ঘ

  health care data.