Databases-Database Design (GATE (Graduate Aptitude Test in Engineering) Computer Science): Questions 48 - 53 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: 48

» Databases » Database Design

MCQ▾

Question

CAD stands for________

Choices

Choice (4) Response

a.

Computer-aided-diagram

b.

Computer-aided-design

c.

Computer-add-design

d.

Question does not provide sufficient data or is vague

Question number: 49

» Databases » Database Design

MCQ▾

Question

The ________allows database modifications to be output to the database while the transaction is still in the active state.

Choices

Choice (4) Response

a.

immediate-modification technique

b.

deferred-modification technique

c.

immediate technique

d.

None of the above

Question number: 50

» Databases » Database Design

MCQ▾

Question

2PC stands for________

Choices

Choice (4) Response

a.

Phase commission protocol

b.

three-phase commit protocol

c.

two-phase commit protocol

d.

All of the above

Question number: 51

» Databases » Database Design

MCQ▾

Question

A ________ sites may use different schemas.

Choices

Choice (4) Response

a.

Transaction

b.

Heterogeneous distributed database

c.

Homogeneous distributed database

d.

None of the above

Question number: 52

» Databases » Database Design

MCQ▾

Question

Records are stored in sequential order according to the value of a “ search key ” of each record is called________

Choices

Choice (4) Response

a.

Sequential file organization.

b.

Heap file organization.

c.

Hashing file organization.

d.

Clustering File

Question number: 53

» 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

f Page
Sign In