Databases-Relational Model (GATE Computer Science): Questions 37 - 43 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: 37

» 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

Question number: 38

» Databases » Relational Model

MCQ▾

Question

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

Choices

Choice (4) Response
a.

one to one

b.

many to one

c.

one to many

d. All of the above

Question number: 39

» Databases » Relational Model

MCQ▾

Question

The ________is a proposed standard for creating specifications of various components of a software system.

Choices

Choice (4) Response
a.

set

b.

UML

c.

aggregation

d.

Entity set

Question number: 40

» Databases » Relational Model

MCQ▾

Question

The relational algebra is a ________ language.

Choices

Choice (4) Response
a.

procedural language,

b.

nonprocedural language

c.

SQL

d. Both a. and b. are correct

Question number: 41

» Databases » Relational Model

MCQ▾

Question

The basic structure of an SQL expression consists of how many clauses?

Choices

Choice (4) Response
a.

whrere

b.

select

c.

from

d. All a. , b. and c. are correct

Question number: 42

» Databases » Relational Model

MCQ▾

Question

The ________ operation, denoted by a cross (),

Choices

Choice (4) Response
a.

Cartesian-product

b.

relation

c.

Entity set

d. Question does not provide sufficient data or is vague

Question number: 43

» Databases » Relational Model

MCQ▾

Question

________ proceeds from the recognition that a number of entities set share some common features.

Choices

Choice (4) Response
a.

Specification

b.

Generalization

c.

Entity

d.

Entity set

Sign In