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.

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

  instance

  layout

  schema

  scheme

  Half-n-half Clue
 

2.

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
 

3.

The amount of data that is shown to a user is defined in the _______.

  view level

  physical level

  logical level

  Half-n-half Clue
 

4.

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
 

5.

The database oriented approach _______ the redundancy of data compared to the file oriented approach.

  reduces

  increases

 

6.

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

  durability

  consistency

  atomicity

  isolation

  Half-n-half Clue
 

7.

One of the requirements of transaction management is that after the successful execution of the transaction, the new values in the database must persist even if there is a system failure. This requirement is termed as _______.

  durability

  atomicity

  isolation

  consistency

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


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