Question 1

To access data in a ____________________ database, users fill in a form on a Web page.

Accepted Answer

Web

Question 2

COGNITIVE ASSESSMENT Your database was damaged due to hardware failure. What can you use to restore it?

Accepted Answer

A)  a backup 
B)  imaging software 
C)  restoration hardware 
D)  a wizard 
A)  a backup 
B)  imaging software 
C)  restoration hardware 
D)  a wizard A

Question 3

The developer of a relational database refers to a file as which of the following?

Accepted Answer

A)  attribute 
B)  record 
C)  relation 
D)  tuple 
A)  attribute 
B)  record 
C)  relation 
D)  tuple C

Question 4

COGNITIVE ASSESSMENT Which database vendor has the largest market share?

Accepted Answer

A)  Microsoft 
B)  IBM 
C)  Sybase 
D)  Oracle 
A)  Microsoft 
B)  IBM 
C)  Sybase 
D)  Oracle

Question 5

A file is a group of related fields.

Accepted Answer

A) True 
 B)False

Question 6

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

Accepted Answer

A)  instant 
B)  baseline 
C)  integrated 
D)  forward 
A)  instant 
B)  baseline 
C)  integrated 
D)  forward

Question 7

Data warehouses often use a process called data ____________________ to find patterns and relationships among data.

Accepted Answer

The answer of Data warehouses often use a process called...

Question 8

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

Accepted Answer

A)  The number of dimensions in a multidimensional database varies. 
B)  Most multidimensional databases use a standard query language. 
C)  Nearly every multidimensional database has a dimension of time. 
D)  A multidimensional database can consolidate data much faster than a relational database. 
A)  The number of dimensions in a multidimensional database varies. 
B)  Most multidimensional databases use a standard query language. 
C)  Nearly every multidimensional database has a dimension of time. 
D)  A multidimensional database can consolidate data much faster than a relational database.

Question 9

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

Accepted Answer

A) True 
 B)False

Question 10

A(n) ____________________ verifies that a required field contains data.

Accepted Answer

The answer of A(n) ____________________ verifies that a required field...

Question 11

____________________ is a common data type that consists of an e-mail address or a Web address that links to a document or Web page.

Accepted Answer

The answer of ____________________ is a common data type that...

Question 12

Most DBMSs include a feature, as shown in the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

Accepted Answer

A)  QBA 
B)  SQL 
C)  QBE 
D)  schema 
A)  QBA 
B)  SQL 
C)  QBE 
D)  schema

Question 13

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?

Accepted Answer

A)  tuple 
B)  attribute 
C)  table 
D)  relation 
A)  tuple 
B)  attribute 
C)  table 
D)  relation

Question 14

COGNITIVE ASSESSMENT You are creating a database for your computer clu b. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

Accepted Answer

A)  make the field a maximum of size characters 
B)  make it the default value 
C)  use AutoComplete 
D)  add a drop-down box 
A)  make the field a maximum of size characters 
B)  make it the default value 
C)  use AutoComplete 
D)  add a drop-down box

Question 15

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs)?

Accepted Answer

A)  A voice mail system is an example of a groupware database. 
B)  An object is an item that contains data, as well as the actions that read or process the data. 
C)  An OODB stores unstructured data more efficiently than a relational database. 
D)  OODBs can store more types of data and access it faster than relational databases. 
A)  A voice mail system is an example of a groupware database. 
B)  An object is an item that contains data, as well as the actions that read or process the data. 
C)  An OODB stores unstructured data more efficiently than a relational database. 
D)  OODBs can store more types of data and access it faster than relational databases.

Question 16

An application that supports a front-end program sometimes is called which of the following?

Accepted Answer

A)  back end 
B)  RDBMS 
C)  GUI 
D)  collaborative database 
A)  back end 
B)  RDBMS 
C)  GUI 
D)  collaborative database

Question 17

A user of a relational database, such as that pictured in the accompanying figure, refers to a record as what?

Accepted Answer

A)  table 
B)  column 
C)  row 
D)  relationship 
A)  table 
B)  column 
C)  row 
D)  relationship

Question 18

