Access Control Models and Mechanisms Quiz
30 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

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?

  • Dense index
  • Clustered index (correct)
  • Sparse index
  • Unclustered index

    • A file can be clustered on how many search keys?

  • One (correct)
  • None
  • Two
  • Multiple

    • Which type of index is smaller in size?

  • Dense index
  • Sparse index (correct)
  • Clustered index
  • Unclustered index

    • Which type of index is always dense?

    <p>Dense index</p> 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?

    <p>Equality query</p> Signup and view all the answers

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

    <p>Discretionary Access Control (DAC)</p> Signup and view all the answers

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

    <p>Organization-Based Access control (OrBAC)</p> Signup and view all the answers

    Which access control model is largely context-based?

    <p>Rule-Based Access Control (RAC)</p> 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?

    <p>Encryption</p> Signup and view all the answers

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

    <p>Symmetric key encryption</p> Signup and view all the answers

    What is the purpose of database auditing?

    <p>To prevent unauthorized access</p> Signup and view all the answers

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

    <p>Aries</p> Signup and view all the answers

    What is the first phase of the crash recovery process?

    <p>Analysis</p> Signup and view all the answers

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

    <p>To recover from system crashes</p> Signup and view all the answers

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

    <p>Update</p> Signup and view all the answers

    What is the purpose of a commit type log record?

    <p>To force-write a transaction's changes</p> Signup and view all the answers

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

    <p>Abort</p> Signup and view all the answers

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

    <p>A compensation log record is written</p> Signup and view all the answers

    What does the transID field in a log record represent?

    <p>The transaction ID</p> Signup and view all the answers

    What is the purpose of checkpointing in a DBMS?

    <p>All of the above</p> Signup and view all the answers

    What are the three steps involved in checkpointing?

    <p>Begin_checkpoint, End_checkpoint, Afterend_checkpoint</p> Signup and view all the answers

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

    <p>The pageLSN and pageID of each data page</p> Signup and view all the answers

    Which of the following is an example of a DBMS?

    <p>MySQL</p> Signup and view all the answers

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

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

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

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

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

    <p>Alternative 2 is the most compact and efficient for small data records.</p> 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?

    <p>At most one index can use Alternative 1.</p> Signup and view all the answers

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

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

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

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

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

    <p>Primary index is based on the primary key.</p> Signup and view all the answers

    More Like This

    Database Performance Optimization Techniques
    12 questions

    Database Performance Optimization Techniques

    OverjoyedEuphonium avatar
    OverjoyedEuphonium
    Database Management: Indexing
    29 questions

    Database Management: Indexing

    EntrancingBrown avatar
    EntrancingBrown
    Database Indexing and B+ Trees
    10 questions

    Database Indexing and B+ Trees

    ConsummateMandolin avatar
    ConsummateMandolin
    Indexing in Database Management
    24 questions

    Indexing in Database Management

    CoherentChupacabra avatar
    CoherentChupacabra
    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser