Databases-Database Design (GATE Computer Science): Questions 35 - 40 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: 35

» Databases » Database Design

MCQ▾

Question

________ sort–merge is an alternative to range partitioning.

Choices

Choice (4) Response
a.

Parallel external

b.

serial external

c.

Range-partitioning

d. All of the above

Question number: 36

» Databases » Database Design

MCQ▾

Question

Personal computers assumed the user-interface functionality that used to be handled directly by the ________?

Choices

Choice (4) Response
a.

system

b.

client systems

c.

centralized system

d.

server system

Question number: 37

» Databases » Database Design

MCQ▾

Question

Consider a relation r that is to be stored in the database. hwo many approaches to storing this relation in the distributed database?

Choices

Choice (4) Response
a.

Four

b.

Six

c.

Two

d.

Three

Question number: 38

» Databases » Database Design

MCQ▾

Question

The user of a distributed database system should not be required to know either where the data are physically located or how the data can be accessed at the specific local site and this property is called-

Choices

Choice (4) Response
a.

data transparency

b.

transaction

c.

transfer

d. Question does not provide sufficient data or is vague

Question number: 39

» Databases » Database Design

MCQ▾

Question

The state of the art in recovery methods is best illustrated by the ________

Choices

Choice (4) Response
a.

log based recovery

b.

ARIES recovery method

c.

transaction based recovery

d. All of the above

Question number: 40

» Databases » Database Design

MCQ▾

Question

A domain is atomic if elements of the domain are considered to be indivisible units and relation schema R is in ________ if the domains of all attributes of R are atomic.

Choices

Choice (4) Response
a.

first normal form

b.

second normal form

c.

third normal form

d. Question does not provide sufficient data or is vague

Sign In