COGNITIVE ASSESSMENT Which of the following is responsible for creating and maintaining the data dictionary, managing security of the database, and checking backup and recovery procedures?

Accepted Answer

A)  database analyst 
B)  data modeler 
C)  data manager 
D)  database administrator 
A)  database analyst 
B)  data modeler 
C)  data manager 
D)  database administrator

Question 19

A checkout clerk with this level of privileges to the e-mail addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

Accepted Answer

A)  read-only 
B)  write-only 
C)  full-update 
D)  no access 
A)  read-only 
B)  write-only 
C)  full-update 
D)  no access

Question 20

COGNITIVE ASSESSMENT You create a database that stores data in hypercubes. Which data model did you use?

Accepted Answer

A)  object-oriented 
B)  object-relational 
C)  relational 
D)  multi-dimensional 
A)  object-oriented 
B)  object-relational 
C)  relational 
D)  multi-dimensional

To access data in a ____________________ database, users fill in a form on a Web page.

COGNITIVE ASSESSMENT Your database was damaged due to hardware failure. What can you use to restore it?

The developer of a relational database refers to a file as which of the following?

COGNITIVE ASSESSMENT Which database vendor has the largest market share?

A file is a group of related fields.

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

Data warehouses often use a process called data ____________________ to find patterns and relationships among data.

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

A(n) ____________________ verifies that a required field contains data.

____________________ is a common data type that consists of an e-mail address or a Web address that links to a document or Web page.

Most DBMSs include a feature, as shown in the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?

COGNITIVE ASSESSMENT You are creating a database for your computer clu b. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs)?

An application that supports a front-end program sometimes is called which of the following?

A user of a relational database, such as that pictured in the accompanying figure, refers to a record as what?

COGNITIVE ASSESSMENT Which of the following is responsible for creating and maintaining the data dictionary, managing security of the database, and checking backup and recovery procedures?

A checkout clerk with this level of privileges to the e-mail addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

COGNITIVE ASSESSMENT You create a database that stores data in hypercubes. Which data model did you use?

Introduction to Computers

The Internet and the World Wide Web

Application Software

The Components of the Unit System

Input

Output

Storage

Operating Systems and Utility Programs

Communications and Networks

Computer Security and Safety, Ethics, and Privacy

Information System Development

Programming Languages and Program Development

Enterprise Computing

Computer Careers and Certification

Filters

Exam 10: Database Management

To access data in a ____________________ database, users fill in a form on a Web page.

COGNITIVE ASSESSMENT Your database was damaged due to hardware failure. What can you use to restore it?

The developer of a relational database refers to a file as which of the following?

COGNITIVE ASSESSMENT Which database vendor has the largest market share?

A file is a group of related fields.

In what kind of recovery does the DBMS use the log to reenter changes made to a database since the last save or backup?

Data warehouses often use a process called data ____________________ to find patterns and relationships among data.

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

A DBMS provides a variety of techniques to restore a database to a usable form in case it is damaged or destroyed.

A(n) ____________________ verifies that a required field contains data.

____________________ is a common data type that consists of an e-mail address or a Web address that links to a document or Web page.

Most DBMSs include a feature, as shown in the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a record?

COGNITIVE ASSESSMENT You are creating a database for your computer clu b. Most of the students live in your town, Durham. How can you make Durham appear initially in the field to make data entry easier?

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs)?

An application that supports a front-end program sometimes is called which of the following?

A user of a relational database, such as that pictured in the accompanying figure, refers to a record as what?

COGNITIVE ASSESSMENT Which of the following is responsible for creating and maintaining the data dictionary, managing security of the database, and checking backup and recovery procedures?

A checkout clerk with this level of privileges to the e-mail addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?

COGNITIVE ASSESSMENT You create a database that stores data in hypercubes. Which data model did you use?

Introduction to Computers

The Internet and the World Wide Web

Application Software

The Components of the Unit System

Input

Output

Storage

Operating Systems and Utility Programs

Communications and Networks

Computer Security and Safety, Ethics, and Privacy

Information System Development

Programming Languages and Program Development

Enterprise Computing

Computer Careers and Certification

Filters