QUESTION /ANSWER TOPIC: (13.2) Secondary Storage Management Questions

QUESTION /ANSWER TOPIC: (13.2) Secondary Storage Management Questions

ID: 102

COURSE: CS257

QUESTION 1: Disks controllers are capable of ______.

A)  Controlling the mechanical actuator that moves the head assembly.

B)  Selecting the sector from among all those in the cylinder at which heads are positioned.

C)  Transferring bits between desired sector and main memory.

D)  All of the above

QUESTION 2: Disk controller positions the head assembly at the cylinder containing the track on which the block is located. The time to do so is termed as ______

A)  Seek Time

B)  Rotational latency

C)  Transfer time.

D)  None of the above

QUESTION 3: The sum of the seek time, rotational latency, and transfer time is ______?

A)  Access Time

B)  Round trip time

C)  Latency of the disk

D)  Not Defined

QUESTION 4: The upper and lower surfaces of the platters are covered with a thin layer of ______material?

A)  Ferrous

B)  Platinum

C)  Magnetic

D)  Aluminum

QUESTION 5: The disk is organized into ______, which are concentric circles on a single

Platter.

A)  Tracks

B)  Sectors

C)  Spindle

D)  Gaps

ANSWER KEY: 1) D 2) A 3) C 4) C 5) A

Match correct graph

a . Raid 1

b Raid 4

c. Raid 5

d. Raid 6

1.

2. ___

3. _

____

4.

____

5 . What is other name for Mirroring as a Redundancy Technique

a. Raid 1

b. Raid 4

c. Raid 5

d. Raid 6

6. How many drives fault tolerance can Raid 4 has

a. 1

b. 2

c. 3

d. 4

7. How many drives fault tolerance can Raid 6 has

a.1

b. 2

c. 3

d. 4

8. For Raid 4

if have 4 disk

disk 1: 11110000

disk 2: Fail

disk 3: 00111000

disk 4: 01100010

The disk 4 is redundant disk. What the disk 2 parity is

a. 00011100

b. 1110001

c. 10101011

d. 10101010

AnswerKey

1. b

2. a

3. d

4. c

5. a

6. a

7. b

8. d

Mangesh A Dahale

SJSU ID : 008661016

Multiple Choice Questions for Chapter 13.5 Arranging Data on Disk

1. A pointer to schema for the data stored in record is useful for

a. skipping over records without consulting schema

b. finding the fields of the record

c. implementing database transactions

d. keeping subsequent records in the block

Answer : b. finding the fields of the record

2. Many machines allow more efficient reading and writing of main memory when data begins at an address that is a multiple of

a. 2 or 3

b. 5 or 7

c. 4 or 8

d. 3 or 7

Answer : c. 4 or 8

3. Any record begins with

a. Header

b. Data

c. Empty block

d. Address

Answer : a. Header

4. Which of the following information may be useful for implementing database transactions

a. Pointers

b. length of record

c. Timestamp

d. Directory

Answer : c. Timestamp

5. CREATE TABLE MovieStar(

name CHAR(30) PRIMARY KEY,

address VARCHAR(255),

gender CHAR(l),

birth date DATE

);

In the above SQL table declaration, If we assume that fields must start at the byte that is multiple of 4, how much space will be allocated for field "name"?

a. 4

b. 8

c. 32

d. 36

Answer : c. 32