Question 1

SQL uses search operators such as ____ to form complex queries.

Accepted Answer

A)  AND 
B)  OR 
C)  NOT 
D)  all of the above 
A)  AND 
B)  OR 
C)  NOT 
D)  all of the above

Question 2

-In the query illustrated in the accompanying figure,the SELECT command is used to link the Albums and Tracks tables._________________________

Accepted Answer

A) True 
 B)False

Question 3

____ is the SQL command used to remove a record from a table.

Accepted Answer

A)  REMOVE 
B)  DELETE 
C)  PURGE 
D)  CUT 
A)  REMOVE 
B)  DELETE 
C)  PURGE 
D)  CUT

Question 4

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 5

In an SQL query,a ____ clause is used to specify the table you want to access.

Accepted Answer

A)  SELECT 
B)  WHICH 
C)  FROM 
D)  JOIN 
A)  SELECT 
B)  WHICH 
C)  FROM 
D)  JOIN

Question 6

A field ____ is a template that adds the correct formatting as data is entered.

Accepted Answer

A)  format 
B)  roster 
C)  validation 
D)  screen 
A)  format 
B)  roster 
C)  validation 
D)  screen

Question 7

____________________ Web publishing is a process that generates customized Web pages as needed,or "on the fly."

Accepted Answer

The answer of ____________________ Web publishing is a process that...

Question 8

XML is a markup language that allows field tags,data,and tables to be incorporated into a Web document._________________________

Accepted Answer

A) True 
 B)False

Question 9

-You can query by ____ using a fill-in form,like the one shown in the accompanying figure.

Accepted Answer

A)  example 
B)  model 
C)  format 
D)  function 
A)  example 
B)  model 
C)  format 
D)  function

Question 10

Sorted tables typically produce slower queries and updates than unsorted tables.

Accepted Answer

A) True 
 B)False

Question 11

In business, the goal is to choose the best data management tool to meet the needs of the business. Margaret is taking over the task of managing her company’s information needs. She knows that the best tool depends on several factors, including cost, versatility, and ease of use.
-Margaret is considering purchasing a custom software package.Which of the following will be true?

Accepted Answer

A)  The predefined fields mean easy programming and setup. 
B)  It would be best for simple flat files that involve calculations. 
C)  Such software will likely involve a steep learning curve. 
D)  The cost of development is generally high,but the result will be versatile. 
A)  The predefined fields mean easy programming and setup. 
B)  It would be best for simple flat files that involve calculations. 
C)  Such software will likely involve a steep learning curve. 
D)  The cost of development is generally high,but the result will be versatile.

Question 12

A ____ update changes data in more than one record at a time.

Accepted Answer

A)  mass 
B)  global 
C)  primary 
D)  key 
A)  mass 
B)  global 
C)  primary 
D)  key

Question 13

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 14

Poorly designed custom database software can result in data independence._________________________

Accepted Answer

A) True 
 B)False

Question 15

In the context of object-oriented databases,a(n)____________________ defines a group of objects by specifying the attributes and methods these objects share.

Accepted Answer

The answer of In the context of object-oriented databases,a(n)____________________ defines...

Question 16

The term XML refers to software that is designed to manage data stored in a database._________________________

Accepted Answer

A) True 
 B)False

Question 17

In the world of databases,a(n)____ refers to a collection of data fields.

Accepted Answer

A)  record 
B)  format 
C)  structure 
D)  index 
A)  record 
B)  format 
C)  structure 
D)  index

Question 18

The logical data type is used for true/false or yes/no data.

Accepted Answer

A) True 
 B)False

Question 19

Data ____ means that data are separate from the programs used to manipulate the data.

Accepted Answer

A)  dependence 
B)  independence 
C)  reliance 
D)  autonomy 
A)  dependence 
B)  independence 
C)  reliance 
D)  autonomy

Question 20

A(n)____________________ key is a field that contains data unique to a record.

Accepted Answer

The answer of A(n)____________________ key is a field that contains...

SQL uses search operators such as ____ to form complex queries.

-In the query illustrated in the accompanying figure,the SELECT command is used to link the Albums and Tracks tables._________________________

____ is the SQL command used to remove a record from a table.

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

In an SQL query,a ____ clause is used to specify the table you want to access.

A field ____ is a template that adds the correct formatting as data is entered.

____________________ Web publishing is a process that generates customized Web pages as needed,or "on the fly."

XML is a markup language that allows field tags,data,and tables to be incorporated into a Web document._________________________

-You can query by ____ using a fill-in form,like the one shown in the accompanying figure.

Sorted tables typically produce slower queries and updates than unsorted tables.

A ____ update changes data in more than one record at a time.

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

Poorly designed custom database software can result in data independence._________________________

In the context of object-oriented databases,a(n)____________________ defines a group of objects by specifying the attributes and methods these objects share.

The term XML refers to software that is designed to manage data stored in a database._________________________

In the world of databases,a(n)____ refers to a collection of data fields.

The logical data type is used for true/false or yes/no data.

Data ____ means that data are separate from the programs used to manipulate the data.

A(n)____________________ key is a field that contains data unique to a record.

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

SQL uses search operators such as ____ to form complex queries.

-In the query illustrated in the accompanying figure,the SELECT command is used to link the Albums and Tracks tables._________________________

____ is the SQL command used to remove a record from a table.

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

In an SQL query,a ____ clause is used to specify the table you want to access.

A field ____ is a template that adds the correct formatting as data is entered.

____________________ Web publishing is a process that generates customized Web pages as needed,or "on the fly."

XML is a markup language that allows field tags,data,and tables to be incorporated into a Web document._________________________

-You can query by ____ using a fill-in form,like the one shown in the accompanying figure.

Sorted tables typically produce slower queries and updates than unsorted tables.

A ____ update changes data in more than one record at a time.

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

Poorly designed custom database software can result in data independence._________________________

In the context of object-oriented databases,a(n)____________________ defines a group of objects by specifying the attributes and methods these objects share.

The term XML refers to software that is designed to manage data stored in a database._________________________

In the world of databases,a(n)____ refers to a collection of data fields.

The logical data type is used for true/false or yes/no data.

Data ____ means that data are separate from the programs used to manipulate the data.

A(n)____________________ key is a field that contains data unique to a record.

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