Database Systems Questions

MCQ bookmark_border

31.

In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.

A

Network database

B

Relational database

C

Distributed database

D

Hierarchical database

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

32.

Which two files are used during operation of the DBMS?

A

query language and utilities

B

data manipulation language and query language

C

data dictionary and transaction log

D

data dictionary and query language

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

33.

When using a database management system, the first thing that you must do is to

A

create a database file

B

activate file editor

C

load the software into your micro

D

keep a floppy disk in readiness

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

34.

A network schema

A

restricts the structure to a one-to-many relationship

B

permits many-to-many relation

C

stores data in tables

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

35.

Which of the following is not a relational database?

A

dBASE IV

B

4th Dimension

C

FoxPro

D

Reflex

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

36.

Which command is used to remove a table from the database in SQL?

A

DELETE TABLE

B

DROP TABLE

C

ERASE TABLE

D

UNATTACH TABLE

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

37.

A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

A

Specialized file

B

Log file

C

Master file

D

Update file

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

38.

A file produced by a spreadsheet

A

is generally stored on disk in an ASCII text format

B

can be used as it by the DBMS

C

can be used for graphic

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

39.

A form defines

A

where data is placed on the screen

B

the width of each field

C

both (a) and (b)

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

40.

Which of the following is true of a network structure?

A

It is a physical representation of the data

B

It allows a many-to-many relationship

C

It is conceptually simple

D

It will be the dominant data base of the future

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion