What does SQL stand for? Structured Query List Simple Query Language Structured Query Language System Query Language

Which SQL command is used to retrieve data from a database? GET SELECT RETRIEVE FETCH

Which of the following is NOT a valid SQL constraint? PRIMARY KEY FOREIGN KEY INDEX CHECK

What will happen if a WHERE clause is omitted in an UPDATE statement? Only the first row will be updated The update will not execute All rows will be updated SQL will return an error

What is the purpose of the HAVING clause? Filters results after aggregation Filters results before aggregation Groups results Deletes duplicate rows

Which SQL statement is used to remove a table permanently? DELETE REMOVE DROP ERASE

Which SQL function counts the number of rows in a table? SUM() COUNT() NUMBER() TOTAL()

What is the default sorting order of the ORDER BY clause? ASC DESC RANDOM NONE

Which SQL clause is used to filter rows before grouping? WHERE GROUP BY HAVING ORDER BY

What does the SQL INNER JOIN do? Returns only the matching rows from both tables Returns all rows from both tables Returns matching rows from one table only Returns all rows from the first table only

How do you select all columns from a table named Employees? SELECT ALL FROM Employees; SELECT * FROM Employees; SELECT ALL COLUMNS FROM Employees; GET * FROM Employees;

What will the following query return? SELECT COUNT(*) FROM Employees WHERE Salary > 50000; The total salary amount of employees earning over 50,000 The number of employees earning over 50,000 All employees with a salary above 50,000 AN ERROR

Which SQL statement is used to insert new data into a table? INSERT UPDATE ADD UPDATE

Which SQL clause removes duplicate values from a result set? DISTINCT UNIQUE REMOVE DUPLICATES CLEAN

What type of join returns all rows from both tables when there is a match, plus unmatched rows from both? INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN

Which of these SQL commands is used to change existing data in a table? UPDATE MODIFY CHANGE EDIT

What does the GROUP BY clause do? Sorts records Filters records Groups records by a specific column Removes duplicates

What is the difference between DELETE and TRUNCATE? DELETE removes all rows, TRUNCATE removes some rows DELETE is faster than TRUNCATE DELETE logs each row deletion, while TRUNCATE does not DELETE removes the table structure, TRUNCATE does not

Which SQL keyword is used to extract a portion of a result set? LIMIT PART SLICE EXTRACT

Which of the following best describes a PRIMARY KEY? A column that allows duplicate values A column that uniquely identifies each row A column that stores foreign key references A column used only for indexing