Database Systems Questions

MCQ bookmark_border

41.

In SQL, GRANT command is used to

A

allow user to access databases

B

allow user to create databases

C

grant system privileges, roles, and object privileges to uses and roles

D

choose auditing for specific SQL commands

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

42.

The highest level in the hierarchy of data organization is called

A

data bank

B

database

C

data file

D

data record

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

43.

The logical data structure with a one-to-many relationship is a :

A

network

B

tree

C

chain

D

relational

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

44.

Updating a database means

A

revising the file structure

B

reorganizing the database

C

modifying or adding record occurrences

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

45.

In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

A

ALTER TRIGGERS

B

ALTER TABLE

C

MODIFY TRIGGERS IN TABLE

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

46.

When you have finished entering information into a form

A

the template is written to the data file

B

the contents of the form are written to the data file

C

the contents of the form can be printed

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

47.

The main idea behind computer files is that it is convenient to

A

arrange them

B

store information together

C

create them

D

access them

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

48.

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

A

the pin code

B

the last name

C

a compound key consisting of the first name and the last name

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

49.

In SQL, which command is used to add new rows to a table?

A

ALTER TABLE

B

ADD ROW

C

INSERT

D

APPEND

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

50.

A number of related records that are treated as a unit is called

A

file

B

field

C

data

D

batch

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion