SQL Basics Quiz

What does SQL stand for?

• Structured Query List

• Simple Query Language

• Structured Query Language

• Standard Query Language

Which SQL clause is used to filter records based on a specific condition?

• SELECT

• WHERE

• FILTER

• ORDER

Which SQL statement is used to insert a new record into a table?

• ADD

• INSERT INTO

• UPDATE

• NEW RECORD

Which SQL constraint ensures that all values in a column are unique?

• NOT NULL

• FOREIGN KEY

• UNIQUE

• DEFAULT

Which SQL command is used to delete all records from a table but keep its structure?

• DELETE

• DROP

• CLEAR

• TRUNCATE

Which SQL JOIN returns all records when there is at least one match in both tables?

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• INNER JOIN

Which of the following triggers is executed before inserting a new row?

• AFTER INSERT

• BEFORE INSERT

• AFTER UPDATE

• BEFORE DELETE

What will happen when a `BEFORE INSERT` trigger signals an error using `SIGNAL SQLSTATE`?

• The insert operation will be canceled

• The insert operation will continue with a warning

• The trigger will be ignored

• The trigger will be executed twice

Which SQL function removes extra spaces before and after a string?

• CONCAT()

• LENGTH()

• TRIM()

• SUBSTRING()

Which of the following SQL statements is correct for creating a database?

• CREATE NEW DATABASE my_db;

• NEW DATABASE my_db;

• CREATE DATABASE my_db;

• DATABASE CREATE my_db;