Databases-Database Design (GATE Computer Science): Questions 54 - 60 of 72

Get 1 year subscription: Access detailed explanations (illustrated with images and videos) to 913 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. View Sample Explanation or View Features.

Rs. 450.00 or

Question number: 54

» Databases » Database Design

MCQ▾

Question

A variety of disk-organization techniques, collectively called ________.

Choices

Choice (4) Response

a.

red arrays of independent disks

b.

redundant arrays of independent desktop

c.

arrays of independent disks

d.

redundant arrays of independent disks

Question number: 55

» Databases » Database Design

MCQ▾

Question

________ is an index record appears for only some of the search-key values.

Choices

Choice (4) Response

a.

Dense index

b.

Sparse index

c.

Clustering File Organization

d.

Hashing file organization.

Question number: 56

» Databases » Database Design

MCQ▾

Question

The time spent waiting for the sector to be accessed to appear under the head is called the ________.

Choices

Choice (4) Response

a.

Seek time

b.

Average seek time

c.

Access time

d.

Rotational latency time

Question number: 57

» Databases » Database Design

MCQ▾

Question

FDDI is a

Choices

Choice (4) Response

a.

mesh network

b.

ring network

c.

star network

d.

None of the above

Question number: 58

» Databases » Database Design

MCQ▾

Question

Database operator used in -

Choices

Choice (4) Response

a.

ADD

b.

PASTE

c.

UNION

d.

Both a. and c. are correct

Question number: 59

» Databases » Database Design

MCQ▾

Question

________ is a specialized type of index designed for easy querying on multiple keys, although each bitmap index is built on a single key.

Choices

Choice (4) Response

a.

Rollback segments

b.

Bitmap indices

c.

index organized table

d.

None of the above

Question number: 60

» Databases » Database Design

MCQ▾

Question

In an ________records are stored in an Oracle B-tree index instead of in a heap.

Choices

Choice (4) Response

a.

Rollback segments

b.

index organized table

c.

Bitmap indices

d.

All of the above

Sign In