Access Control Models and Mechanisms Quiz

Which type of index is defined as having the order of data records the same as, or close to, the order of data entries?

Clustered index

A file can be clustered on how many search keys?

One

Which type of index is smaller in size?

Sparse index

Which type of index is always dense?

Dense index Signup and view all the answers

Which type of query involves a combination of fields and every field value being equal to a constant value?

Equality query Signup and view all the answers

Which type of access control is based on the data owner determining who can access specific resources?

Discretionary Access Control (DAC) Signup and view all the answers

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

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

Which access control model is largely context-based?

Rule-Based Access Control (RAC) Signup and view all the answers

What is the process of encoding a message or information in such a way that only authorized parties can access it?

Encryption Signup and view all the answers

Which type of encryption uses the same key for both encryption and decryption?

Symmetric key encryption Signup and view all the answers

What is the purpose of database auditing?

To prevent unauthorized access Signup and view all the answers

Which recovery algorithm is designed to work with a steal, no-force approach?

Aries Signup and view all the answers

What is the first phase of the crash recovery process?

Analysis Signup and view all the answers

What is the purpose of the log in a database management system?

To recover from system crashes Signup and view all the answers

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

Update Signup and view all the answers

What is the purpose of a commit type log record?

To force-write a transaction's changes Signup and view all the answers

What type of log record is appended to the log 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 compensation log record is written Signup and view all the answers

What does the transID field in a log record represent?

The transaction ID Signup and view all the answers

What is the purpose of checkpointing in a DBMS?

All of the above Signup and view all the answers

What are the three steps involved in checkpointing?

Begin_checkpoint, End_checkpoint, Afterend_checkpoint Signup and view all the answers

What is stored in the Dirty Page Table of a DBMS?

The pageLSN and pageID of each data page Signup and view all the answers

Which of the following is an example of a DBMS?

MySQL Signup and view all the answers

Which of the following is true about indexes on a file?

Indexes can only be created on the search key fields of a relation. Signup and view all the answers

Which of the following is true about search key and key in relation to indexes?

Search key is a minimal set of fields that uniquely identify a record in a relation. Signup and view all the answers

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

Alternative 2 is the most compact and efficient for small data records. Signup and view all the answers

Which of the following is true about the number of indexes that can use Alternative 1 for a given collection of data records?

At most one index can use Alternative 1. Signup and view all the answers

Which of the following is true about the size of auxiliary information in an index?

The size of auxiliary information in an index is typically small for large data records. Signup and view all the answers

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

Alternative 3 is the most compact and efficient for large data entries. Signup and view all the answers

Which of the following is true about the classification of indexes?

Primary index is based on the primary key. Signup and view all the answers

Access Control Models and Mechanisms Quiz

Questions and Answers

Which type of index is defined as having the order of data records the same as, or close to, the order of data entries?

A file can be clustered on how many search keys?

Which type of index is smaller in size?

Which type of index is always dense?

Which type of query involves a combination of fields and every field value being equal to a constant value?

Which type of access control is based on the data owner determining who can access specific resources?

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

Which access control model is largely context-based?

What is the process of encoding a message or information in such a way that only authorized parties can access it?

Which type of encryption uses the same key for both encryption and decryption?

What is the purpose of database auditing?

Which recovery algorithm is designed to work with a steal, no-force approach?

What is the first phase of the crash recovery process?

What is the purpose of the log in a database management system?

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

What is the purpose of a commit type log record?

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

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

What does the transID field in a log record represent?

What is the purpose of checkpointing in a DBMS?

What are the three steps involved in checkpointing?

What is stored in the Dirty Page Table of a DBMS?

Which of the following is an example of a DBMS?

Which of the following is true about indexes on a file?

Which of the following is true about search key and key in relation to indexes?

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

Which of the following is true about the number of indexes that can use Alternative 1 for a given collection of data records?

Which of the following is true about the size of auxiliary information in an index?

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

Which of the following is true about the classification of indexes?

More Quizzes Like This

Computer Science and Engineering Knowledge Quiz

Database Performance Optimization Techniques

Database Operations and Optimization Quiz

Database Indexing and Tables

Upgrade to continue