database mcq4

Question: 1

The issues that deals with the collection and use of data about individuals is

(A) Accuracy

(B) Access

(C) Privacy

(D) Publicity

Ans: C

Privacy

Question: 2

The database administrator is, in effect, the coordinator between them ____ and the ____

(A) Database, users

(B) Application program; database

(C) DBMS; database

(D) Application programs; users

Ans: A

Database, users

Question: 3

In order to understand DBMS, it is important to understand?

(A) The physical schema

(B) One sub schema

(C) All sub schema that are system support

(D) Both (a) and (b)

Ans: B

One sub schema

Question: 4

Where will we find the referential integrity command?

(A) Table

(B) Tools

(C) Format

(D) None of these

Ans: D

None of these

Question: 5

The DBMS that is most difficult to use is ____

(A) Oracle Corporation’s Oracle

(B) Microsoft’s Access

(C) Microsoft’s SQL Server

(D) None of these

Ans: A

Oracle Corporation’s Oracle

 

Question: 6

Which of the following component of a computer system is the most important to a database management system?

(A) High speed, large capacity disk

(B) High resolution video display

(C) Mouse

(D) Printer

Ans: A

High speed, large capacity disk

Question: 7

In a relational schema, each tuple is divided into fields called

(A) Domains

(B) Queries

(C) Relations

(D) None of these

Ans: A

Domains

Question: 8

An indexing operation

(A) Establishes an index for a file

(B) Sorts a file using two keys

(C) Sorts a file using a single key

(D) Both (b) and (c)

Ans: A

Establishes an index for a file

Question: 9

The modify operation is likely to be done after

(A) Insert

(B) Delete

(C) Look-up

(D) None of these

Ans: C

Look-up

Question: 10

Which command creates and initializes one or more memory variables?

(A) RELEASE

(B) KEEP

(C) STORE

(D) UPDATE

Ans: C

STORE