Database Systems Questions

MCQ bookmark_border

71.

A race condition occurs when

A

Two concurrent activities interact to cause a processing error

B

two users of the DBMS are interacting with different files at the same time

C

both (a) and (b)

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

72.

An indexing operation

A

sorts a file using a single key

B

sorts file using two keys

C

establishes an index for a file

D

both (b) and (c)

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

73.

The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a

A

forecasting report

B

exception report

C

regularly scheduled report

D

on demand report

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

74.

In SQL, which command(s) is(are) used to create a synonym for a schema object?

A

CREATE SCHEMA

B

CREATE SYNONYM

C

CREATE SAME

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

75.

If you want your database to include methods, you should use a _____ database.

A

Network

B

Distributed

C

Hierarchical

D

Object-Oriented

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

76.

In SQL, which of the following is not a data Manipulation Language Commands?

A

DELETE

B

SELECT

C

UPDATE

D

CREATE

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

77.

Which of the following is not characteristic of a relational database model?

A

tables

B

treelike structure

C

complex logical relationships

D

records

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

78.

A computer file contains several records. What does each record contain?

A

Bytes

B

Words

C

Fields

D

Database

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

79.

In SQL, the CREATE VIEW command is used

A

to recompile view

B

to define a view of one or more tables or views

C

to recompile a table

D

to create a trigger

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

80.

A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

A

File structure

B

Records

C

Fields

D

Database

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion