Data and Data types
1. What is the primary characteristic of quantitative data?
a) It is descriptive and conceptual.
b) It is non-numerical and text-based.
c) It is numerical and measurable.
d) It is based on personal opinions.
2. Interview transcripts, audio recordings, and open-ended survey responses are classic
examples of:
a) Quantitative Data
b) Qualitative Data
c) Structured Data
d) Meta Data
3. A database table with defined rows and columns (e.g., an Excel spreadsheet or SQL database)
is an example of:
a) Unstructured Data
b) Semi-structured Data
c) Structured Data
d) Qualitative Data
4. Which of the following is a key challenge of unstructured data?
a) It is easy to store in traditional databases.
b) It lacks a pre-defined data model, making it difficult to analyze.
c) It can only be represented by numbers.
d) It is always smaller in volume than structured data.
5. JSON and XML are popular formats used to represent what kind of data?
a) Structured Data
b) Unstructured Data
c) Semi-structured Data
d) Quantitative Data
6. The number of customers who purchased a product last month is an example of:
a) Qualitative Data
b) Unstructured Data
c) Quantitative Data
d) Categorical Data
7. A collection of social media posts (like tweets or Facebook updates) is typically considered:
a) Structured Data
b) Semi-structured Data
c) Unstructured Data
d) Quantitative Data
8. Which type of data is often used to understand underlying reasons, opinions, and
motivations?
a) Quantitative Data
b) Structured Data
c) Qualitative Data
d) Binary Data
9. Data that has a defined length and format, such as dates, addresses, or credit card numbers,
is known as:
a) Unstructured Data
b) Semi-structured Data
c) Structured Data
d) Qualitative Data
10. An email is a common example of which data type? (It has structured elements like
sender/recipient but unstructured content.)
a) Purely Structured Data
b) Purely Unstructured Data
c) Semi-structured Data
d) Quantitative Data
11. The term "Big Data" often refers to the large volume of both structured and unstructured
data. Which type makes up the majority of today's data?
a) Structured Data
b) Semi-structured Data
c) Unstructured Data
d) Quantitative Data
12. Which of the following is NOT an example of quantitative data?
a) Patient's body temperature (38.5°C)
b) Customer satisfaction rating on a scale of 1-10
c) A doctor's written notes on a patient's symptoms
d) Annual revenue of a company
13. A digital photograph is an example of:
a) Structured Data
b) Semi-structured Data
c) Unstructured Data
d) Quantitative Data
14. What is the main advantage of semi-structured data over unstructured data?
a) It is always smaller in size.
b) It contains tags or markers that separate semantic elements and enforce hierarchies.
c) It is easier to create and requires no planning.
d) It can only be analyzed using simple statistical tools.
15. Which field would most likely rely heavily on qualitative data?
a) Astrophysics
b) Accounting
c) Anthropology
d) Physics
16. A CSV (Comma-Separated Values) file is a standard format for:
a) Unstructured Data
b) Semi-structured Data
c) Structured Data
d) Multimedia Data
17. The statement "75% of users prefer the new website design" is a conclusion derived from:
a) Qualitative Data Analysis
b) Quantitative Data Analysis
c) Unstructured Data Analysis
d) Anecdotal Evidence
18. Which data type is a NoSQL database like MongoDB particularly well-suited for?
a) Only highly structured, transactional data
b) Only unstructured video files
c) Semi-structured and unstructured data
d) None of the above
19. Customer reviews that include a 5-star rating (quantitative) and a text comment (qualitative)
are a prime example of:
a) Only Quantitative Data
b) Only Unstructured Data
c) A mix of data types within a single source
d) Irrelevant data
20. The primary purpose of categorizing data into structured, semi-structured, and unstructured
is to:
a) Determine its color code in a database.
b) Decide on the appropriate tools and methods for storage and analysis.
c) Assign a monetary value to it.
d) Reduce its overall size for storage.
21. Which of the following is a characteristic of qualitative data?
a) It is objective and statistical.
b) It is analyzed using mean, median, and mode.
c) It is subjective and interpretive.
d) It is always stored in a relational database.
22. A webpage's HTML code, which includes both structured tags and unstructured text, is an
example of:
a) Structured Data
b) Unstructured Data
c) Semi-structured Data
d) Numerical Data
23. What is a common method for analyzing qualitative data?
a) Calculating standard deviation
b) Running regression analysis
c) Thematic coding and content analysis
d) Creating pivot tables
24. Sensor data from an IoT device that is emitted in a key-value pair format is typically:
a) Unstructured Data
b) Semi-structured Data
c) Structured Data
d) Qualitative Data
25. The statement "The user interface feels cluttered and unintuitive" is an example of:
a) Quantitative Data
b) Structured Data
c) Qualitative Data
d) Meta Data
Database
1. What is the core organizing structure of a Relational Database?
a) Documents
b) Key-Value Pairs
c) Tables with rows and columns
d) Nodes and Edges
2. Which language is most commonly used to query and manage data in a relational database?
a) Python
b) Java
c) SQL
d) C++
3. Non-relational databases are often referred to as:
a) RDBMS
b) NoSQL
c) SQL Databases
d) Flat Files
4. Which of the following is a key principle of relational databases that ensures data accuracy
and validity?
a) Scalability
b) ACID Compliance (Atomicity, Consistency, Isolation, Durability)
c) Schema Flexibility
d) High Availability
5. A database designed to store data in a JSON-like format with dynamic schemas is known as a:
a) Graph Database
b) Document Database
c) Wide-Column Store
d) Key-Value Store
6. Which type of non-relational database is ideal for storing session information, user profiles, or
shopping cart data?
a) Document Database
b) Graph Database
c) Key-Value Store (e.g., Redis)
d) Wide-Column Store
7. For which use case would a Graph Database be the most suitable choice?
a) Storing financial transaction records that require absolute consistency.
b) Modeling and querying complex relationships, like social networks or fraud detection.
c) Storing massive volumes of simple, unrelated data points.
d) Hosting a blog's content management system.
8. What is the main advantage of non-relational databases when dealing with large, distributed
systems?
a) Strong referential integrity with foreign keys.
b) Horizontal scalability and schema flexibility.
c) Complex join operations across tables.
d) Strict adherence to ACID properties.
9. In a relational database, a unique identifier for a row in a table is called a:
a) Foreign Key
b) Primary Key
c) Document ID
d) Column Key
10. Which non-relational database type is optimized for queries over large datasets and stores
data in columns rather than rows?
a) Key-Value Store
b) Document Database
c) Wide-Column Store (e.g., Cassandra, HBase)
d) Graph Database
11. The predefined blueprint of a database, including tables, columns, data types, and
relationships, is called the:
a) Data
b) Schema
c) Instance
d) Map
12. Which of the following is a characteristic of many non-relational databases?
a) They require a fixed, rigid schema before writing data.
b) They are built around the concept of tables and relations.
c) They often sacrifice strong consistency for scalability and performance (adhering to the CAP
theorem).
d) They are inefficient at handling large volumes of data.
13. Amazon DynamoDB is an example of what type of database?
a) A traditional relational database
b) A graph database
c) A key-value and document database
d) A wide-column store
14. What is a primary challenge of relational databases in modern web-scale applications?
a) Lack of a standard query language.
b) Difficulty in scaling horizontally across multiple servers.
c) Inability to represent complex data.
d) Poor performance for simple read operations.
15. The property that ensures all operations in a transaction are completed successfully, or none
are, is called:
a) Consistency
b) Isolation
c) Durability
d) Atomicity
16. Which type of database would be the best fit for an application that requires complex
transactions (e.g., a banking system)?
a) A Key-Value Store
b) A Document Database
c) A Relational Database
d) A Graph Database
17. MongoDB is a popular example of which type of database?
a) Relational
b) Key-Value
c) Document
d) Graph
18. In a relational database, a link between two tables, often using a primary key and foreign
key, is called a:
a) Join
b) Relationship
c) Constraint
d) Schema
19. The CAP theorem states that a distributed system cannot simultaneously provide more than
two of which three guarantees?
a) Atomicity, Consistency, Integrity, Durability
b) Consistency, Availability, Partition Tolerance
c) Scaling, Agility, Performance
d) Concurrency, Availability, Persistence
20. Which statement is true regarding schema in non-relational databases?
a) They require a rigid, predefined schema like relational databases.
b) They are completely schemaless and have no structure.
c) They often have a flexible schema that can evolve with the application.
d) They cannot enforce any data structure.
21. What is the primary purpose of a foreign key in a relational database?
a) To uniquely identify a record within its own table.
b) To create a link and enforce referential integrity between two tables.
c) To encrypt data for security.
d) To index every column in a table for faster search.
22. For a project involving real-time analytics on massive, rapidly incoming data streams (e.g.,
from IoT sensors), which database type is often preferred?
a) A traditional on-premise relational database
b) A non-relational database designed for horizontal scale and write performance
c) A graph database
d) A single-server key-value store
23. Neo4j is a leading example of what type of database?
a) Relational
b) Document
c) Graph
d) Wide-Column
24. The "One-to-Many" relationship is a concept most directly associated with:
a) Key-Value Stores
b) Relational Data Modeling
c) Document Database's embedded documents
d) Both B and C
25. When would you most likely choose a relational database over a non-relational one?
a) Your data is unstructured and changing rapidly.
b) Your application requires complex transactions and strong data consistency.
c) You need to scale horizontally across thousands of servers.
d) Your data model is a simple list of key-value pairs.