Question 1

Which of the following stores data in objects?

Accepted Answer

A)  ADB 
B)  OTDB 
C)  EDB 
D)  OODB 
A)  ADB 
B)  OTDB 
C)  EDB 
D)  OODB

Question 2

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

Accepted Answer

A)  Oracle 
B)  Sun Microsystems 
C)  Sybase 
D)  Microsoft 
A)  Oracle 
B)  Sun Microsystems 
C)  Sybase 
D)  Microsoft

Question 3

The data in a database environment belongs to and is shared, usually over a network, by an entire organization.

Accepted Answer

A) True 
 B)False

Question 4

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

Accepted Answer

A)  a front end 
B)  a user environment 
C)  a home page 
D)  a data file 
A)  a front end 
B)  a user environment 
C)  a home page 
D)  a data file

Question 5

E-forms seldom use a means to secure data while it is transported across a network.

Accepted Answer

A) True 
 B)False

Question 6

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

Accepted Answer

A)  backward 
B)  restorative 
C)  undo 
D)  model 
A)  backward 
B)  restorative 
C)  undo 
D)  model

Question 7

In a file processing system, the records in one file always relate to the records in other files.

Accepted Answer

A) True 
 B)False

Question 8

A relational database typically processes and summarizes large numbers of records efficiently.

Accepted Answer

A) True 
 B)False

Question 9

COGNITIVE ASSESSMENT A data dictionary contains details about data. What term is used to describe this characteristic?

Accepted Answer

A)  omnidata 
B)  maxidata 
C)  metadata 
D)  duplidata 
A)  omnidata 
B)  maxidata 
C)  metadata 
D)  duplidata

Question 10

When users modify data in a database, they make changes to multiple files instead of one file.

Accepted Answer

A) True 
 B)False

Question 11

A relational database developer refers to a record as a relation.

Accepted Answer

A) True 
 B)False

Question 12

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

Accepted Answer

A)  information confirmation 
B)  integration 
C)  validity check 
D)  integrity valuation 
A)  information confirmation 
B)  integration 
C)  validity check 
D)  integrity valuation

Question 13

Which of the following is an item that contains data, as well as the actions that read or process the data?

Accepted Answer

A)  object 
B)  hyperlink 
C)  action link 
D)  event 
A)  object 
B)  hyperlink 
C)  action link 
D)  event

Question 14

Each higher level of data consists of one or more items from the lower level.

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: In addition to storing data, a relational database also stores these.
Information that can be proven as correct or incorrect.
Information that should give more value than it costs to produce.
Information that has meaning to the person who receives it.
Whether designed for a small or large computer, most DBMSs perform common ones.
A group of related fields.
Has special keywords and rules that users include in SQL statements.
Information that is arranged to suit the needs and requirements of the decision maker.
This type of information can lead to incorrect decisions.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
While a user is working with the database, this resides in the memory of the computer.
This database capability is one of the more powerful database features.
Information that has an age suited to its use.
The more errors the data contains, the lower this is.
A field that uniquely identifies each record in a file.
What each byte represents in ASCII.
Phrase that points out the accuracy of a computer's output depends on the accuracy of the input.
Eight bits grouped together in a unit comprise this.
What is done to a record so the DBMS will not process it again.
Information that is error free.

Accepted Answer

The Answer of cost-effective and timely and SQL and flagged is...

Question 16

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Accepted Answer

A)  field 
B)  member 
C)  record 
D)  identifier 
A)  field 
B)  member 
C)  record 
D)  identifier

Question 17

Which of the following, with regard to the entire database, should be made on a regular basis?

Accepted Answer

A)  backup 
B)  baseline 
C)  after image 
D)  retread 
A)  backup 
B)  baseline 
C)  after image 
D)  retread

Question 18

A data model defines how the operating system actually arranges the data on the disk.

Accepted Answer

A) True 
 B)False

Question 19

A larger version of a data warehouse is the data mart.

Accepted Answer

A) True 
 B)False

Question 20

COGNITIVE ASSESSMENT What procedure is applied to databases to remove ambiguous relationships and minimize database redundancy?

Accepted Answer

A)  standardization 
B)  distribution 
C)  normalization 
D)  extraction 
A)  standardization 
B)  distribution 
C)  normalization 
D)  extraction

Which of the following stores data in objects?

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

The data in a database environment belongs to and is shared, usually over a network, by an entire organization.

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

E-forms seldom use a means to secure data while it is transported across a network.

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

In a file processing system, the records in one file always relate to the records in other files.

A relational database typically processes and summarizes large numbers of records efficiently.

COGNITIVE ASSESSMENT A data dictionary contains details about data. What term is used to describe this characteristic?

When users modify data in a database, they make changes to multiple files instead of one file.

A relational database developer refers to a record as a relation.

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

Which of the following is an item that contains data, as well as the actions that read or process the data?

Each higher level of data consists of one or more items from the lower level.

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Which of the following, with regard to the entire database, should be made on a regular basis?

A data model defines how the operating system actually arranges the data on the disk.

A larger version of a data warehouse is the data mart.

COGNITIVE ASSESSMENT What procedure is applied to databases to remove ambiguous relationships and minimize database redundancy?

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

Which of the following stores data in objects?

COGNITIVE ASSESSMENT What company did Larry Ellison help found?

The data in a database environment belongs to and is shared, usually over a network, by an entire organization.

COGNITIVE ASSESSMENT What is a more user-friendly interface some users use instead of interacting directly with a DBMS?

E-forms seldom use a means to secure data while it is transported across a network.

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

In a file processing system, the records in one file always relate to the records in other files.

A relational database typically processes and summarizes large numbers of records efficiently.

COGNITIVE ASSESSMENT A data dictionary contains details about data. What term is used to describe this characteristic?

When users modify data in a database, they make changes to multiple files instead of one file.

A relational database developer refers to a record as a relation.

Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?

Which of the following is an item that contains data, as well as the actions that read or process the data?

Each higher level of data consists of one or more items from the lower level.

In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

Which of the following, with regard to the entire database, should be made on a regular basis?

A data model defines how the operating system actually arranges the data on the disk.

A larger version of a data warehouse is the data mart.

COGNITIVE ASSESSMENT What procedure is applied to databases to remove ambiguous relationships and minimize database redundancy?

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