Set 1 Quiz

What is the primary key constraint used for?

• Foreign key

• Uniqueness

• Redundancy

• Index

Which SQL clause is used to filter records?

• WHERE

• SELECT

• GROUP BY

• ORDER BY

What type of database follows a table-based structure?

• NoSQL

• Document-based

• Relational

• Key-value

Which normal form eliminates partial dependencies?

• 1NF

• 2NF

• 3NF

• BCNF

What is the full form of ACID in databases?

• Atomicity, Consistency, Isolation, Durability

• Atomicity, Confidentiality, Integrity, Durability

• Access, Control, Integrity, Data

• Application, Configuration, Isolation, Database

Which SQL keyword is used to retrieve unique values?

• DELETE

• DISTINCT

• UNIQUE

• FILTER

Which JOIN returns only matching rows from both tables?

• OUTER JOIN

• LEFT JOIN

• INNER JOIN

• RIGHT JOIN

What is the default port number of MySQL?

• 8080

• 1433

• 5432

• 3306

What is the purpose of the HAVING clause?

• Filter aggregated data

• Sort records

• Group rows

• Select unique records

What does the GROUP BY clause do?

• Groups rows with common values

• Sorts records

• Deletes duplicates

• Filters data