Home › Quizzes › Database Management System

Database Management System

Tests knowledge of advanced DBMS concepts including data preprocessing, distributed systems, transactions, and recovery

10 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is a data cleansing stage where certain information is removed which is deemed unnecessary and may slow down queries?

  1. Data mining
  2. Transformation
  3. Preprocessing
  4. Either transformation or data mining
  5. None of these
Question 2 Multiple Choice (Single Answer)

Which of the following categories of rules permits no exception, so that each object of Left Hand Side (LHS) must be an element of Right Hand Side (RHS)?

  1. Exact rule
  2. Strong rule
  3. Probabilistic rule
  4. Either strong rule or probabilistic rule
  5. None of these
Question 3 Multiple Choice (Single Answer)

Which of the following is the aggregation of data such as simple roll-ups or complex expressions involving interrelated data?

  1. Slicing and dicing
  2. Drill-Down
  3. Consolidation
  4. Either slicing and dicing or drill-down
  5. None of these
Question 4 Multiple Choice (Single Answer)

Which of the following is the exact copy of a single datafile, archived redo log file or control file?

  1. Image copy
  2. Mirroring
  3. Registration
  4. Either mirroring or registration
  5. None of these
Question 5 Multiple Choice (Single Answer)

The completion of a transaction is called ______________.

  1. commit
  2. log
  3. abort
  4. either log or abort
  5. none of these
Question 6 Multiple Choice (Single Answer)

Which feature of the following heterogeneous services reduces the number of required processes by taking advantage of multi-threaded server capabilities?

  1. Agent self-registration
  2. Procedural access
  3. Distributed transaction
  4. Multi-threaded agents
  5. Either procedural access or distributed transaction
Question 7 Multiple Choice (Single Answer)

________________ reduces the amount of required data transfer, when compared to transferring all the table data to the local site for processing.

  1. Remote transaction
  2. Distributed query optimization
  3. Distributed database
  4. Either remote transaction or distributed database
  5. None of these
Question 8 Multiple Choice (Single Answer)

_____________ provides a graphic representation of active heterogeneous services agents and the user sessions are accessing those agents.

  1. Multi-threaded agents
  2. Management interface
  3. Agent self-registration
  4. Either Multi-threaded agents or Agent self-registration
  5. None of these
Question 9 Multiple Choice (Single Answer)

In which of the following phases, the system does not actually commit or roll back the transaction, instead all nodes referenced in a distributed transaction is told to prepare to commit?

  1. Forget phase
  2. Prepare phase
  3. Commit phase
  4. Either Forget phase or Commit phase
  5. None of these
Question 10 Multiple Choice (Single Answer)

The activity of ensuring atomicity in the presence of system crashes is called __________________.

  1. concurrency control
  2. transaction recovery
  3. crash recovery
  4. database recovery
  5. either concurrency control or transaction recovery
← Back to Quizzes