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

» Databases » Relational Model

MCQ▾

Question

Candidate key has only one ________in a table but there can be multiple candidates key.

Choices

Choice (4) Response

a.

Primary Key

b.

Alternative Key

c.

Candidate Key

d.

None of the above

Question number: 2

» Databases » Relational Model

MCQ▾

Question

INSERT SQL command used for-

Choices

Choice (4) Response

a.

drop a row

b.

add a row

c.

add a column

d.

None of the above

Question number: 3

» Databases » Relational Model

MCQ▾

Question

________to add attributes to an existing relation.

Choices

Choice (4) Response

a.

delete table command

b.

alter table command

c.

drop table command

d.

All of the above

Question number: 4

» Databases » Relational Model

MCQ▾

Question

A major purpose of a database system is to provide users with an ________of the data.

Choices

Choice (4) Response

a.

relation

b.

abstract view

c.

Entity set

d.

All of the above

Question number: 5

» Databases » Relational Model

MCQ▾

Question

The ________ ensures transaction atomicity by recording all database modifications in the log.

Choices

Choice (4) Response

a.

immediate technique

b.

immediate-modification technique

c.

deferred-modification technique

d.

None of the above

Question number: 6

» Databases » Relational Model

MCQ▾

Question

Candidate key, primary key and foreign key all are used in ________

Choices

Choice (4) Response

a.

Design

b.

Database Design

c.

ALTER DATABASE

d.

All of the above

Question number: 7

» Databases » Relational Model

MCQ▾

Question

To remove a relation from an SQL database which command?

Choices

Choice (4) Response

a.

after table

b.

delete table

c.

alter table

d.

drop table

Sign In