data base management system (DBMS) set 3 Detailed Explanation And More Example

Question : 1

Databases overall structure is maintained in a file called

a) Redo log file

b) Data file

c) Control file

d) All of the above

e) None of these

Question : 2

Which command we will give if we want to show the database objects with it's description ?

a) Details

b) Show

c) List

d) Any of the above

e) None of the above

Question : 3

The first step in the transaction processing cycle is __________.

a) database operations

b) audit

c) data entry

d) user inquiry

e) None of these

Question : 4

Where will we find the referential integrity command ?

a) Tools

b) View

c) Format

d) Table

e) None of these

Question : 5

ROLLBACK in a database is ________ statement

a) TCL

b) DCL

c) DML

d) DDL

e) SDL

Question : 6

How do businesses protect their databases?

a) Security guards are hired to watch the databases at all times.

b) Databases are protected by file swapping.

c) Databases are naturally protected.

d) Databases are kept physically and electronically secure.

e) The computer room is kept locked after office hours.