Databases-Relational Model [GATE (Graduate Aptitude Test in Engineering) Computer Science]: Questions 1 - 6 of 102

Access detailed explanations (illustrated with images and videos) to 2122 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 550.00 -OR-

How to register? Already Subscribed?

Question 1

Relational Model

Question

MCQ▾

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

Choices

Choice (4)Response

a.

Primary Key

b.

Alternative Key

c.

Candidate Key

d.

Question does not provide sufficient data or is vague

Question 2

Relational Model

Question

MCQ▾

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.

second normal form

b.

first normal form

c.

third normal form

d.

All of the above

Question 3

Relational Model

Question

MCQ▾

________ are the most elementary form of integrity constraint.

Choices

Choice (4)Response

a.

Consistency

b.

Domain constraints

c.

Keys

d.

Referential integrity

Question 4

Relational Model

Question

MCQ▾

A functional dependency is a relationship between or among:

Choices

Choice (4)Response

a.

Tables

b.

Rows

c.

Attributes

d.

Relations

Question 5

Relational Model

Appeared in Year: 2015 (UGC-NET)

Question

MCQ▾

A relation R = {A, B, C, D, E, F, G} is given with following set of functional dependencies:

Which of the following is a candidate key? (December)

Choices

Choice (4)Response

a.

A

b.

ABD

c.

ABC

d.

AB

Question 6

Relational Model

Appeared in Year: 2015 (UGC-NET)

Question

Match List-Ⅰ List-Ⅱ▾

Match the following database terms to their functions: (December)

List-ⅠList-Ⅱ
(A)

External Schema

(i)

Define view (s) of the database for particular user (s)

(B)

Referential Integrity

(ii)

Enforces match of primary key to foreign key

(C)

Normalization

(iii)

Reduces data redundancy in a database

(D)

Data Dictionary

(iv)

Contains metadata describing database structure.

Choices

Choice (4)Response
  • (A)
  • (B)
  • (C)
  • (D)

a.

  • (iii)
  • (i)
  • (ii)
  • (iv)

b.

  • (iv)
  • (i)
  • (ii)
  • (iii)

c.

  • (ii)
  • (iii)
  • (i)
  • (iv)

d.

  • (i)
  • (ii)
  • (iii)
  • (iv)

Developed by: