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.

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

  atomicity

  consistency

  isolation

  durability

  Half-n-half Clue
 

2.

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

  True

  False

 

3.

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
 

4.

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

  logical level

  view level

  physical level

  Half-n-half Clue
 

5.

A group of associated fields is called a _______.

  attribute

  table

  field

  record

  Half-n-half Clue
 

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.

Which language is used to permit or prohibit access to a table?

  DCL

  DDL

  DML

  All of these

  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
-