Database Systems Quiz2

What is the primary function of a relational database?

• Data visualization and reporting

• Data transmission and communication

• Data storage in unstructured format

• Data retrieval and manipulation

What is the formal term for a collection of related data points typically represented in rows and columns?

• Value Set

• Record

• Entity

• Attribute

Which property of relational tables ensures that each cell holds a single, indivisible value?

• Uniqueness of Rows

• Column Order Irrelevance

• Data Type Consistency

• Atomicity

What is the purpose of a Unique Key constraint in SQL?

• Matches the primary key of another table

• Ensures unique values within a column

• Combines two or more attributes to uniquely identify a record

• Prevents actions that would destroy links between tables

What is the main function of Data Control Language (DCL) in relational databases?

• Granular Permissions

• Role-Based Management

• Procedural Controls

• Auditing and Monitoring

Which clause in SQL is used to restrict retrieved data based on user-defined conditions?

• GROUP BY

• HAVING

• ORDER BY

• WHERE

What is the primary focus of Database Query Languages (DQLs)?

• Data visualization and reporting

• Data transmission and communication

• Data storage in unstructured format

• Data retrieval and manipulation

What is the main difference between DQL and SQL?

• DQL is a subset of SQL that deals with data retrieval

• DQL is used for data manipulation, while SQL is used for data retrieval

• DQL is declarative in nature, while SQL is imperative

• DQL is used for relational databases, while SQL is used for non-relational databases

What is the benefit of Declarative Nature in DQL?

• Rich set of operators and clauses

• Shared ideas like SELECT and WHERE

• Efficient optimization and clearer queries

• Portability and easier learning across platforms

In which field would DQL be used to generate visualizations and insights?

• Content Management Systems (CMS)

• Web Development

• Business Intelligence & Reporting

• Data Analysis & Research