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

» Databases » Relational Model

MCQ▾

Question

An entity in A is associated with any number (zero or more) of entities in B, and an entity in B is associated with any number (zero or more) of entities in A is called ________.

Choices

Choice (4) Response

a.

one to one

b.

many to many

c.

one to many

d.

many to one

Question number: 109

» Databases » Query Languages

MCQ▾

Question

An ________ is a log of all changes (inserts/deletes/updates) to the database along with information.

Choices

Choice (4) Response

a.

transformation

b.

transaction

c.

audit trail

d.

transfer

Question number: 110

» Databases » Database Design

MCQ▾

Question

FDDI is a

Choices

Choice (4) Response

a.

mesh network

b.

ring network

c.

star network

d.

None of the above

Question number: 111

» Databases » Database Design

MCQ▾

Question

Database operator used in -

Choices

Choice (4) Response

a.

ADD

b.

PASTE

c.

UNION

d.

Both a. and c. are correct

Question number: 112

» Databases » Database Design

MCQ▾

Question

________ is a specialized type of index designed for easy querying on multiple keys, although each bitmap index is built on a single key.

Choices

Choice (4) Response

a.

Rollback segments

b.

Bitmap indices

c.

index organized table

d.

None of the above

Question number: 113

» Databases » Relational Model

MCQ▾

Question

The project operation is a denoted to ________.

Choices

Choice (4) Response

a.

sigma (σ)

b.

c.

union

d.

Question does not provide sufficient data or is vague

Question number: 114

» Databases » Database Design

MCQ▾

Question

In an ________records are stored in an Oracle B-tree index instead of in a heap.

Choices

Choice (4) Response

a.

Rollback segments

b.

index organized table

c.

Bitmap indices

d.

All of the above

Sign In