0

Relational Database

Description: Conceptual database questions
Number of Questions: 15
Created by:
Tags: Conceptual database questions Database
Attempted 0/15 Correct 0 Score 0

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


Correct Option: D
Explanation:

This answer is correct . There are five types of attributes in database. These are :- 1.) Simple attribute 2.) Composite attribute  3.) Single-valued attribute 4.) Multivalued attribute and 5.) Derived attribute. There is no attribute named Unary. Unary is a type of relation which is known as degree of relation (unary, binary, ternary etc.). So this is the correct answer according to the question.

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


Correct Option: A
Explanation:

This is true choice. Q statement is correct because the primary key and the foreign key can exist in the same relation. Moreover foreign key can refer to the primary key in the same relation.So, this is a correct choice.

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

  1. 8

  2. 6

  3. 4

  4. 5

  5. 3


Correct Option: C
Explanation:

This answer is correct. Connectivity means how many instances of one entity are associated with how many instances of other entity. Connectivity of a relationship can be classified in 4 types. These are :- 1.) One to one (1 : 1) 2.) One to many (1 : M) 3.) Many to one (M : 1) 4.) Many to many(M : N). So, this answer is correct.

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


Correct Option: A
Explanation:

This answer is correct. There is no particular reason to explain this answer, because there is a name convention in DBMS. The members of weak entity set are called subordinate entity set. So, this answer is correct.

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

  1. 6

  2. 5

  3. 4

  4. 3

  5. 2


Correct Option: D
Explanation:

This answer is correct. There are 3 types of record based data models. These are :- 1.) Hierarchical model 2.) Network model 3.) Relational model

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

  1. 6

  2. 5

  3. 4

  4. 3

  5. None of these


Correct Option: B
Explanation:

There are five types of attributes in a database. These are :- 1.) Simple attribute 2.) Composite attribute 3.) Single-valued attribute 4.) Multivalued attribute 5.) Derived attribute

Which of the following operations is/are unary operations?

  1. Difference

  2. Selection

  3. Projection

  4. Both 2 and 3

  5. All of these


Correct Option: D
Explanation:

Both the options are correct. So, this choice is correct.

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


Correct Option: C
Explanation:

Option P is correct because a candidate key is a key that uniquely identifies a row in a relation. So, this cannot be null as it uniquely identifies a row. Option R is correct because primary key is chosen from a set of candidate keys. In other words all the candidate keys are the candidates for the primary key. So, in this way all the candidate keys are primary keys. So, this is the correct answer.

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

  1. 9

  2. 7

  3. 8

  4. 6

  5. None of these


Correct Option: B
Explanation:

This answer is correct. There are seven types of keys in a relational database. These are :- 1.) Primary key 2.) Candidate key 3.) Super key 4.) Foreign key 5.) Alternate key 6 .) Artificial key 7.) Composite key So, this answer is correct.

A relationship can be classified in terms of

  1. degree

  2. connectivity

  3. composition

  4. both 1 and 2

  5. all of these


Correct Option: D
Explanation:

Yes, this is the correct answer. Both  are correct.

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


Correct Option: B
Explanation:

This is the correct answer. The entity set that does not have sufficient attributes to form a primary key, and relies on another for its identification,  is called a weak entity set. It does not have a primary key. So, this is correct 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


Correct Option: E
Explanation:

All of the given options are true. So, this is the correct choice.

How many types of data models are present in DBMS?

  1. 5

  2. 4

  3. 3

  4. 2

  5. None of these


Correct Option: C
Explanation:

This answer is correct. There are 3 types of data models present in DBMS. These are :- 1.) Object based data model 2.) Record based data model 3.) Physical data model So, this answer is correct.

The members of strong entity set are called _______.

  1. dominant entity

  2. derived entity

  3. subordinate entity

  4. composite entity

  5. none of these


Correct Option: A
Explanation:

This answer is correct. There is no particular reason to explain this answer, because there is a name convention in DBMS. The members of strong entity set are called dominant entity set. So, this answer is correct.

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


Correct Option: B
Explanation:

This is a correct choice. Statement R is true because we can apply restrictions on values of attributes these are known as constraints. So, this answer is correct.

- Hide questions