Question 1

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.

Accepted Answer

A) first" 
B) second" 
C) third" 
D) fourth" 
A) first" 
B) second" 
C) third" 
D) fourth" A

Question 2

A(n)____ describes the structure,content,and access controls of a physical data store or database.

Accepted Answer

A) relation" 
B) DBMS" 
C) schema" 
D) attribute" 
A) relation" 
B) DBMS" 
C) schema" 
D) attribute" C

Question 3

An integrity control that verifies the data in one field against the data in other fields is called a ____ control.

Accepted Answer

A) completeness" 
B) field combination" 
C) value" 
D) data validation" 
A) completeness" 
B) field combination" 
C) value" 
D) data validation" B

Question 4

In a relational database,a row can be referred to as a(n)____.

Accepted Answer

A) field" 
B) tuple" 
C) attribute" 
D) relation" 
A) field" 
B) tuple" 
C) attribute" 
D) relation"

Question 5

Referential integrity is normally enforced by the ____.

Accepted Answer

A) application programmer" 
B) database management system" 
C) operating system" 
D) user" 
A) application programmer" 
B) database management system" 
C) operating system" 
D) user"

Question 6

Problem domain modeling and database normalization are incompatible techniques for relational database design.

Accepted Answer

A) True 
 B)False

Question 7

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.

Accepted Answer

A) True 
 B)False

Question 8

____ are a critical element of relational database design because they are the bases for representing relationships among tables.

Accepted Answer

A) Keys" 
B) Attributes" 
C) Fields" 
D) Tables" 
A) Keys" 
B) Attributes" 
C) Fields" 
D) Tables"

Question 9

A control that protects the assets of an organization against all threats,primarily external threats is called ______ control.

Accepted Answer

The answer of A control that protects the assets of...

Question 10

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.)
CourseSectionID,StudentID,Grade,StudentName

Accepted Answer

A) Not in any valid normal form" 
B) In First Normal Form" 
C) In First and Second Normal Form" 
D) In First, Second, and Third Normal Form" 
A) Not in any valid normal form" 
B) In First Normal Form" 
C) In First and Second Normal Form" 
D) In First, Second, and Third Normal Form"

Question 11

A(n)____________________ is the list of users who have rights to access the system and data.

Accepted Answer

The answer of A(n)____________________ is the list of users who...

Question 12

A relation describes the structure,content,and access controls of a physical data store or database.

Accepted Answer

A) True 
 B)False

Question 13

A significant disadvantage of a single server database architecture is that it ____.

Accepted Answer

A) must be located on the same local area network (LAN) as all database users" 
B) requires partitioning the schema among user groups" 
C) can result in an overloaded network" 
D) is relatively expensive" 
A) must be located on the same local area network (LAN) as all database users" 
B) requires partitioning the schema among user groups" 
C) can result in an overloaded network" 
D) is relatively expensive"

Question 14

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

Accepted Answer

A) first" 
B) second" 
C) third" 
D) fourth" 
A) first" 
B) second" 
C) third" 
D) fourth"

Question 15

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.

Accepted Answer

A) True 
 B)False

Question 16

A data type that is defined by extending or combining other data types is called a(n)______ data type.

Accepted Answer

The answer of A data type that is defined by...

Question 17

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.

Accepted Answer

A) True 
 B)False

Question 18

Using digital signatures is primarily a technique to ____.

Accepted Answer

A) verifying who sent a document" 
B) allow for remote signatures on official documents" 
C) electronically send a signature" 
D) digitize (scan) a signed document" 
A) verifying who sent a document" 
B) allow for remote signatures on official documents" 
C) electronically send a signature" 
D) digitize (scan) a signed document"

Question 19

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.

Accepted Answer

A) True 
 B)False

Question 20

List and briefly describe the four types of database server architecture described in the textbook.

Accepted Answer

1.Single database server architecture -O

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.

A(n)____ describes the structure,content,and access controls of a physical data store or database.

An integrity control that verifies the data in one field against the data in other fields is called a ____ control.

In a relational database,a row can be referred to as a(n)____.

Referential integrity is normally enforced by the ____.

Problem domain modeling and database normalization are incompatible techniques for relational database design.

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.

____ are a critical element of relational database design because they are the bases for representing relationships among tables.

A control that protects the assets of an organization against all threats,primarily external threats is called ______ control.

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.) CourseSectionID,StudentID,Grade,StudentName

A(n)____________________ is the list of users who have rights to access the system and data.

A relation describes the structure,content,and access controls of a physical data store or database.

A significant disadvantage of a single server database architecture is that it ____.

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.

A data type that is defined by extending or combining other data types is called a(n)______ data type.

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.

Using digital signatures is primarily a technique to ____.

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.

List and briefly describe the four types of database server architecture described in the textbook.

From Beginning to End: An Overview of Systems Analysis and Design

Investigating System Requirements

Use Cases

Domain Modeling

Extending the Requirements Models

Essentials of Design and the Design Activities

Designing the User and System Interfaces

Approaches to System Development

Project Planning and Project Management

Object-Oriented Design Principles

Use Case Realizations

Making the System Operational

Current Trends in System Development

Filters

Exam 12: Databases, Controls, and Security

A relational database table is in ____ normal form if it has no repeating fields or groups of fields,and hence all rows have the same columns.

A(n)____ describes the structure,content,and access controls of a physical data store or database.

An integrity control that verifies the data in one field against the data in other fields is called a ____ control.

In a relational database,a row can be referred to as a(n)____.

Referential integrity is normally enforced by the ____.

Problem domain modeling and database normalization are incompatible techniques for relational database design.

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.

____ are a critical element of relational database design because they are the bases for representing relationships among tables.

A control that protects the assets of an organization against all threats,primarily external threats is called ______ control.

What can be said about the following relational database table (key is underlined): (Choose the most correct answer.) CourseSectionID,StudentID,Grade,StudentName

A(n)____________________ is the list of users who have rights to access the system and data.

A relation describes the structure,content,and access controls of a physical data store or database.

A significant disadvantage of a single server database architecture is that it ____.

A relational database table is in ____ normal form if every non-key field is functionally dependent on the primary key.

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.

A data type that is defined by extending or combining other data types is called a(n)______ data type.

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.

Using digital signatures is primarily a technique to ____.

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.

List and briefly describe the four types of database server architecture described in the textbook.

From Beginning to End: An Overview of Systems Analysis and Design

Investigating System Requirements

Use Cases

Domain Modeling

Extending the Requirements Models

Essentials of Design and the Design Activities

Designing the User and System Interfaces

Approaches to System Development

Project Planning and Project Management

Object-Oriented Design Principles

Use Case Realizations

Making the System Operational

Current Trends in System Development

Filters