Question 1

A hypermedia database contains text links to other types of documents.

Accepted Answer

A) True 
 B)False

Question 2

A Web database usually resides on a(n) ____.

Accepted Answer

A)  intranet 
B)  extranet 
C)  database server 
D)  object-oriented server 
A)  intranet 
B)  extranet 
C)  database server 
D)  object-oriented server

Question 3

The developer of a relational database refers to a record as a(n) ____.

Accepted Answer

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

Question 4

A database includes a group of related data files.

Accepted Answer

A) True 
 B)False

Question 5

When a company uses the ____________________, many programs and users share the data in a database.

Accepted Answer

The answer of When a company uses the ____________________, many...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Writing a CGI script requires computer programming skills.

Accepted Answer

A) True 
 B)False

Question 8

Cost-effective information ____.

Accepted Answer

A)  gives more value than it costs to produce 
B)  is error free 
C)  is arranged to suit the needs and requirements of a decision maker 
D)  is available when a decision maker needs it 
A)  gives more value than it costs to produce 
B)  is error free 
C)  is arranged to suit the needs and requirements of a decision maker 
D)  is available when a decision maker needs it

Question 9

____ is a computer phrase that points out the accuracy of a computer's output depends on the accuracy of its input.

Accepted Answer

A)  Nothing ventured, nothing gained (NVNG) 
B)  Bad data, bad info (BDBI) 
C)  Garbage in, garbage out (GIGO) 
D)  What you see is what you get (WYSIWYG) 
A)  Nothing ventured, nothing gained (NVNG) 
B)  Bad data, bad info (BDBI) 
C)  Garbage in, garbage out (GIGO) 
D)  What you see is what you get (WYSIWYG)

Question 10

A(n) ____________________ stores data in objects.

Accepted Answer

object-ori

Question 11

Object (also called ____) is a common data type that includes photograph, audio, video, or a document created in other applications.

Accepted Answer

A)  Number 
B)  BLOB 
C)  Integer 
D)  Binary 
A)  Number 
B)  BLOB 
C)  Integer 
D)  Binary

Question 12

Match between columns
                        Premises: This database capability is one of the more powerful database features.
To simplify the query process, many DBMSs provide these to guide users through the steps of creating a query.
Often confirms the accuracy of a primary key value.
Can limit the type of data that can be entered, often allowing a user to select from a list.
Type of Web database that stores photos, videos, recordings and other personal media with other registered users
This data type is a unique number automatically assigned by a DBMS to each added record.
In addition to storing data, a relational database also stores these.
The database approach allows nontechnical users to access and maintain data, providing they have these.
Kind of rules that decrease data entry errors, and thus enhance the data's integrity.
When searching for data in a database, users often specify this.
While a user is working with the database, this resides in the memory of the computer.
Whether designed for a small or large computer, most DBMSs perform common ones.
If entered data fails this kind of check, the computer should display an error message that instructs the user to enter the data again.
This type of information can lead to incorrect decisions.
Kind of backup that is costly but which is growing in popularity because of the benefits.
Eight bits grouped together in a unit comprise this.
What is done to a record so the DBMS will not process it again.
The more errors the data contains, the lower this is.
Has special keywords and rules that users include in SQL statements.
Computers process information in a database into this.

Accepted Answer

The Answer of AutoNumber and check digit and relationships and is...

Question 13

In the past, few organizations exclusively used file processing systems to store and manage data.

Accepted Answer

A) True 
 B)False

Question 14

A DBMS places a copy of the record prior to a change, called the ____________________, in the log.

Accepted Answer

The answer of A DBMS places a copy of the...

Question 15

Occasionally, a database can be damaged or destroyed because of ____.

Accepted Answer

A)  hardware or software failure 
B)  human error 
C)  a catastrophe, such as a fire or flood 
D)  all of the above 
A)  hardware or software failure 
B)  human error 
C)  a catastrophe, such as a fire or flood 
D)  all of the above

Question 16

