Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Much like an accordion,expanding to fit the data being entered

Accepted Answer

A) field 
B) record 
C) database audit 
D) data view 
E) data type
F)computed
G)validation
H)normalization
I)ERD
J)integer
K)variable-length field
L)flat file 
A) field 
B) record 
C) database audit 
D) data view 
E) data type
F)computed
G)validation
H)normalization
I)ERD
J)integer
K)variable-length field
L)flat file K

Question 2

-In the relationship in the ____ row of the accompanying figure,one record in a particular record type can be related to many records in another record type,and vice versa.

Accepted Answer

A)  top 
B)  middle 
C)  bottom 
D)  No such relationship is shown in the accompanying figure 
A)  top 
B)  middle 
C)  bottom 
D)  No such relationship is shown in the accompanying figure B

Question 3

The ____ operator specifies that both of the search criteria must be true for the record to be selected.

Accepted Answer

A)  ALL 
B)  NONE 
C)  NOT 
D)  AND 
A)  ALL 
B)  NONE 
C)  NOT 
D)  AND D

Question 4

A(n)____ is an association between data that is stored in different record types.

Accepted Answer

A)  method 
B)  table 
C)  relationship 
D)  attribute 
A)  method 
B)  table 
C)  relationship 
D)  attribute

Question 5

To provide a quality database interface,a designer might ____.

Accepted Answer

A)  arrange fields in a logical order 
B)  minimize on-screen instructions to save space 
C)  position entry areas randomly 
D)  use only one type of control on the interface 
A)  arrange fields in a logical order 
B)  minimize on-screen instructions to save space 
C)  position entry areas randomly 
D)  use only one type of control on the interface

Question 6

Each column of a relational database table is equivalent to a(n)____________________.

Accepted Answer

The answer of Each column of a relational database table...

Question 7

A record contains the smallest unit of meaningful information.

Accepted Answer

A) True 
 B)False

Question 8

A(n)index simply points to the record where the data can be found._________________________

Accepted Answer

A) True 
 B)False

Question 9

Surveys show that as many as ____ of businesses never change the standard administrator password for a DBMS.

Accepted Answer

A)  5% 
B)  10% 
C)  15% 
D)  25% 
A)  5% 
B)  10% 
C)  15% 
D)  25%

Question 10

In a(n)case sensitive database,uppercase letters are not equivalent to their lowercase counterparts._________________________

Accepted Answer

A) True 
 B)False

Question 11

A ____ establishes which fields and records a particular user may access.

Accepted Answer

A)  dataset 
B)  data view 
C)  user privilege 
D)  user view 
A)  dataset 
B)  data view 
C)  user privilege 
D)  user view

Question 12

A(n)____________________ database stores data in a collection of related tables.

Accepted Answer

The answer of A(n)____________________ database stores data in a collection...

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A whole number

Accepted Answer

A) field 
B) record 
C) database audit 
D) data view 
E) data type
F)computed
G)validation
H)normalization
I)ERD
J)integer
K)variable-length field
L)flat file 
A) field 
B) record 
C) database audit 
D) data view 
E) data type
F)computed
G)validation
H)normalization
I)ERD
J)integer
K)variable-length field
L)flat file

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Process used by database designers to create a database structure that can save storage space and increase processing efficiency

Accepted Answer

A) field 
B) record 
C) database audit 
D) data view 
E) data type
F)computed
G)validation
H)normalization
I)ERD
J)integer
K)variable-length field
L)flat file 
A) field 
B) record 
C) database audit 
D) data view 
E) data type
F)computed
G)validation
H)normalization
I)ERD
J)integer
K)variable-length field
L)flat file

Question 15

A database audit can ____.

Accepted Answer

A)  maintain accountability 
B)  trace the source of errors 
C)  make comprehensive corrections 
D)  all of the above 
A)  maintain accountability 
B)  trace the source of errors 
C)  make comprehensive corrections 
D)  all of the above

