Databases (GATE Computer Science): Questions 42 - 48 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: 42

» Databases » Relational Model

MCQ▾

Question

The ________ ensures transaction atomicity by recording all database modifications in the log.

Choices

Choice (4) Response

a.

immediate technique

b.

immediate-modification technique

c.

deferred-modification technique

d.

None of the above

Question number: 43

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

» Databases » Query Languages

MCQ▾

Question

“Zipping” a fie means-

Choices

Choice (4) Response

a.

Transfer the message

b.

Encrypting the message

c.

Compressing the file

d.

All of the above

Question number: 45

» Databases » Relational Model

MCQ▾

Question

Candidate key, primary key and foreign key all are used in ________

Choices

Choice (4) Response

a.

Design

b.

Database Design

c.

ALTER DATABASE

d.

All of the above

Question number: 46

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

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

» Databases » File Structures

MCQ▾

Question

The database system resides permanently on non-volatile storage and is partitioned into fixed-length storage units called ________.

Choices

Choice (4) Response

a.

tape

b.

blocks

c.

sector

d.

All of the above

Sign In