Database Management System Mock Test 6

10%

Question 1 of 10

1. Operating system is responsible for

disk initialization

all of the mentioned

booting from disk

bad-bock recovery

Question 1 of 10

Question 2 of 10

2. In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

Structured index

Unstructured index

Nonclustered index

Clustered index

Question 2 of 10

Question 3 of 10

3. The disk controller uses ________ at each sector to ensure that the data is not corrupted on data retrieval.

Unit drive

Checksum

Readsum

Read disk

Question 3 of 10

Question 4 of 10

4. Which of the following is a physical storage media?

All of the mentioned

Flash memory

Tape Storage

Optical Storage

Question 4 of 10

Question 5 of 10

5. The highest level in the hierarchy of data organization is called

Data base

Data record

Data file

Data bank

Question 5 of 10

Question 6 of 10

6. A top-to-bottom relationship among the items in a database is established by a

Network schema

All of the mentioned

Hierarchical schema

Relational schema

Question 6 of 10

Question 7 of 10

7. Hardware RAID implementations permit _________ that is, faulty disks can be removed and replaced by new ones without turning power off.

Hot swapping

None of the mentioned

Swapping

Scrapping

Question 7 of 10

Question 8 of 10

8. Choose the RDBMS which supports full fledged client server application development

Ingress

FoxPro 2.1

dBase V

Oracle 7.1

Question 8 of 10

Question 9 of 10

9. Which level of RAID refers to disk mirroring with block striping?

RAID level 2

RAID level 1

RAID level 3

RAID level 0

Question 9 of 10

Question 10 of 10

10. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

Tablespace

Extent

Block

Segment

Question 10 of 10