SQL and Database Concepts Quiz

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• System Query Language

• Standard Query Language

Which SQL clause is used to retrieve data from a database?

• INSERT

• SELECT

• UPDATE

• DELETE

In an ER diagram, what does a rectangle represent?

• Attribute

• Relationship

• Entity

• Key

What is the main purpose of a primary key in a table?

• To allow duplicates

• To uniquely identify a record

• To establish a connection between tables

• To store unstructured data

Which of the following is NOT a type of database relationship?

• One-to-One

• Many-to-Many

• One-to-Many

• All-to-All

What is the first step in database normalization?

• Removing transitive dependencies

• Ensuring atomicity

• Eliminating partial dependencies

• Creating a foreign key

Which SQL keyword is used to modify an existing table?

• ALTER

• MODIFY

• CHANGE

• UPDATE

Which of these tools is used for visualizing ER diagrams?

• Lucidchart

• AutoCAD

• Photoshop

• MS Word

What is the role of a foreign key in a database?

• To delete duplicate records

• To uniquely identify records

• To establish a link between two tables

• To normalize the database

Which data type is best for storing text of varying lengths in SQL?

• CHAR

• VARCHAR

• TEXT

• STRING