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 database oriented approach does not support multiple views of the same data.

  True

  False

 

2.

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

  reduces

  increases

 

3.

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

  consistency

  isolation

  durability

  atomicity

  Half-n-half Clue
 

4.

The DML is used for:
a) Creating tables
b) Retrieving data
c) Deleting users
d) Inserting data
e) Deleting data

  b,d,e

  b,c,d

  None of these

  All of these

  Half-n-half Clue
 

5.

The security features of the database are set up by the _______.

  Naive Users

  Online Users

  Database Administrator

  Application Programmer

  Half-n-half Clue
 

6.

Which language is used to define the integrity constraints?

  DDL

  DCL

  DML

  None of these

  Half-n-half Clue
 

7.

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

  schema

  instance

  records

  view

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


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