Q.1

The following are functions of a DBMS except ________ .

  • creating and processing forms
  • creating databases
  • processing data
  • administrating databases
Q.2

You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .

  • user data.
  • metadata
  • A report
  • indexes
Q.3

Helping people keep track of things is the purpose of a(n) ________ .

  • database
  • table
  • instance
  • relationship
Q.4

Which of the following is not considered to be a basic element of an enterprise-class database system?

  • Users
  • Database applications
  • DBMS
  • COBOL programs
Q.5

The DBMS acts as an interface between what two components of an enterprise-class database system?

  • Database application and the database
  • Data and the database
  • The user and the database application
  • Database application and SQL
Q.6

The XML family of standards is very important in database processing today.

  • True
  • False
Q.7

In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

  • True
  • False
Q.8

The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle.

  • True
  • False
Q.9

The relational database model was created by E.F. Codd.

  • True
  • False
Q.10

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

  • IDMS
  • DB2
  • dBase-II
  • R:base
Q.11

A database has a built-in capability to create, process and administer itself.

  • True
  • False
Q.12

Enterprise Resource Planning (ERP) is an example of a single user database.

  • True
  • False
Q.13

Applications are programs that interact directly with the database.

  • True
  • False
Q.14

Database applications are seldom intended for use by a single user.

  • True
  • False
Q.15

The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.

  • True
  • False
Q.16

A database is called "self-describing" because it contains a description of itself.

  • True
  • False
Q.17

In a database, data is stored in spreadsheets which have rows and columns.

  • True
  • False
Q.18

The following are components of a database except ________ .

  • user data
  • metadata
  • reports
  • indexes
Q.19

An application where only one user accesses the database at a given time is an example of a(n) ________ .

  • single-user database application
  • multiuser database application
  • e-commerce database application
  • data mining database application
Q.20

Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

  • True
  • False
0 h : 0 m : 1 s