WorksheetsLecture-12
Total questions: 28
Worksheet time: 14mins
What is the primary purpose of databases?
To create software applications
To organize data into useful information
To manage hardware resources
To store unorganized data
What type of data is numerical and measurable?
Continuous data
Discrete data
Quantitative data
Qualitative data
Which of the following is an example of qualitative data?
Temperature readings
Customer satisfaction ratings
Sales figures
Height measurements
What does a Database Management System (DBMS) do?
Only retrieves data
Facilitates the creation and management of databases
Eliminates the need for data security
Stores data only
Which of the following is a feature of relational databases?
Data stored in key-value pairs
Structured data in tables
Schema-less design
No support for complex queries
What is the main function of SQL in relational databases?
To define the database structure
To manage hardware resources
To create user interfaces
To store unstructured data
What type of data can NoSQL databases handle effectively?
Only structured data
Only unstructured data
Only numerical data
Both structured and unstructured data
Which of the following is NOT a type of NoSQL database?
Document-oriented
Graph
Relational
Key-value
What is a primary key in a relational database?
A key that allows duplicate values
A unique identifier for each record
A key that links two tables
A key used for data encryption
What is the main advantage of using a DBMS?
Increased data redundancy
Improved data integrity
Higher costs
Limited user access
Which of the following describes unstructured data?
Data that is easy to analyze
Data that is always numerical
Data with a predefined format
Data without a specific structure
What is the purpose of data integrity constraints in a database?
To increase data redundancy
To simplify data retrieval
To ensure accuracy and consistency of data
To allow any type of data
Which of the following is an example of a relational database?
MongoDB
Redis
Cassandra
MySQL
What does the term 'dark data' refer to?
Data that is actively used
Data that is stored but not utilized
Data that is encrypted
Data that is deleted
What is the main characteristic of NoSQL databases?
Flexibility in data structure
Strict schema requirements
Limited scalability
Use of SQL for queries
Which of the following is a disadvantage of using a DBMS?
Concurrent access
Data organization
Data integrity
Complexity in setup and maintenance
What is the role of a foreign key in a relational database?
To establish relationships between tables
To uniquely identify a record
To encrypt data
To store unstructured data
What type of data is typically stored in JSON format?
Unstructured data
Structured data
Semi-structured data
All of the above
Which of the following is a key feature of graph databases?
Data stored in tables
Schema-less design
Focus on relationships between data points
Use of SQL for queries
What is the main purpose of data modeling in a DBMS?
To store data securely
To create user interfaces
To define the structure and relationships of data
To manage hardware resources
Which of the following best describes semi-structured data?
Data that is only numerical
Data that has some organizational properties
Data that is completely unorganized
Data with a fixed schema
What is the primary function of a data control language (DCL)?
To create reports
To manipulate data
To manage data access and permissions
To define database structure
What is a common use case for NoSQL databases?
Handling structured data
Real-time analytics
Data warehousing
Transactional processing
What does ACID stand for in the context of databases?
Atomicity, Consistency, Isolation, Durability
Access, Control, Integrity, Data
Atomicity, Control, Integrity, Durability
Analysis, Consistency, Isolation, Data
Which of the following is a characteristic of structured data?
Lacks a predefined format
Difficult to store
Always unmeasurable
Easy to analyze using SQL
What is the main advantage of using relational databases for data management?
High performance for all types of data
Ease of use for unstructured data
Strong consistency and integrity
Flexibility in data structure
What is the primary purpose of a database?
To create software applications
To organize data for easy access and management
To store data in a random format
To eliminate the need for data analysis
Which of the following is a common application of DBMS?
Social media analysis
Creating web pages
Data encryption
Managing student records
