Question 1

Critical Thinking questions (Multiple Choice) Based on the following query: SELECT AlbumTitle FROM Albums WHERE ArtistName = 'Jefferson Airplane' AND DiscountPrice

Accepted Answer

A)  if the ArtistName field contains Jefferson Airplane 
B)  if the value in the DiscountPrice field is less than $10.00 
C)  if the ArtistName field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00 
D)  if the ArtistTitle field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00 
A)  if the ArtistName field contains Jefferson Airplane 
B)  if the value in the DiscountPrice field is less than $10.00 
C)  if the ArtistName field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00 
D)  if the ArtistTitle field contains Jefferson Airplane and the value in the DiscountPrice field is less than $10.00 C

Question 2

Match between columns
                        Premises: A structured file that contains only one record type

Accepted Answer

The Answer of field name and variable-length field and integer is...

Question 3

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 B

Question 4

To create a flat file, you must use database management software.

Accepted Answer

A) True 
 B)False

Question 5

Case 2 In business, the goal is to choose the best data management tool. The best tool depends on several factors. When selecting a data management tool, consider its cost, versatility, and ease of use. Margaret is taking over the task of managing her company's information needs. One of her first tasks is to create the company's address book. Which software tool would be easy and require minimal setup with the fields predefined? Cost is not her concern.

Accepted Answer

A)  Custom software 
B)  Database software 
C)  Dedicated software 
D)  Word processing software 
A)  Custom software 
B)  Database software 
C)  Dedicated software 
D)  Word processing software

Question 6

A(n) many-to-many relationship means that a record in one record type is related to only one record in another record type.

Accepted Answer

A) True 
 B)False

Question 7

A table's ____ order is the order in which records are stored on disk.

Accepted Answer

A)  storage 
B)  sort 
C)  normal 
D)  linked 
A)  storage 
B)  sort 
C)  normal 
D)  linked

Question 8

The primary key for a table specifies the order in which records are stored, and where new records are inserted in a table.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following has the potential to add doubt about the veracity of database data?

Accepted Answer

A)  hacking 
B)  update errors 
C)  data entry errors 
D)  all of the above 
A)  hacking 
B)  update errors 
C)  data entry errors 
D)  all of the above

Question 10

Customers, clients, and most employers who use a database have an occasional need to change its structure by adding fields, changing field names, and setting keys.

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)  Unicode 
D)  ASCII 
A)  binary 
B)  primary key 
C)  Unicode 
D)  ASCII

Question 12

A(n) ____ relationship means that one record in a particular record type can be related to many records in another record type, and vice versa.

Accepted Answer

A)  many-to-many 
B)  cardinal 
C)  ordinal 
D)  one-to-one 
A)  many-to-many 
B)  cardinal 
C)  ordinal 
D)  one-to-one

Question 13

From a user perspective, the data ____________________ determines the way that data can be manipulated.

Accepted Answer

The answer of From a user perspective, the data ____________________...

Question 14

A ____ routine validates an entry by searching for the same data in a file or database table.

Accepted Answer

A)  validating 
B)  redundancy 
C)  lookup 
D)  normalizing 
A)  validating 
B)  redundancy 
C)  lookup 
D)  normalizing

Question 15

Case 2 In business, the goal is to choose the best data management tool. The best tool depends on several factors. When selecting a data management tool, consider its cost, versatility, and ease of use. Margaret is taking over the task of managing her company's information needs. The company has previously purchased custom software for organizing the many products and customer databases. Margaret has to decide if the company should continue to invest in this software. Can this database software be used by the company's workforce of varying skill levels? The ease of use of custom software can be characterized as ____.

Accepted Answer

A)  easy- minimal setup required because fields are predefined 
B)  easy- uses an interface familiar to most users 
C)  having a steep learning curve 
D)  being difficult to program, but the final result may be easy to use 
A)  easy- minimal setup required because fields are predefined 
B)  easy- uses an interface familiar to most users 
C)  having a steep learning curve 
D)  being difficult to program, but the final result may be easy to use

Question 16

One of the most common database operations is to query for a particular record or group of records using the ____ command.

Accepted Answer

A)  FIND 
B)  SELECT 
C)  GET 
D)  TAKE 
A)  FIND 
B)  SELECT 
C)  GET 
D)  TAKE

Question 17

The two tables shown in the above figure are ____ by the CustomerNumber field.

Accepted Answer

A)  merged 
B)  related 
C)  split 
D)  concatenated 
A)  merged 
B)  related 
C)  split 
D)  concatenated

Question 18

What is the SQL command to introduce a brand-new database or table?

Accepted Answer

A)  BUILD 
B)  NEW 
C)  CREATE 
D)  START 
A)  BUILD 
B)  NEW 
C)  CREATE 
D)  START

Question 19

A(n) ____________________ is optimized for the object-oriented database model.

Accepted Answer

object-oriented database manag

Question 20

A computed field is a calculation that a DBMS performs during processing.

Accepted Answer

A) True 
 B)False

Critical Thinking questions (Multiple Choice) Based on the following query: SELECT AlbumTitle FROM Albums WHERE ArtistName = 'Jefferson Airplane' AND DiscountPrice

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

To create a flat file, you must use database management software.

A(n) many-to-many relationship means that a record in one record type is related to only one record in another record type.

A table's ____ order is the order in which records are stored on disk.

The primary key for a table specifies the order in which records are stored, and where new records are inserted in a table.

Which of the following has the potential to add doubt about the veracity of database data?

Customers, clients, and most employers who use a database have an occasional need to change its structure by adding fields, changing field names, and setting keys.

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) ____ relationship means that one record in a particular record type can be related to many records in another record type, and vice versa.

From a user perspective, the data ____________________ determines the way that data can be manipulated.

A ____ routine validates an entry by searching for the same data in a file or database table.

One of the most common database operations is to query for a particular record or group of records using the ____ command.

The two tables shown in the above figure are ____ by the CustomerNumber field.

What is the SQL command to introduce a brand-new database or table?

A(n) ____________________ is optimized for the object-oriented database model.

A computed field is a calculation that a DBMS performs during processing.

Computers and Digital Basics

Computer Hardware

Computer Software

Operating Systems and File Management

Lans and Wlans

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

Critical Thinking questions (Multiple Choice) Based on the following query: SELECT AlbumTitle FROM Albums WHERE ArtistName = 'Jefferson Airplane' AND DiscountPrice

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

To create a flat file, you must use database management software.

A(n) many-to-many relationship means that a record in one record type is related to only one record in another record type.

A table's ____ order is the order in which records are stored on disk.

The primary key for a table specifies the order in which records are stored, and where new records are inserted in a table.

Which of the following has the potential to add doubt about the veracity of database data?

Customers, clients, and most employers who use a database have an occasional need to change its structure by adding fields, changing field names, and setting keys.

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) ____ relationship means that one record in a particular record type can be related to many records in another record type, and vice versa.

From a user perspective, the data ____________________ determines the way that data can be manipulated.

A ____ routine validates an entry by searching for the same data in a file or database table.

One of the most common database operations is to query for a particular record or group of records using the ____ command.

The two tables shown in the above figure are ____ by the CustomerNumber field.

What is the SQL command to introduce a brand-new database or table?

A(n) ____________________ is optimized for the object-oriented database model.

A computed field is a calculation that a DBMS performs during processing.

Computers and Digital Basics

Computer Hardware

Computer Software

Operating Systems and File Management

Lans and Wlans

The Internet

The Web and E-Mail

Digital Media

The Computer Industry: History, Careers, and Ethics

Information Systems Analysis and Design

Computer Programming

Filters