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 _______ DML requires the user to state the information required and how to retrieve it.

  non-procedural

  procedural

  declarative

  information

  Half-n-half Clue
 

3.

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

  layout

  schema

  scheme

  instance

  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.

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

  atomicity

  isolation

  consistency

  durability

  Half-n-half Clue
 

6.

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

  procedure

  function

  transaction

  query

  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-2018 Syvum Technologies Inc. Privacy Policy Disclaimer and Copyright
Previous
-
Next
-