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 security features of the database are set up by the _______.

  Online Users

  Naive Users

  Database Administrator

  Application Programmer

  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.

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
 

4.

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 _______.

  isolation

  atomicity

  consistency

  durability

  Half-n-half Clue
 

5.

The database oriented approach does not support multiple views of the same data.

  True

  False

 

6.

Which of the following are the roles of the Database Administrator:
a) Managing security issues
b) Storage structure definition
c) Develop application programs
d) Take backups of the database

  a

  a,b,c

  a,b,d

  All of these

  Half-n-half Clue
 

7.

In a database, a group of commands that collectively performs a logical function is known as a _______.

  procedure

  query

  function

  transaction

  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
-