FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

Case Based Critical Thinking Questions Case 1 Janet is working in a music store called WebMusic that sells CDs. Most of the CDs in the store are listed in the database. Most of the customers are also listed. As the database designer, she has defined fields for the database. The kind of record the customer information is listed under is referred to as a ____.

A) field name
B) record occurrence
C) record type
D) table

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 42

Matching

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition.

Premises

Responses

Establishes which fields and records a particular user is allowed to access

record

flat file

validation

field name

data view

object-relational database

data type

variable-length field

parameter

integer

computed

normalization

field

database audit

access control

Premises

Establishes which fields and records a particular user is allowed to access

Responses

record

flat file

validation

field name

data view

object-relational database

data type

variable-length field

parameter

integer

computed

normalization

field

database audit

access control

Show Answer

Correct Answer

Premises

Responses

record

flat file

validation

field name

data view

object-relational database

data type

variable-length field

parameter

integer

computed

normalization

field

database audit

access control

Premises

record

flat file

validation

field name

data view

object-relational database

data type

variable-length field

parameter

integer

computed

normalization

field

database audit

access control

Responses

Question 43

True/False

Review LaterAdd Note

A(n) index simply points to the record where the data can be found.

Poorly designed custom software can result in data independence .

Identify the letter of the choice that best matches the phrase or definition.

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

Telephone numbers and ZIP codes are examples of data that should be stored in a field with the numeric data type.

What is an object database?

In SQL terminology, creating a relationship between tables is referred to as ____ tables.

The data accessed by data mining and other analysis techniques is often stored in a data ____.

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. To change the contents of a record in a database, you use the ____ command.

____ is a query language.

Case Based Critical Thinking Questions Case 1 Janet is working in a music store called WebMusic that sells CDs. Most of the CDs in the store are listed in the database. Most of the customers are also listed. As the database designer, she has defined fields for the database. In the WebMusic database, all the records of the previous and current CD orders are listed for each customer. The basic information such as name, address, phone, and e-mail are listed for each customer. The relationship of the customer and the different CD orders is a ____ relationship.

Identify the letter of the choice that best matches the phrase or definition.

Database ____ software is designed to manage billions of records and several hundred transactions per second.

Data ____ means that data is stored separately from the programs that are used to manipulate the data.

SQL can be used to create all of the following EXCEPT ____.

Criminals have become sophisticated in the use of all of the following EXCEPT ____ to access data stored on personal computers.

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

All of the following are examples of database server software EXCEPT ____.