Database

Database

Introduction to Database has 40 Questions

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

True
False
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
Which of the following projects illustrates a database being designed from existing data?

A database using the Production Department's spreadsheets
A database designed to produce production reports for a new Production Department manufacturing process
A database that will combine two databases currently used by the Production Department
None of the above is correct.
A database is called "self-describing" because it contains a description of itself.

True
False
Which of the following projects illustrates a database being designed as a new systems development project?

A database using the Production Department's spreadsheets
A database designed to produce production reports for a new Production Department manufacturing process
A database that will combine two databases currently used by the Production Department
None of the above is correct.
In a database, data is stored in spreadsheets which have rows and columns.

True
False
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
A database has data and relationships.

True
False
The following are components of a database except ________ .

user data
metadata
reports
indexes
Databases create information.

True
False
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
One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.

True
False
Which of the following projects illustrates a database being designed as a redesign of an existing database?

A database using the Production Department's spreadsheets
A database designed to produce production reports for a new Production Department manufacturing process
A database that will combine two databases currently used by the Production Department
None of the above is correct.
A database administrator designs, constructs, and manages the databases.

True
False
An on-line commercial site such as Amazon.com is an example of a(n) ________ .

single-user database application
multiuser database application
e-commerce database application
data mining database application
In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.

True
False
Which of the following products was the first to implement true relational algebra in a PC DBMS?

IDMS
Oracle
dBase-II
R:base
Applications are programs that interact directly with the database.

True
False
SQL stands for ________ .

Structured Query Language
Sequential Query Language
Structured Question Language
Sequential Question Language
The purpose of a database is to help people stop using spreadsheets.

True
False
Because it contains a description of its own structure, a database is considered to be ________ .

described
metadata compatible
self-describing
an application program
Microsoft Access is an enterprise-class database product.

True
False
The following are functions of a DBMS except ________ .

creating and processing forms
creating databases
processing data
administrating databases
Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.

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

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

True
False
Which of the following products implemented the CODASYL DBTG model?

IDMS
DB2
dBase-II
R:base
A database has a built-in capability to create, process and administer itself.

True
False
An Enterprise Resource Planning application is an example of a(n) ________ .

single-user database application
multiuser database application
e-commerce database application
data mining database application
Enterprise Resource Planning (ERP) is an example of a single user database.

True
False
A DBMS that combines a DBMS and an application generator is ________ .

Microsoft's SQL Server
Microsoft's Access
IBM's DB2
Oracle Corporation's Oracle
Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

True
False
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
A database design may be based on existing data.

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

Users
Database applications
DBMS
COBOL programs
The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle.

True
False
The DBMS that is most difficult to use is ________ .

Microsoft's SQL Server
Microsoft's Access
IBM's DB2
Oracle Corporation's Oracle
Database applications are seldom intended for use by a single user.

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

True
False
In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.

True
False