Home »
MCQs »
DBMS MCQs
DBMS Relational Model Concepts Multiple-Choice Questions (MCQs)
DBMS Relational Model Concepts MCQs: This section contains DBMS Relational Model Concepts Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on February 19, 2022
1. Tables with rows and columns can be viewed as ___.
- Analytical Models
- Relational Models
- Composite Models
- Database Models
Answer: B) Relational Models
Explanation:
Tables with rows and columns can be viewed as relational models.
Discuss this Question
2. What is a row in a table also known as?
- Tuple
- Name
- Attribute
- None
Answer: A) Tuple
Explanation:
Row in a table is also known as Tuple.
Discuss this Question
3. What column in a table is contained?
- Tuple
- Name
- Attribute
- Both B. and D.
Answer: D) Both B. and D.
Explanation:
Column in a table contains Name or Attribute.
Discuss this Question
4. In ___, there are a set of possible atomic values that apply to an attribute.
- Attribute
- Instance
- Domain
- Schema
Answer: C) Domain
Explanation:
In Domain, there are a set of possible atomic values that apply to an attribute.
Discuss this Question
5. In ___, columns in a particular table are listed by their names.
- Domain
- Attribute
- Instance
- Schema
Answer: B) Attribute
Explanation:
In Attribute, columns in a particular table are listed by their names.
Discuss this Question
6. ___ should be there in each attribute.
- Keys
- Schema
- Instance
- Domain
Answer: D) Domain
Explanation:
Domain should be there in each attribute.
Discuss this Question
7. What is TRUE about Relational Instance?
- Relational database systems store data in tuples, which represent a relational instance.
- There are no duplicate tuples in relation instances.
- Both A. and B.
- None of the above
Answer: C) Both A. and B.
Explanation:
In case of Relational Instance -
- Relational database systems store data in tuples, which represent a relational instance.
- There are no duplicate tuples in relation instances.
Discuss this Question
8. The ___ indicates the name of each relationship and all of its columns and attributes.
- Relational Instance
- Relational Keys
- Relational Schema
- Relational Database
Answer: C) Relational Schema
Explanation:
The relational schema indicates the name of each relationship and all of its columns and attributes.
Discuss this Question
9. What is TRUE about Relational Keys?
- There are one or more attributes in each row of the relational key.
- A unique ID can be assigned to each row in the relation.
- Both A. and B.
- None of the above
Answer: C) Both A. and B.
Explanation:
In case of Relational Keys -
- There are one or more attributes in each row of the relational key.
- A unique ID can be assigned to each row in the relation.
Discuss this Question
10. How many properties of relations are there?
- 4
- 5
- 6
- 7
Answer: C) 6
Explanation:
There are 6 properties of relations.
- = is reflexive (2=2)
- = is symmetric (x=2 implies 2=x)
- < is transitive (2<3 and 3<5 implies 2<5)
- < is irreflexive (2<3 implies 2≠3)
- ≤ is antisymmetric (x≤y and y≤x implies x=y)
Discuss this Question
11. Which of the following is/are the property/properties of the relations?
- Unlike all other relations, the relation has a unique name.
- An atomic (single) value resides in each relation cell
- There are distinct names for each attribute
- All of the above
Answer: D) All of the above
Explanation:
The following are the properties of the relations -
- Unlike all other relations, the relation has a unique name.
- An atomic (single) value resides in each relation cell.
- There are distinct names for each attribute.
Discuss this Question
12. Which of the following is FALSE about the properties of relations?
- There is no significance to attribute domains
- Duplicate values are present in the tuple
- Tuples can be ordered in any order
- None of the above
Answer: B) Duplicate values are present in the tuple
Explanation:
Duplicate values are not present in the tuple.
Discuss this Question