Home »
MCQs »
DBMS MCQs
DBMS Data Models Multiple-Choice Questions (MCQs) and Answers
DBMS Data Models MCQs: This section contains DBMS Data Models Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on December 23, 2021
1. ____ Data refers to describing the data description, representing data semantics, and describing the consistency constraints that apply to the data.
- Adding
- Modifying
- Modeling
- Refining
Answer: C) Modeling
Explanation:
Modeling data refers to describing the data description, representing data semantics, and describing the consistency constraints that apply to the data.
Discuss this Question
2. How many types of data models are there?
- 1
- 2
- 3
- 4
Answer: D) 4
Explanation:
There are four types of data models.
Discuss this Question
3. Which of the following is not the type of the data model?
- Relational Data Model
- Semi-structured data Model
- Entity-Relationship Model
- Process-based Data Model
Answer: D) Process-based Data Model
Explanation:
Process-based Data Model does not come under the type of data models.
Discuss this Question
4. What is statement explains the Relational Data Model?
- Within a table, rows and columns are used to arrange the data.
- As data, objects, and relationships among them are represented logically in this model.
- Functions, encapsulation, and object identity are also considered in addition to the ER model.
- These data models facilitate data specifications where different attributes are defined for the same data items of the same type.
Answer: A) Within a table, rows and columns are used to arrange the data
Explanation:
Within a table, rows and columns are used to arrange the data in the Relational Data Model.
Discuss this Question
5. What is TRUE about Relational Data Model?
- Tables are used in relational models to represent data and the relationships between them.
- Edgar F. Codd presented this model in 1969.
- Most commercial data processing applications use the relational data model.
- All of the above
Answer: D) All of the above
Explanation:
The following statements are TRUE about Relational Data Model –
- Tables are used in relational models to represent data and the relationships between them.
- Edgar F. Codd presented this model in 1969.
- Most commercial data processing applications use the relational data model.
Discuss this Question
6. As data objects and relationships among them are represented logically in an ______.
- Relational Data Model
- ER Model
- Object-based Model
- Semi-structured Data Model
Answer: B) ER Model
Explanation:
As data objects and relationships among them are represented logically in an ER model.
Discuss this Question
7. In an ER Model, what are objects also known as?
- Entity
- Relationship
- Bond
- Joint
Answer: D) Joint
Explanation:
In an ER Model, objects are also known as Entities.
Discuss this Question
8. _____ are collections of similar types of entities.
- Relationship Set
- Entity Set
- ER Set
- None of the above
Answer: B) Entity Set
Explanation:
'Entity sets' are collections of similar types of entities.
Discuss this Question
9. Which type of data model is an extension of ER Model?
- Relational Data Model
- Object-based Data Model
- Structured Data Model
- Semi-structured Data Model
Answer: B) Object-based Data Model
Explanation:
Object-based Data Model is an extension of ER Model.
Discuss this Question
10. What does object refer to in an Object-based data model?
- Data carrying its properties
- Objects carrying its properties
- Relations carrying its properties
- Models carrying its properties
Answer: A) Data carrying its properties
Explanation:
Objects in an Object-based data model refer to the data-carrying properties.
Discuss this Question
11. Data specifications can be specified when the same-type data items have different attributes, as in a ____ model.
- Relational Data Model
- Object-based Data Model
- ER Model
- Semi-structured Data Model
Answer: D) Semi-structured Data Model
Explanation:
Data specifications can be specified when the same-type data items have different attributes, as in a semi-structured model.
Discuss this Question
12. In many cases, semi-structured data is represented using _____.
- Extensible Markup Language
- Extension Markup Language
- Extra Markup Language
- Extract Markup Language
Answer: A) Extensible Markup Language
Explanation:
In many cases, semi-structured data is represented using Extensible Markup Language, or XML.
Discuss this Question
13. Instance and Schemas are part of the –
- Data Definition
- Data Manipulation
- Data Models
- Data Redundancy
Answer: C) Data Models
Explanation:
Instance and Schemas are part of the Data Models.
Discuss this Question
14. A/An __________ of a database is the data in it at a specific moment in time.
- Schema
- Instance
- Instant
- Scheme
Answer: B) Instance
Explanation:
An instance of a database is the data in it at a specific moment in time.
Discuss this Question
15. The ________ of a database describes its overall structure.
- Schema
- Instance
- Design
- Structure
Answer: A) Schema
Explanation:
The schema of a database describes its overall structure.
Discuss this Question
16. Data schemas represent the skeleton structure of a database. They represent the ___ of the database as a whole.
- Analytical View
- Logical View
- Semantic View
- Practical View
Answer: B) Logical View
Explanation:
Data schemas represent the skeleton structure of a database. They represent the logical view of the database as a whole.
Discuss this Question
17. What type of schema objects are there in schema?
- Primary Key
- Foreign Key
- Views
- All of the above
Answer: D) All of the above
Explanation:
The types of schema objects present in the schema are primary key, foreign key, views, columns, data types, table & stored procedure, etc.
Discuss this Question
18. What is the process of database creation known as?
- Data Creation
- Data Processing
- Data Modelling
- Data Defining
Answer: C) Data Modelling
Explanation:
Data Modelling is the term given to the process of database creation.
Discuss this Question
19. Which aspect of schema can be displayed in schema diagram?
- Record Type
- Data Type
- Constraints
- All of the above
Answer: D) All of the above
Explanation:
The aspects of schema that can be displayed in the schema diagram are record type, data type, and constraints.
Discuss this Question
20. ____ are designed by database designers to facilitate communications between the database and the software.
- Database Instances
- Database Schemas
- Database Roles
- Database Structure
Answer: B) Database Schemas
Explanation:
Database schemas are designed by database designers to facilitate communications between the database and the software.
Discuss this Question
21. _____ diagrams can be used to represent database schemas.
- Visual
- Logical
- Analytical
- Structural
Answer: A) Visual
Explanation:
Visual diagrams can be used to represent database schemas.
Discuss this Question
22. Objects and relationships between _____ are shown through the visual diagrams.
- Tables
- Rows
- Columns
- Databases
Answer: D) Databases
Explanation:
Objects and relationships between databases are shown through the visual diagrams.
Discuss this Question