Q.1

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.
Q.2

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.
Q.3

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.
Q.4

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
Q.5

Database management systems were first introduced in the 1950s.

  • True
  • False
Q.6

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

  • True
  • False
Q.7

A shared database should:

  • be accurate and available.
  • provide for backup and recovery.
  • be secure.
  • All of the above.
Q.8

Legacy data is which of the following?

  • Data contained in a newly-installed system
  • Data rejected during the installation of a new system
  • Data contained in a file system
  • Data contained by a system used prior to the installation of a new system
Q.9

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.
Q.10

Structured data may include which of the following?

  • Photo image
  • Video clip
  • Dates
  • None of the above.
Q.11

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

  • True
  • False
Q.12

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

  • True
  • False
Q.13

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.
Q.14

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.
Q.15

Which of the following types of databases are the most common?

  • Personal
  • Workgroup
  • Department
  • Enterprise
0 h : 0 m : 1 s