Relational Database
Conceptual questions on relational database fundamentals including attributes, keys, entity sets, data models, relationships, and relational algebra operations.
Questions
Which of the following is/are not known as attribute type in a relation?
- Composite
- Single - valued
- Derived
- Unary
- Simple
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.
- Q only
- P only
- Both P and Q
- Both P and R
- R only
In how many types can the connectivity of a relationship be classified?
- 8
- 6
- 4
- 5
- 3
The members of a weak entity set are called _______.
- subordinate entity set
- dominant entity set
- compound entity set
- derived entity set
- none of these
How many types of record based data models are there in a database?
- 6
- 5
- 4
- 3
- 2
How many types of attributes are there in a relational database?
- 6
- 5
- 4
- 3
- None of these
Which of the following operations is/are unary operations?
- Difference
- Selection
- Projection
- Both 2 and 3
- All of these
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.
- P only
- Both P and Q
- Both P and R
- Both Q and R
- All of these
How many types of keys are there in a relational database?
- 9
- 7
- 8
- 6
- None of these
A relationship can be classified in terms of
- degree
- connectivity
- composition
- both 1 and 2
- all of these
Which of the following entity set does not have a primary key?
- Composite entity set
- Weak entity set
- Strong entity set
- Derived entity set
- None of these
Which of the following operations is/are known as binary operations?
- Intersection
- Cartesian product
- Difference
- Both 2 and 3
- All of these
How many types of data models are present in DBMS?
- 5
- 4
- 3
- 2
- None of these
The members of strong entity set are called _______.
- dominant entity
- derived entity
- subordinate entity
- composite entity
- none of these
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.
- Both P and Q
- R only
- None of these
- All of these
- Both P and R