×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

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.

  1. Constructed
  2. Constructive
  3. Destructive
  4. 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?

  1. HBase
  2. Redis
  3. Cloudant
  4. 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?

  1. HBase
  2. MongoDB
  3. Redis
  4. 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?

  1. Open Source
  2. Backup
  3. High Scalability
  4. 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?

  1. Open Source
  2. GUI is not available
  3. Backup
  4. All of the above

Answer: D) All of the above

Explanation:

There are 4 disadvantages of NoSQL –

  1. Open Source
  2. GUI is not available
  3. Backup
  4. Management Challenge

Discuss this Question


6. In the event of any failure, auto-_____ restores the database to its previous consistent state.

  1. Indentation
  2. Replication
  3. Enhancement
  4. 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.

  1. Logical
  2. Cross
  3. Relational
  4. 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?

  1. Atomicity
  2. Objects
  3. Durability
  4. 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?

  1. Classes
  2. Inheritance
  3. Query Processing
  4. Encapsulation

Answer: C) Query Processing

Explanation:

Query Processing is a property of Relational Model.

Discuss this Question


10. What is TRUE about DBMS?

  1. Database management systems (DBMS) provide interfaces that enable operations such as creation, deletion, and modification.
  2. The DBMS allows the user to design their databases according to their requirements.
  3. By using the operating system, DBMS provides the application with specific data.
  4. All of the above

Answer: D) All of the above

Explanation:

In DBMS –

  1. Database management systems (DBMS) provide interfaces that enable operations such as creation, deletion, and modification.
  2. The DBMS allows the user to design their databases according to their requirements.
  3. 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?

  1. Controls Redundancy
  2. Data Sharing
  3. Backup
  4. All of the above

Answer: D) All of the above

Explanation:

The advantages of DBMS are –

  1. Controls Redundancy
  2. Data Sharing
  3. Backup
  4. Multiple user interfaces

Discuss this Question


12. Which of the following is a disadvantage of DBMS?

  1. Low Cost
  2. High Cost
  3. Occupy less size
  4. 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?

  1. Rotational Database Management System
  2. Relational Database Management System
  3. Retention Database Management System
  4. 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?

  1. Instance
  2. Schema
  3. Keys
  4. None of the above

Answer: D) None of the above

Explanation:

The following components are present in Relational Database –

  1. Table
  2. Record
  3. Field
  4. Instance
  5. Schema
  6. Keys

Discuss this Question


15. Graph Database is a ____ Database.

  1. SQL
  2. NoSQL
  3. SQL & NoSQL
  4. 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?

  1. Node
  2. Edge
  3. Both A. and B.
  4. 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.

  1. Edges, Nodes
  2. Nodes, Relations
  3. Relations, Nodes
  4. 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 _____.

  1. Identities
  2. Information
  3. Inference
  4. 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 –

  1. Column name
  2. Attribute
  3. Both A. and B.
  4. 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 –

  1. Column
  2. Tuple
  3. Schema
  4. Key

Answer: B) Tuple

Explanation:

Record is also known as Tuple.

Discuss this Question





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.