Question 1

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Accepted Answer

A)   external
B)   conceptual
C)   internal
D)   metaE) B) and C)
F) None of the above

Question 2

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Accepted Answer

A)   Data Definition Language
B)   Data Manipulation Language
C)   Data Query Language
D)   Data Update LanguageE) All of the above
F) B) and D)

Question 3

Chelsana Washington is a medical equipment sales representative.Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country.She,and the other sales reps,have access to view customer and product information.They have access that allows them to enter and cancel customer orders.The permissions for Chelsana define a(an) ________ in the company's database management system.

Accepted Answer

A)   conceptual-level schema
B)   subschema
C)   data dictionary
D)   physical viewE) A) and B)
F) A) and C)

Question 4

Which one of the following results corresponds to the query below?

Accepted Answer

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

Question 5

What are the basic requirements when logically designing a relational database model?

Accepted Answer

Every row in every table must have a uni...

Question 6

Which would not generally be considered a data dictionary output report?

Accepted Answer

A)   A list of cash balances in the organization's bank accounts
B)   A list of all programs in which a data element is used
C)   A list of all synonyms for the data elements in a particular file
D)   A list of all data elements used by a particular userE) B) and D)
F) B) and C)

Question 7

The delete anomaly

Accepted Answer

A)   may result in unintentional loss of important data.
B)   is usually easily detected by users.
C)   restricts the addition of new records.
D)   prevents users from deleting outdated data from records or tables.E) A) and B)
F) A) and C)

Question 8

The physical view of a database system refers to

Accepted Answer

A)   how a user or programmer conceptually organizes and understands the data.
B)   how the DBMS accesses data for a certain application program.
C)   how and where the data are physically arranged and stored.
D)   how master files store data values used by more than one application program.E) None of the above
F) B) and D)

Question 9

In a relational database,requiring that every record in a table have a unique identifier is called the

Accepted Answer

A)   entity integrity rule.
B)   referential integrity rule.
C)   unique primary key rule.
D)   foreign key rule.E) All of the above
F) B) and D)

Question 10

A low-level view of the database that describes how the data are actually stored and accessed is the

Accepted Answer

A)   conceptual-level schema.
B)   subschema.
C)   internal-level schema.
D)   external-level schema.E) A) and C)
F) B) and C)

Question 11

The ________ contains information about the structure of the database.

Accepted Answer

A)   data definition language
B)   data dictionary
C)   data warehouse
D)   database management systemE) B) and D)
F) B) and C)

Question 12

Describe what you think will be the main impact of database technology in your career.

Accepted Answer

Answers to this question could cover a w...

Question 13

Reports produced using the data dictionary could include all of the following except a list of

Accepted Answer

A)   programs where a data item is used.
B)   synonyms for the data items in a particular file.
C)   outputs where a data element is used.
D)   the schemas included in a database.E) A) and B)
F) A) and C)

Question 14

The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the

Accepted Answer

A)   update anomaly.
B)   insert anomaly.
C)   inconsistency anomaly.
D)   delete anomaly.E) A) and D)
F) B) and C)

Question 15

A relational database in which customer data is not maintained independently of sales invoice data will most likely result in

Accepted Answer

A)   an update anomaly.
B)   an insert anomaly.
C)   a delete anomaly.
D)   an integrity anomaly.E) B) and C)
F) None of the above

Question 16

Which statement below is false regarding the basic requirements of the relational data model?

Accepted Answer

A)   Every column in a row must be single-valued.
B)   All non-key attributes in a table should describe a characteristic about the object identified by the primary key.
C)   Foreign keys, if not null, must have values that correspond to the value of a primary key in another table.
D)   Primary keys can be null.E) A) and B)
F) A) and C)

Question 17

The person responsible for the database is the

Accepted Answer

A)   data coordinator.
B)   database administrator.
C)   database manager.
D)   database master.E) A) and B)
F) All of the above

Question 18

The update anomaly in file-based systems or unnormalized database tables

Accepted Answer

A)   occurs because of data redundancy.
B)   restricts addition of new fields or attributes.
C)   results in records that cannot be updated.
D)   is usually easily detected by users.E) B) and D)
F) B) and C)

Question 19

The data dictionary usually is maintained

Accepted Answer

A)   automatically by the DBMS.
B)   by the database administrator.
C)   by the database programmers.
D)   by top management.E) A) and B)
F) All of the above

Question 20

The feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.is named the

Accepted Answer

A)   report writer.
B)   report generator.
C)   report creator.
D)   report printer.E) B) and D)
F) A) and C)

Exam 4: Relational Databases

Correct Answer
verified

The feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.is named the

Correct Answer
verified

The physical view of a database system refers to

Correct Answer
verified

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Correct Answer
verified

A low-level view of the database that describes how the data are actually stored and accessed is the

Correct Answer
verified

The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the

Correct Answer
verified

Reports produced using the data dictionary could include all of the following except a list of

Correct Answer
verified

The ________ contains information about the structure of the database.

Correct Answer
verified

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Correct Answer
verified

In a relational database,requiring that every record in a table have a unique identifier is called the

Correct Answer
verified

Which statement below is false regarding the basic requirements of the relational data model?

Correct Answer
verified

Which would not generally be considered a data dictionary output report?

Correct Answer
verified

A relational database in which customer data is not maintained independently of sales invoice data will most likely result in

Correct Answer
verified

What are the basic requirements when logically designing a relational database model?

Correct Answer
verified
Every row in every table must have a uni...
View Answer

The delete anomaly

Correct Answer
verified

The person responsible for the database is the

Correct Answer
verified

Describe what you think will be the main impact of database technology in your career.

Correct Answer
verified
Answers to this question could cover a w...
View Answer

The update anomaly in file-based systems or unnormalized database tables

Correct Answer
verified

Which one of the following results corresponds to the query below?

Correct Answer
verified

The data dictionary usually is maintained

Correct Answer
verified

Exam 4: Relational Databases

Correct AnswerverifiedShow Answer

The feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.is named the

Correct AnswerverifiedShow Answer

The physical view of a database system refers to

Correct AnswerverifiedShow Answer

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Correct AnswerverifiedShow Answer

A low-level view of the database that describes how the data are actually stored and accessed is the

Correct AnswerverifiedShow Answer

The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the

Correct AnswerverifiedShow Answer

Reports produced using the data dictionary could include all of the following except a list of

Correct AnswerverifiedShow Answer

The ________ contains information about the structure of the database.

Correct AnswerverifiedShow Answer

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Correct AnswerverifiedShow Answer

In a relational database,requiring that every record in a table have a unique identifier is called the

Correct AnswerverifiedShow Answer

Which statement below is false regarding the basic requirements of the relational data model?

Correct AnswerverifiedShow Answer

Which would not generally be considered a data dictionary output report?

Correct AnswerverifiedShow Answer

A relational database in which customer data is not maintained independently of sales invoice data will most likely result in

Correct AnswerverifiedShow Answer

What are the basic requirements when logically designing a relational database model?

Correct AnswerverifiedEvery row in every table must have a uni...View AnswerShow Answer

The delete anomaly

Correct AnswerverifiedShow Answer

The person responsible for the database is the

Correct AnswerverifiedShow Answer

Describe what you think will be the main impact of database technology in your career.

Correct AnswerverifiedAnswers to this question could cover a w...View AnswerShow Answer

The update anomaly in file-based systems or unnormalized database tables

Correct AnswerverifiedShow Answer

Which one of the following results corresponds to the query below?

Correct AnswerverifiedShow Answer

The data dictionary usually is maintained

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Every row in every table must have a uni...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Answers to this question could cover a w...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified