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

Question : 1

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

Question : 2

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

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

A data warehouse

a) Contains numerous naming conventions and formats

b) Is organized around important subject areas

c) Contains only current data

d) Can be updated by end users

e) Explains some observed event or condition

Question : 5

Files are organised by storing them in

a) tables

b) databases

c) folders

d) graphs

e) diagrams

Question : 6

The DBMS that is most difficult to use is ________ .

a) Microsoft’s SQL Server

b) Microsoft’s Access

c) IBM’s DB2

d) Oracle Corporation’s Oracle

e) None of these