Database Systems Questions

MCQ bookmark_border

51.

If you want to group the records in the abc database, you could use the Jobcode as the _____.

A

Delete

B

Update

C

Sort Key

D

Index

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

52.

The Management Information system (MIS) structure with one main computer system is called a

A

hierarchical MIS structure

B

distributed MIS structure

C

centralized MIS structure

D

decentralized MIS structure

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

53.

If a calculation is embedded in a form

A

the result of the calculations are stored with the form

B

the calculations are stored with the form

C

the result of the calculations are printed in report

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

54.

Data security threats include

A

hardware failure

B

privacy invasion

C

fraudulent manipulation of data

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

55.

An operation that will increase the length of a list is

A

Insert

B

Look-up

C

Modify

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

56.

In SQL, which command is used to add a column/integrity constraint to a table

A

ADD COLUMN

B

INSERT COLUMN

C

MODIFY TABLE

D

ALTER TABLE

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

57.

In SQL, which command(s) is(are) used to enable/disable a database trigger?

A

ALTER TRIGGER

B

ALTER DATABASE

C

ALTER TABLE

D

MODIFY TRIGGER

E

All of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

58.

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

A

Relations

B

Domains

C

Queries

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

59.

In SQL, which command is used to changes data in a table?

A

UPDATE

B

INSERT

C

BROWSE

D

APPEND

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

60.

What name is given to the collection of facts, items of information or data which are related in some way?

A

Database

B

Directory information

C

Information tree

D

Information provider

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion