Databases (GATE Computer Science): Questions 102 - 107 of 154

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: 102

» Databases » Relational Model

MCQ▾

Question

set difference, Cartesian product and union operations are called________?

Choices

Choice (4) Response
a.

Entity set

b.

binary operations

c.

unary operations

d. None of the above

Question number: 103

» Databases » Database Design

MCQ▾

Question

The ________ is the rate at which data can be retrieved from or stored to the disk.

Choices

Choice (4) Response
a.

Rotational latency time

b.

Average seek time

c.

Access time

d.

data-transfer rate

Question number: 104

» Databases » Relational Model

MCQ▾

Question

An entity in A is associated with any number (zero or more) of entities in B. An entity in B, however, can be associated with at most one entity in A is called ________.

Choices

Choice (4) Response
a.

many to many

b.

one to one

c.

one to many

d.

many to one

Question number: 105

» 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: 106

» 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: 107

» 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

Sign In