Question 1

What does the JOIN command allow you to do in SQL?

Accepted Answer

The SQL JOIN command allows yo

Question 2

____ allows decision makers to look for relationships between multiple data dimensions.

Accepted Answer

A)  Database models 
B)  Flat file 
C)  Unstructured files 
D)  OLAP 
A)  Database models 
B)  Flat file 
C)  Unstructured files 
D)  OLAP

Question 3

Queries within an unsorted database are slow because the only algorithm for searching an unsorted table requires a sequential look at each record.

Accepted Answer

A) True 
 B)False

Question 4

Critical Thinking questions (Multiple Choice) Which of the following is a true statement?

Accepted Answer

A)  No computer system can be 100% secure. 
B)  The act of processing queries for a database can sometimes reveal information to savvy hackers. 
C)  Encryption offers full protection. 
D)  It is difficult to query an encrypted database. 
A)  No computer system can be 100% secure. 
B)  The act of processing queries for a database can sometimes reveal information to savvy hackers. 
C)  Encryption offers full protection. 
D)  It is difficult to query an encrypted database.

Question 5

What is the purpose of tracking who makes changes in a database?

Accepted Answer

This helps an organization mai

Question 6

Relationships between record types can be graphically depicted, as shown in the figure above, using a(n) ____.

Accepted Answer

A)  DRE 
B)  ERD 
C)  EDR 
D)  GRD 
A)  DRE 
B)  ERD 
C)  EDR 
D)  GRD

Question 7

Which of the following designates records that meet one of a set of two criteria, or both?

Accepted Answer

A)  inclusive OR 
B)  AND 
C)  exclusive OR 
D)  NOT 
A)  inclusive OR 
B)  AND 
C)  exclusive OR 
D)  NOT

Question 8

A ____ is a collection of binary data that is stored in a single field of a database.

Accepted Answer

A)  MSRP 
B)  computed field 
C)  logical field 
D)  BLOB 
A)  MSRP 
B)  computed field 
C)  logical field 
D)  BLOB

Question 9

Match between columns
                        Premises: The smallest unit of meaningful information

Accepted Answer

The Answer of database audit and data type and computed is...

Question 10

A fixed-length field contains a predetermined number of ____.

Accepted Answer

A)  bits 
B)  units 
C)  pixels 
D)  bytes 
A)  bits 
B)  units 
C)  pixels 
D)  bytes

Question 11

Match between columns
                        Premises: Procedure that monitors and records user activity within a database

Accepted Answer

The Answer of flat file and variable-length field and integer is...

Question 12

Case 3 There is the database designer and the people who enter the data. Sometimes this is the same person, but in Kate's large banking firm, the actual database entries are not made by the people who designed the database. A data entry operator might enter a telephone number as 555-555-7777, (555) 555-7777, or 1-555-555-7777. If multiple data entry operators enter telephone numbers in different reports, it becomes difficult to produce nicely formatted reports or locate a particular telephone number. To prevent inconsistent formatting, a database designer can specify a ____, so that now if someone attempts to enter data in the wrong format, the database rejects that entry.

Accepted Answer

A)  field format 
B)  field validation rule 
C)  lookup routine 
D)  structured query 
A)  field format 
B)  field validation rule 
C)  lookup routine 
D)  structured query

Question 13

Data ____ refers to the process of analyzing information in databases to discover previously unknown and potentially useful information.

Accepted Answer

A)  leading 
B)  mining 
C)  tracking 
D)  warehousing 
A)  leading 
B)  mining 
C)  tracking 
D)  warehousing

Question 14

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. Working with the WebMusic company database, which command is selected for using the data from two tables as in: SELECT FROM CompactDisks ____ Tracks ON CompactDisks.ItemNumber = Tracks.ItemNumber?

Accepted Answer

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

Question 15

Match between columns
                        Premises: Refers to the detailed specifications for a command

Accepted Answer

The Answer of integer and variable-length field and flat file is...

Question 16

A record that contains data is referred to as a record ____.

Accepted Answer

A)  type 
B)  occurrence 
C)  stock 
D)  catalog 
A)  type 
B)  occurrence 
C)  stock 
D)  catalog

Question 17

Match between columns
                        Premises: Efficiently designed databases use this type of field whenever possible

Accepted Answer

The Answer of parameter and object-relational database and database audit is...

Question 18

The ____ database model uses a mesh-like structure to offer the additional capacity to define 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 19

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

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ limits access to systems such as computer databases.

Accepted Answer

The answer of A(n) ____________________ limits access to systems such...

What does the JOIN command allow you to do in SQL?

____ allows decision makers to look for relationships between multiple data dimensions.

Queries within an unsorted database are slow because the only algorithm for searching an unsorted table requires a sequential look at each record.

Critical Thinking questions (Multiple Choice) Which of the following is a true statement?

What is the purpose of tracking who makes changes in a database?

Relationships between record types can be graphically depicted, as shown in the figure above, using a(n) ____.

Which of the following designates records that meet one of a set of two criteria, or both?

A ____ is a collection of binary data that is stored in a single field of a database.

A fixed-length field contains a predetermined number of ____.

Data ____ refers to the process of analyzing information in databases to discover previously unknown and potentially useful information.

A record that contains data is referred to as a record ____.

The ____ database model uses a mesh-like structure to offer the additional capacity to define many-to-many relationships.

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

A(n) ____________________ limits access to systems such as computer databases.

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

What does the JOIN command allow you to do in SQL?

____ allows decision makers to look for relationships between multiple data dimensions.

Queries within an unsorted database are slow because the only algorithm for searching an unsorted table requires a sequential look at each record.

Critical Thinking questions (Multiple Choice) Which of the following is a true statement?

What is the purpose of tracking who makes changes in a database?

Relationships between record types can be graphically depicted, as shown in the figure above, using a(n) ____.

Which of the following designates records that meet one of a set of two criteria, or both?

A ____ is a collection of binary data that is stored in a single field of a database.

A fixed-length field contains a predetermined number of ____.

Data ____ refers to the process of analyzing information in databases to discover previously unknown and potentially useful information.

A record that contains data is referred to as a record ____.

The ____ database model uses a mesh-like structure to offer the additional capacity to define many-to-many relationships.

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

A(n) ____________________ limits access to systems such as computer databases.

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