A(n) ____________________ consists of simple, English-like statements that allow users to specify the data to display, print, or store.

Accepted Answer

The answer of A(n) ____________________ consists of simple, English-like statements...

Question 17

A DBMS uses the ____ to perform validation checks.

Accepted Answer

A)  data server 
B)  data mart 
C)  data warehouse 
D)  data dictionary 
A)  data server 
B)  data mart 
C)  data warehouse 
D)  data dictionary

Question 18

More complex DBMSs maintain a(n) ____, which is a listing of activities that change the contents of a database.

Accepted Answer

A)  recovery utility 
B)  roster 
C)  backup plan 
D)  log 
A)  recovery utility 
B)  roster 
C)  backup plan 
D)  log

Question 19

The DBA does all of the following except ____.

Accepted Answer

A)  manage security of the database 
B)  monitor the performance of the database 
C)  check backup and recovery procedures 
D)  decide on the proper placement of fields 
A)  manage security of the database 
B)  monitor the performance of the database 
C)  check backup and recovery procedures 
D)  decide on the proper placement of fields

Question 20

DBMSs that maintain inactive data for an extended period of time seldom flag records.

Accepted Answer

A) True 
 B)False

A hypermedia database contains text links to other types of documents.

A Web database usually resides on a(n) ____.

The developer of a relational database refers to a record as a(n) ____.

A database includes a group of related data files.

When a company uses the ____________________, many programs and users share the data in a database.

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

Writing a CGI script requires computer programming skills.

Cost-effective information ____.

____ is a computer phrase that points out the accuracy of a computer's output depends on the accuracy of its input.

A(n) ____________________ stores data in objects.

Object (also called ____) is a common data type that includes photograph, audio, video, or a document created in other applications.

In the past, few organizations exclusively used file processing systems to store and manage data.

A DBMS places a copy of the record prior to a change, called the ____________________, in the log.

Occasionally, a database can be damaged or destroyed because of ____.

A(n) ____________________ consists of simple, English-like statements that allow users to specify the data to display, print, or store.

A DBMS uses the ____ to perform validation checks.

More complex DBMSs maintain a(n) ____, which is a listing of activities that change the contents of a database.

The DBA does all of the following except ____.

DBMSs that maintain inactive data for an extended period of time seldom flag records.

Introduction to Computers

The Internet and World Wide Web

Application Software

The Components of the System Unit

Input

Output

Storage

Operating Systems and Utility Programs

Communications and Networks

Computer Security, Ethics, and Privacy

Information System Development

Programming Languages and Program Development

Enterprise Computing

Computer Careers and Certification

Filters

Exam 10: Database Management

A hypermedia database contains text links to other types of documents.

A Web database usually resides on a(n) ____.

The developer of a relational database refers to a record as a(n) ____.

A database includes a group of related data files.

When a company uses the ____________________, many programs and users share the data in a database.

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

Writing a CGI script requires computer programming skills.

Cost-effective information ____.

____ is a computer phrase that points out the accuracy of a computer's output depends on the accuracy of its input.

A(n) ____________________ stores data in objects.

Object (also called ____) is a common data type that includes photograph, audio, video, or a document created in other applications.

In the past, few organizations exclusively used file processing systems to store and manage data.

A DBMS places a copy of the record prior to a change, called the ____________________, in the log.

Occasionally, a database can be damaged or destroyed because of ____.

A(n) ____________________ consists of simple, English-like statements that allow users to specify the data to display, print, or store.

A DBMS uses the ____ to perform validation checks.

More complex DBMSs maintain a(n) ____, which is a listing of activities that change the contents of a database.

The DBA does all of the following except ____.

DBMSs that maintain inactive data for an extended period of time seldom flag records.

Introduction to Computers

The Internet and World Wide Web

Application Software

The Components of the System Unit

Input

Output

Storage

Operating Systems and Utility Programs

Communications and Networks

Computer Security, Ethics, and Privacy

Information System Development

Programming Languages and Program Development

Enterprise Computing

Computer Careers and Certification

Filters