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

» Databases » Relational Model

MCQ▾

Question

QBE stands for ________

Choices

Choice (4) Response

a.

question-by-element

b.

Query-by-Example

c.

Query-Example

d.

Question does not provide sufficient data or is vague

Question number: 70

» Databases » Database Design

MCQ▾

Question

A domain is atomic if elements of the domain are considered to be indivisible units and relation schema R is in ________ if the domains of all attributes of R are atomic.

Choices

Choice (4) Response

a.

first normal form

b.

second normal form

c.

third normal form

d.

Question does not provide sufficient data or is vague

Question number: 71

» Databases » Relational Model

MCQ▾

Question

what is a components of the entity-relationship (E-R) data model?

Choices

Choice (4) Response

a.

Retangle

AND

Diamonds

b.

Ellipses

c.

Lines

d.

All a. , b. and c. are correct

Question number: 72

» Databases » Transactions and Concurrency Control

MCQ▾

Question

A ________ is a unit of program execution that accesses and possibly updates various data items

Choices

Choice (4) Response

a.

transformation

b.

transaction

c.

transfer

d.

Question does not provide sufficient data or is vague

Question number: 73

» Databases » Database Design

MCQ▾

Question

________ may suffer from the same types of failure that a centralized system does?

Choices

Choice (4) Response

a.

peer system

b.

distributed system

c.

parallel system

d.

Question does not provide sufficient data or is vague

Question number: 74

» Databases » ER-Model

MCQ▾

Question

A relation schema can be thought of as the basic information describing a ________ or ________.

Choices

Choice (4) Response

a.

Entity set

b.

relation

c.

a table or relation.

d.

Both b. and c. are correct

f Page
Sign In