Which of the following is a characteristic of a relational database?
a) Stores data in tables with rows and columns
b) Organizes data in a tree-like structure
c) Data is stored in key-value pairs
d) Uses document-oriented storage
What type of database is designed to store data in a hierarchical model with parent-child relationships?
a) Relational database
b) NoSQL database
c) Hierarchical database
d) Graph database
Which type of database is best suited for handling large-scale, unstructured data?
a) Relational database
b) NoSQL database
c) Hierarchical database
d) Object-oriented database
What is a key feature of NoSQL databases?
a) They use structured query language (SQL) for querying
b) They store data in a non-tabular format
c) They only support relational data models
d) They are strictly ACID compliant
Which of the following is a common example of a relational database management system (RDBMS)?
a) MongoDB
b) MySQL
c) Neo4j
d) Cassandra
Which type of database stores data as key-value pairs?
a) Relational database
b) NoSQL database
c) Hierarchical database
d) Network database
What is a primary advantage of a NoSQL database over a relational database?
a) Easier to scale horizontally
b) Stores data in tables with rows and columns
c) Requires less disk space
d) Uses a fixed schema
Which type of database is ideal for applications requiring real-time processing of large amounts of unstructured data?
a) Relational database
b) NoSQL database
c) Graph database
d) Hierarchical database
Which of the following is an example of a NoSQL database?
a) SQL Server
b) Oracle
c) MongoDB
d) PostgreSQL
What is the main characteristic of a hierarchical database?
a) Data is stored in rows and columns
b) Data is stored in a tree-like structure
c) Data is stored in key-value pairs
d) Data is stored in a graph format
Which of the following is a disadvantage of using a hierarchical database?
a) Difficulty in handling many-to-many relationships
b) It is highly flexible and scalable
c) Easy to scale horizontally
d) Supports complex queries
Which type of database would be best suited for an e-commerce website storing user data, product catalog, and orders?
a) Relational database
b) NoSQL database
c) Hierarchical database
d) Object-oriented database
Which of the following is true about NoSQL databases?
a) They are not scalable
b) They use a fixed schema
c) They are ideal for handling unstructured data
d) They only support relational data models
What is the purpose of an index in a relational database?
a) To speed up data retrieval
b) To enforce data consistency
c) To store data in a tree structure
d) To store data in key-value pairs
Which of the following best describes a document-based NoSQL database?
a) Stores data in a tree-like structure
b) Uses tables with rows and columns
c) Stores data in documents, typically in JSON format
d) Uses key-value pairs for storage
Which of the following is a common use case for a NoSQL database?
a) Transaction processing systems
b) Small business inventory management
c) Social media platforms
d) Banking systems
Which type of database supports ACID properties and is used for transaction-based applications?
a) NoSQL database
b) Relational database
c) Hierarchical database
d) Object-oriented database
Which of the following is an example of a graph database?
a) MongoDB
b) Neo4j
c) MySQL
d) Cassandra
Which of the following NoSQL databases is designed to store large volumes of data across many servers and is ideal for horizontal scaling?
a) Redis
b) MongoDB
c) Cassandra
d) PostgreSQL
What is the main advantage of using a NoSQL database in modern web applications?
a) Better support for real-time analytics
b) Easier to implement ACID properties
c) More structured data storage
d) More rigid data schema
Which of the following is a drawback of relational databases compared to NoSQL databases?
a) Lack of flexibility in schema
b) Better performance for complex queries
c) Easier scalability
d) Faster processing of large amounts of unstructured data
What kind of data is best stored in a NoSQL key-value store?
a) Structured data with complex relationships
b) Unstructured data such as documents
c) Simple data that can be uniquely identified by a key
d) Large datasets requiring complex queries
Which of the following database types is best suited for handling complex relationships in data?
a) Hierarchical database
b) Relational database
c) NoSQL database
d) Graph database
Which of the following is an example of a key-value NoSQL database?
a) MongoDB
b) Redis
c) Neo4j
d) PostgreSQL
Which of the following is not a characteristic of a relational database?
a) Supports table relationships
b) Uses SQL for querying
c) Requires schema definition before data insertion
d) Stores data in key-value pairs
What is the main advantage of using a graph database over a relational database?
a) It can store large amounts of unstructured data
b) It is better suited for handling many-to-many relationships
c) It does not require a schema
d) It supports complex SQL queries
Which type of NoSQL database is designed to store and manage time-series data?
a) Document-based NoSQL
b) Key-value store
c) Column-family store
d) Time-series database
What does “eventual consistency” mean in the context of NoSQL databases?
a) Data consistency is guaranteed immediately after a write operation
b) Data will become consistent over time, even if it is temporarily inconsistent
c) Data is never consistent
d) The database never experiences downtime
