Question 1

When a company uses the file processing approach, many programs and users share data in a database.

Accepted Answer

A) True 
 B)False

Question 2

Compared with relational databases, which of the following is true of object-oriented databases?

Accepted Answer

A)  They can store more types of data 
B)  They access data faster 
C)  They allow programmers to reuse objects 
D)  all of the above 
A)  They can store more types of data 
B)  They access data faster 
C)  They allow programmers to reuse objects 
D)  all of the above

Question 3

COGNITIVE ASSESSMENT Define data redundancy.

Accepted Answer

A)  There is no primary key to distinguish records. 
B)  Each department has its own files, so the same data might be stored in multiple files. 
C)  Data is linked to multiple records in a database. 
D)  In the same database, each department enters data without checking to ensure it hasn't already been entered. 
A)  There is no primary key to distinguish records. 
B)  Each department has its own files, so the same data might be stored in multiple files. 
C)  Data is linked to multiple records in a database. 
D)  In the same database, each department enters data without checking to ensure it hasn't already been entered.

Question 4

An object-oriented database stores unstructured data less efficiently than a relational database.

Accepted Answer

A) True 
 B)False

Question 5

Some report generators allow you to create a Web page, which can be interactive.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A)  A relationship is a link within the data. 
B)  To set up a relationship between tables, they must have a common field. 
C)  Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing. 
D)  Applications best suited for relational databases are those whose data can be organized into a three-dimensional table. 
A)  A relationship is a link within the data. 
B)  To set up a relationship between tables, they must have a common field. 
C)  Many organizations use relational databases for payroll, accounts receivable, order entry, and invoicing. 
D)  Applications best suited for relational databases are those whose data can be organized into a three-dimensional table.

Question 8

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?

Accepted Answer

A)  Each table or file should contain data about one subject. 
B)  Create fields for every piece of data you might need, such as fields for Date and Age. 
C)  Every record needs a primary key. 
D)  Use separate fields for logically distinct items, such as First Name and Last Name. 
A)  Each table or file should contain data about one subject. 
B)  Create fields for every piece of data you might need, such as fields for Date and Age. 
C)  Every record needs a primary key. 
D)  Use separate fields for logically distinct items, such as First Name and Last Name.

Question 9

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

Accepted Answer

A)  guides you through the steps of creating a database object 
B)  the database creator and administrator 
C)  a screen in which you enter or modify data 
D)  the instructions that control how the data in the database is connected 
A)  guides you through the steps of creating a database object 
B)  the database creator and administrator 
C)  a screen in which you enter or modify data 
D)  the instructions that control how the data in the database is connected

Question 10

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

Accepted Answer

A)  XML 
B)  DBMS 
C)  SQL 
D)  QBE 
A)  XML 
B)  DBMS 
C)  SQL 
D)  QBE

Question 11

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

Accepted Answer

A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit 
A)  completeness 
B)  alphabetic 
C)  range 
D)  check digit

Question 12

In addition to accessing information, users can provide information to Web databases.

Accepted Answer

A) True 
 B)False

Question 13

COGNITIVE ASSESSMENT What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data?

Accepted Answer

A)  a database 
B)  information 
C)  a DBMS 
D)  access 
A)  a database 
B)  information 
C)  a DBMS 
D)  access

Question 14

Which of the following is a request for specific data from a database?

Accepted Answer

A)  query 
B)  index 
C)  ask 
D)  inquiry 
A)  query 
B)  index 
C)  ask 
D)  inquiry

Question 15

____________________ information has meaning to the person who receives it.

Accepted Answer

The answer of ____________________ information has meaning to the person...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Although the hardware and software costs to set up a database may seem expensive, long-term benefits exceed the initial costs.

Accepted Answer

A) True 
 B)False

Question 18

What is the process of comparing data with a set of rules or values to find out if the data is correct?

Accepted Answer

A)  Concatenation 
B)  Validation 
C)  Digit checking 
D)  Integration 
A)  Concatenation 
B)  Validation 
C)  Digit checking 
D)  Integration

Question 19

A Web database usually resides on a database server.

Accepted Answer

A) True 
 B)False

Question 20

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

Accepted Answer

A) True 
 B)False

When a company uses the file processing approach, many programs and users share data in a database.

Compared with relational databases, which of the following is true of object-oriented databases?

COGNITIVE ASSESSMENT Define data redundancy.

An object-oriented database stores unstructured data less efficiently than a relational database.

Some report generators allow you to create a Web page, which can be interactive.

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

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

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

In addition to accessing information, users can provide information to Web databases.

COGNITIVE ASSESSMENT What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data?

Which of the following is a request for specific data from a database?

____________________ information has meaning to the person who receives it.

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

Although the hardware and software costs to set up a database may seem expensive, long-term benefits exceed the initial costs.

What is the process of comparing data with a set of rules or values to find out if the data is correct?

A Web database usually resides on a database server.

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

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

When a company uses the file processing approach, many programs and users share data in a database.

Compared with relational databases, which of the following is true of object-oriented databases?

COGNITIVE ASSESSMENT Define data redundancy.

An object-oriented database stores unstructured data less efficiently than a relational database.

Some report generators allow you to create a Web page, which can be interactive.

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

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

COGNITIVE ASSESSMENT Which statement is not a recognized guideline for designing a database?

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

As shown in the accompanying figure, which of the following is a query language that allows users to manage, update, and retrieve data?

COGNITIVE ASSESSMENT If you are running a check to ensure that a required field contains data, or the correct minimum number of characters, what kind of check are you running?

In addition to accessing information, users can provide information to Web databases.

COGNITIVE ASSESSMENT What is the term for a collection of data organized in a manner that allows access, retrieval, and use of that data?

Which of the following is a request for specific data from a database?

____________________ information has meaning to the person who receives it.

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

Although the hardware and software costs to set up a database may seem expensive, long-term benefits exceed the initial costs.

What is the process of comparing data with a set of rules or values to find out if the data is correct?

A Web database usually resides on a database server.

In a relational database, the only data redundancy (duplication) exists in the common columns (fields) used for relationships.

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