FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Databases, Controls, and Security

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

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

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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 ________.

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

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

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

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.

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

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

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

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

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.

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

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

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

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.

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