Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A single,two-dimensional table of data elements

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

The ____ data type would be appropriate for a fixed-length field designed to hold a person's name.

Accepted Answer

A)  memo 
B)  real 
C)  text 
D)  logical 
A)  memo 
B)  real 
C)  text 
D)  logical

Question 4

An encrypted database is more efficient than an unencrypted database.

Accepted Answer

A) True 
 B)False

Question 5

____ are detailed specifications for an SQL command.

Accepted Answer

A)  Perimeters 
B)  Parameters 
C)  Boundaries 
D)  Limits 
A)  Perimeters 
B)  Parameters 
C)  Boundaries 
D)  Limits

Question 6

The ____ database model uses a mesh-like structure,which allows for the definition of many-to-many relationships.

Accepted Answer

A)  hierarchical 
B)  network 
C)  parent-child 
D)  duplex 
A)  hierarchical 
B)  network 
C)  parent-child 
D)  duplex

Question 7

A(n)____________________ is a procedure that monitors and records user activity within a database.

Accepted Answer

database a

Question 8

The SQL query language provides a collection of special command words called SQL ____________________,such as SELECT,FROM,INSERT,and WHERE.

Accepted Answer

The answer of The SQL query language provides a collection...

Question 9

A field ____ rule is a specification that the database designer sets up to filter the data entered into a particular field.

Accepted Answer

A)  cardinality 
B)  validation 
C)  structure 
D)  filter 
A)  cardinality 
B)  validation 
C)  structure 
D)  filter

Question 10

In a flat file,each row in the table is a(n) field_________________________

Accepted Answer

A) True 
 B)False

Question 11

It is possible to enter data as a(n)____ text file and then use a programming language to write routines to access that data.

Accepted Answer

A)  binary 
B)  primary key 
C)  relational 
D)  ASCII 
A)  binary 
B)  primary key 
C)  relational 
D)  ASCII

Question 12

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 13

Describe the seven principles that contribute to good user interface design.

Accepted Answer

A well-defined user interface for a data

Question 14

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 15

Which of the following has the least versatility?

Accepted Answer

A)  database software 
B)  custom software 
C)  spreadsheet software 
D)  dedicated software 
A)  database software 
B)  custom software 
C)  spreadsheet software 
D)  dedicated software

Question 16

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 17

WebMusic’s database designer, Janet, has hired an intern. She has requested that this intern create some SQL queries that would be useful to managers tracking the day-to-day operations of the store.
-The intern needs to complete the following query so that it draws data from two different tables.Which command should she use to complete the query?
SELECT FROM Albums ____ Tracks ON Albums.Cat# = Tracks.Cat#

Accepted Answer

A)  AND 
B)  INSERT 
C)  JOIN 
D)  UPDATE 
A)  AND 
B)  INSERT 
C)  JOIN 
D)  UPDATE

Question 18

In database jargon,a(n) relationship is an association between data that is stored in different record types._________________________

Accepted Answer

A) True 
 B)False

Question 19

With a(n)____ database,the database is stored on several different computers,on multiple networks,or in different geographical locations.

Accepted Answer

A)  distributed 
B)  object 
C)  network 
D)  relational 
A)  distributed 
B)  object 
C)  network 
D)  relational

Question 20

A(n)____________________ database is one which is stored on several computers,on multiple networks,or in different geographical locations.

Accepted Answer

The answer of A(n)____________________ database is one which is stored...

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A single,two-dimensional table of data elements

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

The ____ data type would be appropriate for a fixed-length field designed to hold a person's name.

An encrypted database is more efficient than an unencrypted database.

____ are detailed specifications for an SQL command.

The ____ database model uses a mesh-like structure,which allows for the definition of many-to-many relationships.

A(n)____________________ is a procedure that monitors and records user activity within a database.

The SQL query language provides a collection of special command words called SQL ____________________,such as SELECT,FROM,INSERT,and WHERE.

A field ____ rule is a specification that the database designer sets up to filter the data entered into a particular field.

In a flat file,each row in the table is a(n) field_________________________

It is possible to enter data as a(n)____ text file and then use a programming language to write routines to access that data.

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

Describe the seven principles that contribute to good user interface design.

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

Which of the following has the least versatility?

A database audit can ____.

In database jargon,a(n) relationship is an association between data that is stored in different record types._________________________

With a(n)____ database,the database is stored on several different computers,on multiple networks,or in different geographical locations.

A(n)____________________ database is one which is stored on several computers,on multiple networks,or in different geographical locations.

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. -A single,two-dimensional table of data elements

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

The ____ data type would be appropriate for a fixed-length field designed to hold a person's name.

An encrypted database is more efficient than an unencrypted database.

____ are detailed specifications for an SQL command.

The ____ database model uses a mesh-like structure,which allows for the definition of many-to-many relationships.

A(n)____________________ is a procedure that monitors and records user activity within a database.

The SQL query language provides a collection of special command words called SQL ____________________,such as SELECT,FROM,INSERT,and WHERE.

A field ____ rule is a specification that the database designer sets up to filter the data entered into a particular field.

In a flat file,each row in the table is a(n) field_________________________

It is possible to enter data as a(n)____ text file and then use a programming language to write routines to access that data.

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

Describe the seven principles that contribute to good user interface design.

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

Which of the following has the least versatility?

A database audit can ____.

In database jargon,a(n) relationship is an association between data that is stored in different record types._________________________

With a(n)____ database,the database is stored on several different computers,on multiple networks,or in different geographical locations.

A(n)____________________ database is one which is stored on several computers,on multiple networks,or in different geographical locations.

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