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

» Databases » Database Design

MCQ▾

Question

An update log record describes a ________ write.

Choices

Choice (4) Response
a.

triple database

b.

Single database

c.

double database

d. Both a. and c. are correct

Question number: 29

» Databases » Database Design

MCQ▾

Question

________ can be broadly categorized as transaction servers and data servers.

Choices

Choice (4) Response
a.

Client system

b.

Centralized System

c.

Server System

d. All of the above

Question number: 30

» Databases » Database Design

MCQ▾

Question

A ________ is a repository (or archive) of information gathered from multiple sources stored under a unified schema at a single site.

Choices

Choice (4) Response
a.

data warehouse

b.

function

c.

data

d. None of the above

Question number: 31

» Databases » Database Design

MCQ▾

Question

________ sort works in two steps: first range partitioning the relation, then sorting each partition separately.

Choices

Choice (4) Response
a.

Parallel external

b.

serial external

c.

external

d. All of the above

Question number: 32

» Databases » Database Design

MCQ▾

Question

________ refers to the execution of a single query in parallel on multiple processors and disks.

Choices

Choice (4) Response
a.

serial external

b.

Intraquery parallelism

c.

Range-partitioning

d. All of the above

Question number: 33

» Databases » Database Design

MCQ▾

Question

Information ________are used to store and query textual data such as documents.

Choices

Choice (4) Response
a.

retrieval systems

b.

transfer

c.

parallel system

d. All of the above

Question number: 34

» Databases » Database Design

MCQ▾

Question

________ refers to reducing the time required to retrieve relations from disk by partitioning the relations on multiple disks

Choices

Choice (4) Response
a.

I/O parallelism

b.

transaction

c.

parallelism

d. None of the above

Sign In