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

» Databases » Query Languages

MCQ▾

Question

A ________ consists of a sequence of query and/or update statements.

Choices

Choice (4) Response

a.

transformation

b.

transaction

c.

transfer

d.

Question does not provide sufficient data or is vague

Question number: 116

» Databases » Query Languages

MCQ▾

Question

Any record can be placed anywhere in the file where there is space for the record is called as________

Choices

Choice (4) Response

a.

Heap file organization

b.

Clustering File Organization

c.

Sequential file organization

d.

Hashing file organization

Question number: 117

» Databases » Relational Model

MCQ▾

Question

The ________ operation denoted by – and it allows us to find tuples that are in one relation but are not in another.

Choices

Choice (4) Response

a.

Entity set

b.

set-difference

c.

relation

d.

All of the above

Question number: 118

» Databases » Relational Model

MCQ▾

Question

The Select Operation denoted to ________

Choices

Choice (4) Response

a.

sigma (σ)

b.

c.

union

d.

None of the above

Question number: 119

» Databases » Database Design

MCQ▾

Question

Flash memory is also known as ________

Choices

Choice (4) Response

a.

Main memory

b.

memory

c.

cache

d.

Electrically erasable programmable read-only memory

Question number: 120

» Databases » Relational Model

MCQ▾

Question

Query languages can be categorized as

Choices

Choice (4) Response

a.

nonprocedural language

b.

SQL

c.

procedural language

d.

Both c. and a. are correct

Question number: 121

» Databases » Relational Model

MCQ▾

Question

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A is called ________.

Choices

Choice (4) Response

a.

Many to many

b.

One to many

c.

One to one

d.

Many to one

Sign In