Question 1

All of the following are tools to help you create server-side programs EXCEPT ____.

Accepted Answer

A)  ASP 
B)  JavaScript 
C)  CGI 
D)  PHP 
A)  ASP 
B)  JavaScript 
C)  CGI 
D)  PHP

Question 2

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 3

Critical Thinking questions (Multiple Choice) You want to take advantage of the relationship between two tables in a relational database. First, you must ____.

Accepted Answer

A)  join the tables 
B)  copy the information into a separate document 
C)  reorder the fields 
D)  empty the tables 
A)  join the tables 
B)  copy the information into a separate document 
C)  reorder the fields 
D)  empty the tables

Question 4

The average American is in 5-10 databases.

Accepted Answer

A) True 
 B)False

Question 5

A ____ data type usually provides a variable-length field into which users can enter comments.

Accepted Answer

A)  text 
B)  character 
C)  memo 
D)  string 
A)  text 
B)  character 
C)  memo 
D)  string

Question 6

It is easy to query an encrypted database.

Accepted Answer

A) True 
 B)False

Question 7

The sort key for a database is typically specified by the database designer at the time the database ____________________ is created.

Accepted Answer

The answer of The sort key for a database is...

Question 8

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

Accepted Answer

The answer of A lookup ____________________ validates an entry by...

Question 9

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 10

A record is the basic building block for a structured file or database.

Accepted Answer

A) True 
 B)False

Question 11

A field ____________________ helps maintain consistent data by providing a structure for entering data into a field.

Accepted Answer

The answer of A field ____________________ helps maintain consistent data...

Question 12

What is a report generator?

Accepted Answer

A report generator i

Question 13

Although encryption cannot prevent a database from being lost or stolen, it can make the data it contains unintelligible to a hacker.

Accepted Answer

A) True 
 B)False

Question 14

Each ____ is a sequence, or list, of records in a relational database.

Accepted Answer

A)  sort 
B)  tuple 
C)  table 
D)  attribute 
A)  sort 
B)  tuple 
C)  table 
D)  attribute

Question 15

In SQL, the INSERT command is used to add a record.

Accepted Answer

A) True 
 B)False

Question 16

Dynamic Web publishing allows you to take a snapshot of the data in a database by generating a report, which is converted into an HTML document.

Accepted Answer

A) True 
 B)False

Question 17

An index has no bearing on the physical sequence of records on disk.

Accepted Answer

A) True 
 B)False

Question 18

Case 4 The SQL query language provides a collection of special command words called SQL keywords. With these keywords, SQL can be used to specify the action that should be carried out in the database. People want to know if CDs of their favorite artists are available at WebMusic, and if they can buy them for the discount price of less than $10.00. In SQL, search operators such as AND, OR, and NOT can be used to perform the queries. What are these operators referred to as?

Accepted Answer

A)  Boolean operators 
B)  join operators 
C)  parameter operators 
D)  SQL operators 
A)  Boolean operators 
B)  join operators 
C)  parameter operators 
D)  SQL operators

Question 19

Database fields are always variable in length.

Accepted Answer

A) True 
 B)False

Question 20

What SQL command removes a record from a table?

Accepted Answer

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

All of the following are tools to help you create server-side programs EXCEPT ____.

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

Critical Thinking questions (Multiple Choice) You want to take advantage of the relationship between two tables in a relational database. First, you must ____.

The average American is in 5-10 databases.

A ____ data type usually provides a variable-length field into which users can enter comments.

It is easy to query an encrypted database.

The sort key for a database is typically specified by the database designer at the time the database ____________________ is created.

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

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

A record is the basic building block for a structured file or database.

A field ____________________ helps maintain consistent data by providing a structure for entering data into a field.

What is a report generator?

Although encryption cannot prevent a database from being lost or stolen, it can make the data it contains unintelligible to a hacker.

Each ____ is a sequence, or list, of records in a relational database.

In SQL, the INSERT command is used to add a record.

Dynamic Web publishing allows you to take a snapshot of the data in a database by generating a report, which is converted into an HTML document.

An index has no bearing on the physical sequence of records on disk.

Database fields are always variable in length.

What SQL command removes a record from a table?

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

All of the following are tools to help you create server-side programs EXCEPT ____.

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

Critical Thinking questions (Multiple Choice) You want to take advantage of the relationship between two tables in a relational database. First, you must ____.

The average American is in 5-10 databases.

A ____ data type usually provides a variable-length field into which users can enter comments.

It is easy to query an encrypted database.

The sort key for a database is typically specified by the database designer at the time the database ____________________ is created.

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

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

A record is the basic building block for a structured file or database.

A field ____________________ helps maintain consistent data by providing a structure for entering data into a field.

What is a report generator?

Although encryption cannot prevent a database from being lost or stolen, it can make the data it contains unintelligible to a hacker.

Each ____ is a sequence, or list, of records in a relational database.

In SQL, the INSERT command is used to add a record.

Dynamic Web publishing allows you to take a snapshot of the data in a database by generating a report, which is converted into an HTML document.

An index has no bearing on the physical sequence of records on disk.

Database fields are always variable in length.

What SQL command removes a record from a table?

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