Syvum Home Page

Home > Quiz Games > Information Technology & Computer Programming > DBMS Training & SQL Tutorial >

DBMS Training & SQL Tutorial :
Introduction to Database Management


Answer the following multiple-choice questions about introductory concepts of Database Management.

Formats Info Page/Theory Quiz Review
Multiple choice

Your Performance  

1.

Which of the following are components of the Storage Manager:
a) Authorization and integrity manager
b) Transaction Manager
c) File Manager
d) Buffer Manager

  All of these

  c

  c,d

  None of these

  Half-n-half Clue
 

2.

The collection of data stored in a database at a particular moment is called the _______ of the database.

  schema

  view

  records

  instance

  Half-n-half Clue
 

3.

The _______ DML requires the user to state the information required and how to retrieve it.

  declarative

  non-procedural

  information

  procedural

  Half-n-half Clue
 

4.

The organization of the database is called the _______ of the database.

  schema

  scheme

  instance

  layout

  Half-n-half Clue
 

5.

Which of the following properties should be satisfied by transaction management:
a) Atomicity
b) Consistency
c) Isolation
d) Durability

  a,b

  b,c,d

  None of these

  All of these

  Half-n-half Clue
 

6.

Which component of the DBMS translates DML instructions into DBMS understandable statements?

  Transaction Processor

  Query Processor

  Storage Manager

  Data Manager

  Half-n-half Clue
 

7.

One of the requirements of transaction management is that the transaction should occur completely or not occur at all. This requirement is termed as _______.

  isolation

  atomicity

  consistency

  durability

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


Contact Info © 1999-2025 Syvum Technologies Inc. Privacy Policy Disclaimer and Copyright
Previous
-
Next
-