Database Systems Questions

MCQ bookmark_border

131.

A form can be used to

A

modify records

B

delete records

C

format printed output

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

132.

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

A

Oracle

B

SQL

C

dBASE

D

4GL

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

133.

In SQL, the CREATE TABLE is used

A

to create a table, defining its columns, integrity constrains, and storage allocation

B

to add a column/integrity constraint to a table

C

to redefine a column

D

to change a table's storage characteristics

E

All of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

134.

Which of the following is not true of the traditional approach to information processing?

A

There is common sharing of data among the various applications

B

It is file-oriented

C

Programs are dependent on the files

D

It is inflexible

E

All of the above are true

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

135.

Batch processing is appropriate if

A

a large computer system is available

B

only a small computer system is available

C

only a few transactions are involved

D

All of the above

E

None of the above

Correct Answer: E

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

136.

What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

A

DASD

B

FMS

C

EMMS

D

DBMS

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

137.

Which of the following is not an advantage of the data-base approach?

A

elimination of the data redundancy

B

ability to associate related data

C

increased security

D

program/data independence

E

All of the above are advantages

Correct Answer: E

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

138.

A data dictionary doesn't provide information about:

A

where data is located

B

the size of the disk storage device

C

It allows a many-to-many relationship

D

It is conceptually simple

E

It will be the dominant data base of the future

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

139.

Data encryption techniques are particularly useful for

A

reducing storage space requirements

B

improving data integrity

C

protecting data in data communication systems

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

140.

It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

A

Database

B

Table

C

Record

D

Flat File

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion