Relational Database

Conceptual questions on relational database fundamentals including attributes, keys, entity sets, data models, relationships, and relational algebra operations.

15 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is/are not known as attribute type in a relation?

  1. Composite
  2. Single - valued
  3. Derived
  4. Unary
  5. Simple
Question 2 Multiple Choice (Single Answer)

Which of the given statements is/are true?
P : Foreign key cannot have a null value.
Q : The primary key and foreign key can exist in a same relation.
R : Foreign key relation is known as target relation.

  1. Q only
  2. P only
  3. Both P and Q
  4. Both P and R
  5. R only
Question 3 Multiple Choice (Single Answer)

In how many types can the connectivity of a relationship be classified?

  1. 8
  2. 6
  3. 4
  4. 5
  5. 3
Question 4 Multiple Choice (Single Answer)

The members of a weak entity set are called _______.

  1. subordinate entity set
  2. dominant entity set
  3. compound entity set
  4. derived entity set
  5. none of these
Question 5 Multiple Choice (Single Answer)

How many types of record based data models are there in a database?

  1. 6
  2. 5
  3. 4
  4. 3
  5. 2
Question 6 Multiple Choice (Single Answer)

How many types of attributes are there in a relational database?

  1. 6
  2. 5
  3. 4
  4. 3
  5. None of these
Question 7 Multiple Choice (Single Answer)

Which of the following operations is/are unary operations?

  1. Difference
  2. Selection
  3. Projection
  4. Both 2 and 3
  5. All of these
Question 8 Multiple Choice (Single Answer)

Which of the following statements is/are correct?
P : Candidate key cannot be null.
Q : If the primary key is composed of more than one attribute, then these attributes are known as super attributes.
R : All the candidate keys can be primary keys.

  1. P only
  2. Both P and Q
  3. Both P and R
  4. Both Q and R
  5. All of these
Question 9 Multiple Choice (Single Answer)

How many types of keys are there in a relational database?

  1. 9
  2. 7
  3. 8
  4. 6
  5. None of these
Question 10 Multiple Choice (Single Answer)

A relationship can be classified in terms of

  1. degree
  2. connectivity
  3. composition
  4. both 1 and 2
  5. all of these
Question 11 Multiple Choice (Single Answer)

Which of the following entity set does not have a primary key?

  1. Composite entity set
  2. Weak entity set
  3. Strong entity set
  4. Derived entity set
  5. None of these
Question 12 Multiple Choice (Single Answer)

Which of the following operations is/are known as binary operations?

  1. Intersection
  2. Cartesian product
  3. Difference
  4. Both 2 and 3
  5. All of these
Question 13 Multiple Choice (Single Answer)

How many types of data models are present in DBMS?

  1. 5
  2. 4
  3. 3
  4. 2
  5. None of these
Question 14 Multiple Choice (Single Answer)

The members of strong entity set are called _______.

  1. dominant entity
  2. derived entity
  3. subordinate entity
  4. composite entity
  5. none of these
Question 15 Multiple Choice (Single Answer)

Which of the given statements are correct?
P : Total number of tuples at any one time is known as degree of a relation.
Q : Total number of columns that comprises of a relation is known as cardinality of a relation.
R : Restrictions can be applied on the value of attributes.

  1. Both P and Q
  2. R only
  3. None of these
  4. All of these
  5. Both P and R