Question 1

A ____ database server architecture runs the greatest risk of service disruption in the event of a server failure.

Accepted Answer

A) single" 
B) replicated" 
C) partitioned" 
D) cloud-based" 
A) single" 
B) replicated" 
C) partitioned" 
D) cloud-based"

Question 2

When the data is encrypted with the public key in asymmetric encryption ,it is decrypted with a(n)____ key.

Accepted Answer

A) asymmetric" 
B) private" 
C) public" 
D) symmetric" 
A) asymmetric" 
B) private" 
C) public" 
D) symmetric"

Question 3

What can be said about the following relational database table (key is underlined): (Choose the most correct answer)
StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

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 4

Database synchronization should be implemented when using a(n)____ database server architecture.

Accepted Answer

A) single" 
B) replicated" 
C) partitioned" 
D) cloud-based" 
A) single" 
B) replicated" 
C) partitioned" 
D) cloud-based"

Question 5

An separate relation must be created to store the attributes of a ____ relationship among two other classes.

Accepted Answer

A) one-to-one" 
B) one-to-many" 
C) many-to-many" 
D) not any (not necessary)" 
A) one-to-one" 
B) one-to-many" 
C) many-to-many" 
D) not any (not necessary)"

Question 6

Which of the following is NOT a component or function of a typical database management system (DBMS)?

Accepted Answer

A) Low-level process management" 
B) End-user query processor" 
C) Application program interface" 
D) Administrative interface" 
A) Low-level process management" 
B) End-user query processor" 
C) Application program interface" 
D) Administrative interface"

Question 7

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.

Accepted Answer

A) True 
 B)False

Question 8

____________________ is the process of identifying a user to verify that he or she can have access to the system.

Accepted Answer

The answer of ____________________ is the process of identifying a...

Question 9

A ____ database server architecture is the simplest to build and operate if sufficient network capacity is already available for database access.

Accepted Answer

A) single" 
B) replicated" 
C) partitioned" 
D) cloud-based" 
A) single" 
B) replicated" 
C) partitioned" 
D) cloud-based"

Question 10

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

Accepted Answer

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

Question 11

Which user is known to the system and is authorized to access all or certain parts of it?

Accepted Answer

A) Authorized user" 
B) Registered user" 
C) Valid user" 
D) Authenticated user" 
A) Authorized user" 
B) Registered user" 
C) Valid user" 
D) Authenticated user"

Question 12

A(n)_______ is the database component that actually stores the raw bytes of data.

Accepted Answer

The answer of A(n)_______ is the database component that actually...

Question 13

A ____ database server architecture is only feasible when a database schema can be cleanly divided among client access user groups.

Accepted Answer

A) single" 
B) partitioned" 
C) replicated" 
D) cloud-based" 
A) single" 
B) partitioned" 
C) replicated" 
D) cloud-based"

Question 14

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.

Accepted Answer

A) True 
 B)False

Question 15

Every table in a relational database must have a foreign key.

Accepted Answer

A) True 
 B)False

Question 16

The primary purpose of integrity controls is to track external activity.

Accepted Answer

A) True 
 B)False

Question 17

Three types of users that are considered in the design of a security system are ____.

Accepted Answer

A) manager user, technical user, and clerical user" 
B) technical user, authorized user, and privileged user" 
C) unauthorized user, registered user, and privileged user" 
D) supervisor user, administration user, and operational user" 
A) manager user, technical user, and clerical user" 
B) technical user, authorized user, and privileged user" 
C) unauthorized user, registered user, and privileged user" 
D) supervisor user, administration user, and operational user"

Question 18

A technique where all updates to a database are recorded with who,when,and how information is called ________.

Accepted Answer

transactio

Question 19

A relational database management system stores data in tables.

Accepted Answer

A) True 
 B)False

Question 20

A ____ is an institution's name and public key,which is encrypted and certified by a third party.

Accepted Answer

A) private key" 
B) digital certificate" 
C) certifying authority" 
D) digital key" 
A) private key" 
B) digital certificate" 
C) certifying authority" 
D) digital key"

A ____ database server architecture runs the greatest risk of service disruption in the event of a server failure.

When the data is encrypted with the public key in asymmetric encryption ,it is decrypted with a(n)____ key.

What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

Database synchronization should be implemented when using a(n)____ database server architecture.

An separate relation must be created to store the attributes of a ____ relationship among two other classes.

Which of the following is NOT a component or function of a typical database management system (DBMS)?

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.

____________________ is the process of identifying a user to verify that he or she can have access to the system.

A ____ database server architecture is the simplest to build and operate if sufficient network capacity is already available for database access.

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

Which user is known to the system and is authorized to access all or certain parts of it?

A(n)_______ is the database component that actually stores the raw bytes of data.

A ____ database server architecture is only feasible when a database schema can be cleanly divided among client access user groups.

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.

Every table in a relational database must have a foreign key.

The primary purpose of integrity controls is to track external activity.

Three types of users that are considered in the design of a security system are ____.

A technique where all updates to a database are recorded with who,when,and how information is called ________.

A relational database management system stores data in tables.

A ____ is an institution's name and public key,which is encrypted and certified by a third party.

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 ____ database server architecture runs the greatest risk of service disruption in the event of a server failure.

When the data is encrypted with the public key in asymmetric encryption ,it is decrypted with a(n)____ key.

What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

Database synchronization should be implemented when using a(n)____ database server architecture.

An separate relation must be created to store the attributes of a ____ relationship among two other classes.

Which of the following is NOT a component or function of a typical database management system (DBMS)?

Classes that participate in a classification hierarchy can be represented within a relational database as a set of tables with the primary key of the general class table replicated in the other tables.

____________________ is the process of identifying a user to verify that he or she can have access to the system.

A ____ database server architecture is the simplest to build and operate if sufficient network capacity is already available for database access.

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

Which user is known to the system and is authorized to access all or certain parts of it?

A(n)_______ is the database component that actually stores the raw bytes of data.

A ____ database server architecture is only feasible when a database schema can be cleanly divided among client access user groups.

Relationships in a relational database are usually represented by embedding a foreign key in each participating table.

Every table in a relational database must have a foreign key.

The primary purpose of integrity controls is to track external activity.

Three types of users that are considered in the design of a security system are ____.

A technique where all updates to a database are recorded with who,when,and how information is called ________.

A relational database management system stores data in tables.

A ____ is an institution's name and public key,which is encrypted and certified by a third party.

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