Free Test Basic SQL Queries – Databas...

Q1: Which SQL statement is used to retrieve data from a database?

A. SELECT B. INSERT C. UPDATE D. DELETE

Q2: Which clause is used to filter records in SQL?

A. WHERE B. GROUP BY C. ORDER BY D. HAVING

Q3: Which operator is used to search for a specified pattern in a column?

A. LIKE B. IN C. BETWEEN D. IS NULL

Q4: Which keyword is used to sort the result set?

A. ORDER BY B. GROUP BY C. WHERE D. HAVING

Q5: How do you select all columns from a table named Students?

A. SELECT * FROM Students B. SELECT ALL FROM Students C. SELECT ALL COLUMNS FROM Students D. SELECT COLUMNS FROM Students

Q6: Which SQL keyword is used to retrieve unique records?

A. DISTINCT B. UNIQUE C. PRIMARY D. UNION

Q7: Which clause groups rows sharing a property?

A. GROUP BY B. ORDER BY C. WHERE D. HAVING

Q8: Which clause filters groups after aggregation?

A. HAVING B. WHERE C. GROUP BY D. ORDER BY

Q9: How do you select the top 5 records from a table in SQL Server?

A. SELECT TOP 5 * FROM table_name B. SELECT FIRST 5 * FROM table_name C. SELECT LIMIT 5 * FROM table_name D. SELECT * FROM table_name WHERE ROWNUM <= 5

Q10: What is the function of the COUNT() aggregate function?

A. Counts number of rows B. Sums column values C. Finds maximum value D. Finds minimum value

Q11: Which SQL operator checks if a value is within a list?

A. IN B. LIKE C. BETWEEN D. EXISTS

Q12: Which operator selects values within a range?

A. BETWEEN B. IN C. LIKE D. EXISTS

Q13: How do you rename a column in the result set?

A. SELECT column_name AS alias_name B. SELECT column_name RENAME alias_name C. SELECT column_name TO alias_name D. SELECT alias_name FROM column_name

Q14: Which statement is used to update existing data in a table?

A. UPDATE B. INSERT C. MODIFY D. CHANGE

Q15: How do you delete all records from a table?

A. DELETE FROM table_name B. DROP TABLE table_name C. TRUNCATE TABLE table_name D. REMOVE FROM table_name

Q16: Which command deletes the table structure and data?

A. DROP TABLE B. DELETE FROM C. TRUNCATE TABLE D. REMOVE TABLE

Q17: How do you add a new column to an existing table?

A. ALTER TABLE table_name ADD column_name datatype B. ADD COLUMN column_name TO table_name C. INSERT COLUMN column_name INTO table_name D. CREATE COLUMN column_name

Q18: Which clause is used to join two tables?

A. JOIN B. WHERE C. GROUP BY D. ORDER BY

Q19: What type of JOIN returns all rows from the left table and matching rows from the right table?

A. LEFT JOIN B. RIGHT JOIN C. INNER JOIN D. FULL JOIN

Q20: Which keyword is used to eliminate duplicate rows in the result?

A. DISTINCT B. UNIQUE C. UNION D. EXCEPT

Quiz for Basic SQL Queries