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

Question : 1

Where will we find the referential integrity command ?

a) Tools

b) View

c) Format

d) Table

e) None of these

Question : 2

A tuple is a

a) column of a table

b) two-dimensional table

c) row of a table

d) key of a table

e) None of these

Question : 3

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 : 4

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.

Question : 5

When data changes in multiple lists and all lists are not updated, this causes

a) data redundancy

b) information overload

c) duplicate data

d) data inconsistency

e) data repetition

Question : 6

The DBMS acts as an interface between what two components of an enterprise-class database system?

a) Database application and the database

b) Data and the database

c) The user and the database application

d) Database application and SQL

e) None of these