Question 1

____ is a one-to-one correspondence between two field values.

Accepted Answer

A) First normal form" 
B) Second normal form" 
C) Referential integrity" 
D) Functional dependency" 
A) First normal form" 
B) Second normal form" 
C) Referential integrity" 
D) Functional dependency"

Question 2

A foreign key is a field or set of fields stored in one table that also exists as a primary key in another table.

Accepted Answer

A) True 
 B)False

Question 3

What is the name of a general control technique used to ensure that entered data is correct?

Accepted Answer

A) Data validation control" 
B) Data access control" 
C) Data acceptance control" 
D) Data completeness control" 
A) Data validation control" 
B) Data access control" 
C) Data acceptance control" 
D) Data completeness control"

Question 4

List and briefly describe the four components of a database management system.

Accepted Answer

1.Application Program Interface -- allow

Question 5

_______ is the process of allowing or restricting a specific user's access to specific resources.

Accepted Answer

The answer of _______ is the process of allowing or...

Question 6

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

Accepted Answer

A) columns" 
B) foreign keys" 
C) rows" 
D) values" 
A) columns" 
B) foreign keys" 
C) rows" 
D) values"

Question 7

What is a control that checks the value of a field to ensure that it is within the correct range?

Accepted Answer

A) Answer control" 
B) Completeness control" 
C) Value limit control" 
D) High-low control" 
A) Answer control" 
B) Completeness control" 
C) Value limit control" 
D) High-low control"

Question 8

One column of a table in a relational database is called a(n)____.

Accepted Answer

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

Question 9

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

Accepted Answer

The answer of A(n)____________________ describes the structure,content,and access controls of...

Question 10

A user who has special security and access to a system,such as the right to assign passwords,is called a ____.

Accepted Answer

A) supervisor user" 
B) database administrator" 
C) privileged user" 
D) technical user" 
A) supervisor user" 
B) database administrator" 
C) privileged user" 
D) technical user"

Question 11

A security measure that automatically deletes sensitive data from a portable device when an unauthorized access is attempted is a called a(n)_______.

Accepted Answer

The answer of A security measure that automatically deletes sensitive...

Question 12

A(n)____ is a field or set of fields used to uniquely identify each row.

Accepted Answer

A) primary key" 
B) foreign key" 
C) object identifier" 
D) attribute" 
A) primary key" 
B) foreign key" 
C) object identifier" 
D) attribute"

Question 13

Which of the following can be classified as privileged users?

Accepted Answer

A) System programmers, application programmers, and system administrators" 
B) Technical users and security personnel" 
C) System operators and clerks" 
D) Administrators and accountants" 
A) System programmers, application programmers, and system administrators" 
B) Technical users and security personnel" 
C) System operators and clerks" 
D) Administrators and accountants"

Question 14

_______ database server architecture is poorly suited to applications that must be available on a seven-day,24-hour basis.

Accepted Answer

The answer of _______ database server architecture is poorly suited...

Question 15

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

Accepted Answer

A) First normal form (1NF)" 
B) Database synchronization" 
C) Function dependency" 
D) Referential integrity" 
A) First normal form (1NF)" 
B) Database synchronization" 
C) Function dependency" 
D) Referential integrity"

Question 16

Completeness control is an integrity control that identifies when a value in a field is too large or too small.

Accepted Answer

A) True 
 B)False

Question 17

What is the name of the control mechanism that is used to ensure that all necessary information for a transaction has been entered?

Accepted Answer

A) Secure control" 
B) Total control" 
C) Comprehensive control" 
D) Completeness control" 
A) Secure control" 
B) Total control" 
C) Comprehensive control" 
D) Completeness control"

Question 18

A data type that is supported directly by computer hardware or a programming language is called a(n)_______ data type.

Accepted Answer

The answer of A data type that is supported directly...

Question 19

Each class on an class diagram is represented by a(n)____ in a relational database.

Accepted Answer

A) attribute" 
B) row" 
C) table" 
D) column" 
A) attribute" 
B) row" 
C) table" 
D) column"

Question 20

What danger(s)is/are inherent in using keys invented by external agents as primary keys in a relational database?

Accepted Answer

Referential integrity depends on primary

____ is a one-to-one correspondence between two field values.

A foreign key is a field or set of fields stored in one table that also exists as a primary key in another table.

What is the name of a general control technique used to ensure that entered data is correct?

List and briefly describe the four components of a database management system.

_______ is the process of allowing or restricting a specific user's access to specific resources.

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

What is a control that checks the value of a field to ensure that it is within the correct range?

One column of a table in a relational database is called a(n)____.

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

A user who has special security and access to a system,such as the right to assign passwords,is called a ____.

A security measure that automatically deletes sensitive data from a portable device when an unauthorized access is attempted is a called a(n)_______.

A(n)____ is a field or set of fields used to uniquely identify each row.

Which of the following can be classified as privileged users?

_______ database server architecture is poorly suited to applications that must be available on a seven-day,24-hour basis.

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

Completeness control is an integrity control that identifies when a value in a field is too large or too small.

What is the name of the control mechanism that is used to ensure that all necessary information for a transaction has been entered?

A data type that is supported directly by computer hardware or a programming language is called a(n)_______ data type.

Each class on an class diagram is represented by a(n)____ in a relational database.

What danger(s)is/are inherent in using keys invented by external agents as primary keys in a relational database?

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

____ is a one-to-one correspondence between two field values.

A foreign key is a field or set of fields stored in one table that also exists as a primary key in another table.

What is the name of a general control technique used to ensure that entered data is correct?

List and briefly describe the four components of a database management system.

_______ is the process of allowing or restricting a specific user's access to specific resources.

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

What is a control that checks the value of a field to ensure that it is within the correct range?

One column of a table in a relational database is called a(n)____.

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

A user who has special security and access to a system,such as the right to assign passwords,is called a ____.

A security measure that automatically deletes sensitive data from a portable device when an unauthorized access is attempted is a called a(n)_______.

A(n)____ is a field or set of fields used to uniquely identify each row.

Which of the following can be classified as privileged users?

_______ database server architecture is poorly suited to applications that must be available on a seven-day,24-hour basis.

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

Completeness control is an integrity control that identifies when a value in a field is too large or too small.

What is the name of the control mechanism that is used to ensure that all necessary information for a transaction has been entered?

A data type that is supported directly by computer hardware or a programming language is called a(n)_______ data type.

Each class on an class diagram is represented by a(n)____ in a relational database.

What danger(s)is/are inherent in using keys invented by external agents as primary keys in a relational database?

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