Access Control Models and Mechanisms Quiz

Play an AI-generated podcast conversation about this lesson

RBAC stands for

Role-Based Access Control (correct)

Responsibility-Based Access Control

Rule-Based Access Control

Random-Based Access Control

Encryption is often described as

The only line of defense

The last line of defense (correct)

The first line of defense

The weakest line of defense

Symmetric key encryption requires

A key generated for each message

The same encryption and decryption keys (correct)

A public and private key

Different encryption and decryption keys

Public key encryption involves

Publishing the encryption key for anyone to use Signup and view all the answers

The ARIES recovery algorithm is designed to work with

A steal and no-force approach Signup and view all the answers

Database auditing is used to

Prevent unauthorized access Signup and view all the answers

The three main principles of the ARIES recovery algorithm include all of the following except

Crash recovery after a crash Signup and view all the answers

Which type of log record is appended after modifying a page?

Update Signup and view all the answers

What is the purpose of a commit type log record?

To force-write the log tail to stable storage Signup and view all the answers

What type of log record is appended when a transaction is aborted?

Abort Signup and view all the answers

What additional action is taken when a transaction is aborted or committed?

A master record is written Signup and view all the answers

What is the purpose of a compensation log record (CLR)?

To undo the action described by an update log record Signup and view all the answers

What is the purpose of a checkpoint in a DBMS?

All of the above Signup and view all the answers

Which step marks the beginning of a checkpoint?

Begin_checkpoint Signup and view all the answers

Which table in a DBMS stores the lastLSN and status of transactions?

Xact Table Signup and view all the answers

Where is the master record written in a DBMS?

RAM Signup and view all the answers

Which of the following best describes a clustered index?

A clustered index is an index where the order of data records is the same as the order of data entries. Signup and view all the answers

What is the purpose of database security?

To ensure that data is kept safe from corruption and access to it is suitably controlled. Signup and view all the answers

Which of the following statements is true about dense indexes?

A dense index has at least one data entry per search key value. Signup and view all the answers

Which of the following is a risk associated with database security?

Unintended activity or misuse by authorized database users. Signup and view all the answers

What is the purpose of access control in database security?

To selectively restrict access to a place or resource. Signup and view all the answers

Which of the following factors can be used for authenticating information?

Something the user knows, something the user has, something the user is. Signup and view all the answers

Which access control model allows the policy designer to define a security policy independently of the implementation?

Organization-Based Access Control (OrBAC) Signup and view all the answers

What is the difference between a search key and a key?

A search key is any subset of the fields of a relation, while a key is a minimal set of fields that uniquely identify a record Signup and view all the answers

Which of the following is true about an index on a file?

It supports efficient retrieval of all data entries with a given key value Signup and view all the answers

Which of the following is true about the alternatives for data entries in an index?

Alternative 1 is the only choice when multiple indexes are required on a file Signup and view all the answers

Which of the following is true about the index classification?

A primary index contains the primary key of a relation Signup and view all the answers

Which of the following is true about Alternative 1 for data entries in an index?

It is the best choice when data records are very large Signup and view all the answers

Which of the following is true about Alternative 3 for data entries in an index?

It is more compact than Alternative 2 Signup and view all the answers

Which of the following is true about the indexing technique used to locate data entries with a given key value?

The choice of alternative for data entries is orthogonal to the indexing technique Signup and view all the answers