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.

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

  procedure

  function

  query

  transaction

  Half-n-half Clue
 

2.

Which of the following languages is used to define the schema of the database?

  DCL

  DDL

  DML

  None of these

  Half-n-half Clue
 

3.

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
 

4.

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

  reduces

  increases

 

5.

The relationship between data is defined in the _______.

  physical level

  view level

  logical level

  Half-n-half Clue
 

6.

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
 

7.

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

  instance

  scheme

  layout

  schema

  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
-