Mcq on DBMS with Answers Key PDF Download

Learn mcq on dbms with answers key, dbms FAQs for online MCQs based test prep. These frequently asked questions has multiple choice questions (MCQ), dbms quiz questions and answers as server process implementing lock manager functionality is known to be , answer key with choices as server processes, database writer process, recovery manager processes and lock manager processes for competitive exam preparation. Free frequently asked questions are to learn mcq on dbms with answers key quiz online with MCQs to practice test questions with answers.

FAQs Mcq on DBMS with Answers Key PDF Download

MCQ. Server process implementing lock manager functionality is known to be

  1. Server processes
  2. Database writer process
  3. Recovery Manager processes
  4. Lock manager processes

D

MCQ. In a shared architecture, process receiving user queries are known as

  1. Server process
  2. Lock manager process
  3. Database writer process
  4. Log writer process

A

MCQ. In a shared architecture, process executing queries and sending back results is responsibility of

  1. Lock manager process
  2. Server process
  3. Log writer process
  4. Database writer process

B

MCQ. A server process responsible for managing lock grant, lock release and deadlock detection is

  1. Server processes
  2. Manager processes
  3. Lock manager processes
  4. Database writer process

C

MCQ. Multithreading within a process is executable in manner

  1. FIFO
  2. LIFO
  3. Concurrently
  4. Parallel

C