Question 16

-In a(n)relational database,relationships are specified by joining common data stored in the fields of records in different tables._________________________

Accepted Answer

A) True 
 B)False

Question 17

In the broadest definition,a(n)____ is a collection of information.

Accepted Answer

A)  index 
B)  database 
C)  hierarchy 
D)  field 
A)  index 
B)  database 
C)  hierarchy 
D)  field

Question 18

User privileges delineate which fields and records a particular user is allowed to read.

Accepted Answer

A) True 
 B)False

Question 19

-In the accompanying figure,the relationship shown in the bottom row is a many-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 20

The ____ data type is used to store true/false or yes/no data using minimal storage space.

Accepted Answer

A)  yes 
B)  logical 
C)  memo 
D)  true 
A)  yes 
B)  logical 
C)  memo 
D)  true

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Much like an accordion,expanding to fit the data being entered

-In the relationship in the ____ row of the accompanying figure,one record in a particular record type can be related to many records in another record type,and vice versa.

The ____ operator specifies that both of the search criteria must be true for the record to be selected.

A(n)____ is an association between data that is stored in different record types.

To provide a quality database interface,a designer might ____.

Each column of a relational database table is equivalent to a(n)____________________.

A record contains the smallest unit of meaningful information.

A(n)index simply points to the record where the data can be found._________________________

Surveys show that as many as ____ of businesses never change the standard administrator password for a DBMS.

In a(n)case sensitive database,uppercase letters are not equivalent to their lowercase counterparts._________________________

A ____ establishes which fields and records a particular user may access.

A(n)____________________ database stores data in a collection of related tables.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A whole number

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Process used by database designers to create a database structure that can save storage space and increase processing efficiency

A database audit can ____.

-In a(n)relational database,relationships are specified by joining common data stored in the fields of records in different tables._________________________

In the broadest definition,a(n)____ is a collection of information.

User privileges delineate which fields and records a particular user is allowed to read.

-In the accompanying figure,the relationship shown in the bottom row is a many-to-many relationship.

The ____ data type is used to store true/false or yes/no data using minimal storage space.

Computers and Digital Basics

Computer Hardware

Software

Operating Systems and File Management

Local Area Networks

The Internet

The Web and E-Mail

Digital Media

The Computer Industry: History, careers, and Ethics

Information Systems Analysis and Design

Computer Programming

Filters

Exam 11: Databases

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Much like an accordion,expanding to fit the data being entered

-In the relationship in the ____ row of the accompanying figure,one record in a particular record type can be related to many records in another record type,and vice versa.

The ____ operator specifies that both of the search criteria must be true for the record to be selected.

A(n)____ is an association between data that is stored in different record types.

To provide a quality database interface,a designer might ____.

Each column of a relational database table is equivalent to a(n)____________________.

A record contains the smallest unit of meaningful information.

A(n)index simply points to the record where the data can be found._________________________

Surveys show that as many as ____ of businesses never change the standard administrator password for a DBMS.

In a(n)case sensitive database,uppercase letters are not equivalent to their lowercase counterparts._________________________

A ____ establishes which fields and records a particular user may access.

A(n)____________________ database stores data in a collection of related tables.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A whole number

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Process used by database designers to create a database structure that can save storage space and increase processing efficiency

A database audit can ____.

-In a(n)relational database,relationships are specified by joining common data stored in the fields of records in different tables._________________________

In the broadest definition,a(n)____ is a collection of information.

User privileges delineate which fields and records a particular user is allowed to read.

-In the accompanying figure,the relationship shown in the bottom row is a many-to-many relationship.

The ____ data type is used to store true/false or yes/no data using minimal storage space.

Computers and Digital Basics

Computer Hardware

Software

Operating Systems and File Management

Local Area Networks

The Internet

The Web and E-Mail

Digital Media

The Computer Industry: History, careers, and Ethics

Information Systems Analysis and Design

Computer Programming

Filters