Podcast
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?
Which type of index is defined as having the order of data records the same as, or close to, the order of data entries?
- Dense index
- Clustered index (correct)
- Sparse index
- Unclustered index
A file can be clustered on how many search keys?
A file can be clustered on how many search keys?
- One (correct)
- None
- Two
- Multiple
Which type of index is smaller in size?
Which type of index is smaller in size?
- Dense index
- Sparse index (correct)
- Clustered index
- Unclustered index
Which type of index is always dense?
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 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 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 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?
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?
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?
Which type of encryption uses the same key for both encryption and decryption?
What is the purpose of database auditing?
What is the purpose of database auditing?
Which recovery algorithm is designed to work with a steal, no-force approach?
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 first phase of the crash recovery process?
What is the purpose of the log in a database management system?
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?
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 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 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 additional action is taken when a transaction is aborted or committed?
What does the transID field in a log record represent?
What does the transID field in a log record represent?
What is the purpose of checkpointing in a DBMS?
What is the purpose of checkpointing in a DBMS?
What are the three steps involved in checkpointing?
What are the three steps involved in checkpointing?
What is stored in the Dirty Page Table of a DBMS?
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 an example of a DBMS?
Which of the following is true about indexes on a file?
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 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 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 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 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 alternatives for data entries in an index?
Which of the following is true about the classification of indexes?
Which of the following is true about the classification of indexes?
