Database Systems Questions

MCQ bookmark_border

1.

Which of the following places the common data elements in order from smallest to largest?

A

character, file, record, field, database

B

character, record, field, database, file

C

character, field, record, file, database

D

Bit, byte, character, record, field, file, database

E

None of these

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

Which of the following statements is FALSE concerning file?

A

Files may share the same name or the same extension but not both

B

Every file in the same foldr must have a unique name

C

File extension is another name for file type

D

The file extension comes before the dot (.) followed by the file name

E

None of these

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

DBMS Stand for 

A

Data base marginal system 

B

Directory Based Memory Standard

C

Data Base Management System

D

Dual Bus Mask Storage

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

A collection of interrelated file in computer is a-

A

File manager

B

Field

C

Record

D

Database

Correct Answer: D

Database.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

The complete picture of data stored in database is known as

A

Record

B

Schema

C

System flowchart

D

DBMS

E

None of the above

Correct Answer: B

Schema : The database schema of a database system is its structure described in a formal language supported by the database management system (DBMS). The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of the schema. All constraints are expressible in the same language. A database can be considered a structure in realization of the database language. The states of a created conceptual schema are transformed into an explicit mapping, the database schema. This describes how real-world entities are modeled in the database.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

A report generator is used to

A

update files

B

print files on paper

C

data entry

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

Which of the following is not a logical data-base structure?

A

tree

B

relational

C

network

D

chain

E

All of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

8.

Which of the following is a database administrator's function?

A

database design

B

backing up the database

C

performance monitoring

D

user coordination

E

All of the above

Correct Answer: E

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

9.

Primitive operations common to all record management systems include

A

Print

B

Sort

C

Look-up

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

10.

Each of data files has a _____ that describe the way the data is stored in the file.

A

File structure

B

Records

C

Fields

D

Database

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion