Relational Databases Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Relational Databases “. These questions are chosen from a collection of most authoritative and best reference books on DBMS.Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on Relational Databases comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Relational Databases Mcqs

Computer MCQS

Sciences MCQS

1.
Foreign key is the one in which the ________ of one relation is referenced in another relation.

Foreign key

Primary key

References

Check constraint

Answer Discus (0)

2.
Domain constraints, functional dependency and referential integrity are special forms of _________.

Foreign key

Primary key

Assertion

Referential constraint

Answer Discus (0)

3.
Which one of the following uniquely identifies the elements in the relation?

Secondary Key

Primary key

Composite key

Foreign key

Answer Discus (0)

4.
A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

Rows

Key

Attribute

Fields

Answer Discus (0)

7.
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .

Candidate

Primary

Super

Sub

Answer Discus (0)

8.
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called

Referential relation

Referencing relation

Referenced relation

Referred relation

Answer Discus (0)

9.
The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .

Referential relation

Referencing relation

Referenced relation

Referred relation

Answer Discus (0)

10.
A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

Referential

Referencing

Specific

Primary

Answer Discus (0)

12.
The primary key is selected from the:

Composite keys

Determinants

Candidate keys

Foreign keys

Answer Discus (0)

13.
Which of the following is a group of one or more attributes that uniquely identifies a row?

Key

Determinant

Tuple

Relation

Answer Discus (0)

14.
A relation is considered a:

Column

One-dimensional table

Two-dimensional table

Three-dimensional table

Answer Discus (0)

15.
In the relational model, relationships between relations or tables are created by using:

Composite keys

Determinants

Candidate keys

Foreign keys

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

0Shares
0
Scroll to Top