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

» Databases » Relational Model

MCQ▾

Question

if introduce another class of storage that is called ________

Choices

Choice (4) Response

a.

transaction

b.

storage class

c.

stable storage

d.

None of the above

Question number: 16

» Databases » Relational Model

MCQ▾

Question

________are described in a database by a set of attributes.

Choices

Choice (4) Response

a.

a table

b.

relation

c.

Entities

d.

All of the above

Question number: 17

» Databases » Relational Model

MCQ▾

Question

Creates a new table is used for SQL command-

Choices

Choice (4) Response

a.

CREATE DATABASE

b.

ALTER DATABASE

c.

CREATE TABLE

d.

Question does not provide sufficient data or is vague

Question number: 18

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

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

» Databases » Relational Model

MCQ▾

Question

________users interact with the system without writing programs.

Choices

Choice (4) Response

a.

Specialized users

b.

Naive users

c.

Sophisticated users

d.

user

Question number: 21

» Databases » Relational Model

MCQ▾

Question

The ________operation is an extension of the join operation to deal with missing information.

Choices

Choice (4) Response

a.

inner-join

b.

right-join

c.

left-join

d.

outer-join

Question number: 22

» Databases » Relational Model

MCQ▾

Question

A ________ is an attribute or combination of attributes that uniquely identifies each instance of an entity type.

Choices

Choice (4) Response

a.

Foreign key

b.

Candidate key

c.

Primary key

d.

None of the above

Sign In