Databases-Relational Model (GATE Computer Science): Questions 30 - 36 of 49

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: 30

» Databases » Relational Model

MCQ▾

Question

set difference, Cartesian product and union operations are called________?

Choices

Choice (4) Response

a.

Entity set

b.

binary operations

c.

unary operations

d.

None of the above

Question number: 31

» Databases » Relational Model

MCQ▾

Question

An entity in A is associated with any number (zero or more) of entities in B. An entity in B, however, can be associated with at most one entity in A is called ________.

Choices

Choice (4) Response

a.

many to many

b.

one to one

c.

one to many

d.

many to one

Question number: 32

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

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

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

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

» 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

f Page
Sign In