Database Systems Frequently Asked Questions with Answers PDF Download

Learn database systems frequently asked questions with answers, dbms FAQs for online MCQs based test prep. These frequently asked questions has multiple choice questions (MCQ), dbms quiz questions and answers as log records can be added to log records buffer through process named as , answer key with choices as manager processes , database writer process, server processes and log record buffer for competitive exam preparation. Free frequently asked questions are to learn database systems frequently asked questions with answers quiz online with MCQs to practice test questions with answers.

FAQs Database Systems Frequently Asked Questions with Answers PDF Download

MCQ. Log records can be added to log records buffer through process named as

  1. Manager processes
  2. Database writer process
  3. Server processes
  4. Log record buffer

C

MCQ. Buffer blocks are modified back to disk on a continuous basis by process known to be

  1. Database writer process
  2. Manager processes
  3. Log writer process
  4. Server processes

A

MCQ. In concurrent transactions, occurrence of deadlock can be thought as of

  1. System crash
  2. System error
  3. Application error
  4. Application crash

B

MCQ. Process of Log writer outputs log records from

  1. Log buffer
  2. Log records
  3. Log queue
  4. Log record buffer

D

MCQ. Managing concurrency rate is a challenging task for transactions that have

  1. Application accesses
  2. I/O interactions
  3. User interactions
  4. Application interactions

C