Lecture-12

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