0

Database

Description: Concept Based Questions
Number of Questions: 15
Created by:
Tags: Concept Based Questions Databases
Attempted 0/15 Correct 0 Score 0

How many types of connectivity of a relationship are there?

  1. 8

  2. 6

  3. 4

  4. 5

  5. 3


Correct Option: C
Explanation:

Connectivity means how many instances of one entity are associated with how many instances of another entity. The connectivity of a relationship can be classified into 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.

How many types of keys are there in relational database?

  1. 9

  2. 7

  3. 8

  4. 6

  5. None of these


Correct Option: B
Explanation:

There are seven types of keys in 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 is the correct answer.

Which of the following entity sets 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 doesn’t have sufficient attributes to form a primary key and relies on another for its identification is called a weak entity set. It doesn’t have a primary key. So, this is the correct answer.

The members of strong entity set are collectively called

  1. dominant entity

  2. derived entity

  3. subordinate entity

  4. composite entity

  5. None of these


Correct Option: A
Explanation:

This is the correct answer.  

All of the following are the types of attribute, except

  1. composite

  2. single-valued

  3. derived

  4. unary

  5. simple


Correct Option: D
Explanation:

This is the correct answer. There are five types of attribute in database. These are: 1.) Simple attribute 2.) Composite attribute 3.) Single-valued attribute 4.) Multivalued attribute 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 following statements is/are true?

P: Foreign key cannot have a null value. Q: Primary key and foreign key can exist in the 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:

Statement Q is correct because primary key and foreign key can exist in the same relation. Moreover, foreign key can refer to the primary key in the same relation. So, this is correct.

How many types of attributes are there in 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 relational database. These are: 1.) Simple attribute 2.) Composite attribute 3.) Single-valued attribute 4.) Multivalued attribute 5.) Derived attribute So, this is the correct answer.

Which of the following statements is/are correct?

P: Total number of tuples at any one time is known as degree of a relation. Q: Total number of columns that comprise a relation is known as cardinality of the relation. R: Restrictions can be applied on the values of attributes.

  1. Both P and Q

  2. R only

  3. Both P and R

  4. All of these

  5. None of these


Correct Option: B
Explanation:

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

How many types of data models are there in DBMS?

  1. 5

  2. 4

  3. 3

  4. 2

  5. None of these


Correct Option: C
Explanation:

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 is the correct answer.

The members of weak entity set are collectively called

  1. subordinate entity

  2. dominant entity

  3. compound entity

  4. derived entity

  5. None of these


Correct Option: A
Explanation:

This is the correct answer.  

Which of the following statements is/are correct?

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

  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:

Statement 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. Statement 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. Statement Q is false because if the primary key is composed of more than one attribute, then these attributes are known as prime attributes, not super attributes.

Which of the following is/are binary operation(s)?

  1. Intersection

  2. Cartesian product

  3. Difference

  4. Both (2) and (3)

  5. All of these


Correct Option: D
Explanation:

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

A relationship can be classified in terms of

  1. degree

  2. connectivity

  3. composition

  4. Both (1) and (3)

  5. All of the above


Correct Option: B
Explanation:

Connectivity can also be used to describe a relation. Connectivity means how many instances of one entity are associated with how many instances of another entity. It can be:

  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.

Which of the following is/are unary operation(s)?

  1. Union

  2. Selection

  3. Projection

  4. Both (2) and (3)

  5. All of these


Correct Option: D
Explanation:

This is the correct choice.

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

  1. 6

  2. 5

  3. 4

  4. 3

  5. 2


Correct Option: D
Explanation:

There are 3 types of record-based data models. These are: 1.) Hierarchical model 2.) Network model 3.) Relational model So, this is the correct choice.

- Hide questions