Home »
MCQs »
DBMS MCQs
DBMS Databases & Types Multiple-Choice Questions (MCQs) and Answers | Set 2
DBMS Databases & Types MCQs (Set 2): This section contains DBMS Databases & Types Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on December 06, 2021
1. For large sets of ______ data, NoSQL databases are useful.
- Constructed
- Constructive
- Destructive
- Distributed
Answer: D) Distributed
Explanation:
For large sets of distributed data, NoSQL databases are useful.
Discuss this Question
2. Which of the following is Document-based example of NoSQL database system?
- HBase
- Redis
- Cloudant
- Accumulo
Answer: C) Cloudant
Explanation:
The document-based example of NoSQL database system is Cloudant.
Discuss this Question
3. Which of the following is key-value store NoSQL database system?
- HBase
- MongoDB
- Redis
- Accumulo
Answer: C) Redis
Explanation:
Redis is key-value store NoSQL database system. Alongwith Redis, other key-value store NoSQL database system are Memcached and Coherence.
Discuss this Question
4. What is an advantage of NoSQL?
- Open Source
- Backup
- High Scalability
- GUI is not available
Answer: C) High Scalability
Explanation:
There are 2 advantages of NoSQL – High Scalability and High Availability.
Discuss this Question
5. What is/are the disadvantage(s) of NoSQL?
- Open Source
- GUI is not available
- Backup
- All of the above
Answer: D) All of the above
Explanation:
There are 4 disadvantages of NoSQL –
- Open Source
- GUI is not available
- Backup
- Management Challenge
Discuss this Question
6. In the event of any failure, auto-_____ restores the database to its previous consistent state.
- Indentation
- Replication
- Enhancement
- Storage
Answer: B) Replication
Explanation:
In the event of any failure, auto-replication restores the database to its previous consistent state.
Discuss this Question
7. Object-oriented database is an alternative implementation of ______model.
- Logical
- Cross
- Relational
- Linear
Answer: C) Relational
Explanation:
Object-oriented database is an alternative implementation of Relational model.
Discuss this Question
8. Which among the following is a property of Object-oriented programming?
- Atomicity
- Objects
- Durability
- Concurrency
Answer: B) Objects
Explanation:
Objects is a property of Object-oriented programming.
Discuss this Question
9. Which among the following is a property of Relational Model?
- Classes
- Inheritance
- Query Processing
- Encapsulation
Answer: C) Query Processing
Explanation:
Query Processing is a property of Relational Model.
Discuss this Question
10. What is TRUE about DBMS?
- Database management systems (DBMS) provide interfaces that enable operations such as creation, deletion, and modification.
- The DBMS allows the user to design their databases according to their requirements.
- By using the operating system, DBMS provides the application with specific data.
- All of the above
Answer: D) All of the above
Explanation:
In DBMS –
- Database management systems (DBMS) provide interfaces that enable operations such as creation, deletion, and modification.
- The DBMS allows the user to design their databases according to their requirements.
- By using the operating system, DBMS provides the application with specific data.
Discuss this Question
11. Which of the following is an advantage of DBMS?
- Controls Redundancy
- Data Sharing
- Backup
- All of the above
Answer: D) All of the above
Explanation:
The advantages of DBMS are –
- Controls Redundancy
- Data Sharing
- Backup
- Multiple user interfaces
Discuss this Question
12. Which of the following is a disadvantage of DBMS?
- Low Cost
- High Cost
- Occupy less size
- Less complexity
Answer: B) High Cost
Explanation:
High Cost is a disadvantage of DBMS.
Discuss this Question
13. What is the full form of RDBMS?
- Rotational Database Management System
- Relational Database Management System
- Retention Database Management System
- Replication Database Management System
Answer: B) Relational Database Management System
Explanation:
The full form of RDBMS is Relational Database Management System.
Discuss this Question
14. Which of the following component is NOT present in Relational Database?
- Instance
- Schema
- Keys
- None of the above
Answer: D) None of the above
Explanation:
The following components are present in Relational Database –
- Table
- Record
- Field
- Instance
- Schema
- Keys
Discuss this Question
15. Graph Database is a ____ Database.
- SQL
- NoSQL
- SQL & NoSQL
- None of the above
Answer: B) NoSQL
Explanation:
Graph Database is a NoSQL Database.
Discuss this Question
16. Which of the following is present in Graph Database?
- Node
- Edge
- Both A. and B.
- None of the above
Answer: C) Both A. and B.
Explanation:
Graph Database contains Nodes and Edges.
Discuss this Question
17. ______ represent entities, and _____ represent relationships between edges.
- Edges, Nodes
- Nodes, Relations
- Relations, Nodes
- Nodes, Edges
Answer: D) Nodes, Edges
Explanation:
Nodes represent entities, and edges represent relationships between edges.
Discuss this Question
18. Graph databases contain nodes that represent unique _____.
- Identities
- Information
- Inference
- Identifier
Answer: D) Identifier
Explanation:
Graph databases contain nodes that represent unique identifiers.
Discuss this Question
19. Field in Relational Database can also be termed as –
- Column name
- Attribute
- Both A. and B.
- None of the above
Answer: C) Both A. and B.
Explanation:
Field in Relational Database can also be termed as Column name and Attribute.
Discuss this Question
20. Record is also known as –
- Column
- Tuple
- Schema
- Key
Answer: B) Tuple
Explanation:
Record is also known as Tuple.
Discuss this Question