Free Mock Test : SQL : SQL Clause (Test 1)

Home

Technology

Blog

Free Mock Test - SQL : SQL Clause (Test 1)

In recent years, SQL (Structured Query Language) has emerged as one of the most important subjects in competitive examinations related to Information Technology, Computer Science, Banking IT, and government technical recruitment. Experts believe that the increasing dependence on data management systems has made SQL knowledge essential for students and job aspirants.
Educational institutions and coaching centers across India are now giving special attention to SQL preparation. Questions related to database creation, data retrieval, joins, normalization, primary keys, foreign keys, and SQL queries are frequently appearing in exams such as SSC Scientific Assistant, Banking IT Officer, NIELIT, Railway technical posts, and various state-level computer operator examinations.
According to academic professionals, SQL is considered a scoring subject because most questions are logic-based and directly related to database operations. Candidates who practice SQL commands regularly can solve examination questions quickly and accurately.

Total Questions : 30

Timer : sec

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

ORDER BY

WHERE

GROUP BY

HAVING

Question : Which operator is used to combine multiple conditions where all conditions must be true?

NOT

AND

BETWEEN

Question : Which operator returns records if at least one condition is true?

AND

NOT

Question : Which clause is used with aggregate functions to filter grouped data?

WHERE

ORDER BY

HAVING

DISTINCT

Question : Which keyword is used to create a temporary result set in SQL?

WITH

HAVING

DISTINCT

Question : What is the purpose of the AS keyword?

Create table

Rename column/table temporarily

Delete rows

Sort data

Question : Which query correctly uses the WHERE clause?

SELECT FROM Student WHERE Marks>50;

SELECT * Student WHERE Marks>50;

SELECT * FROM Student WHERE Marks>50;

SELECT Student FROM * WHERE Marks>50;

Question : What will the following query return?

SELECT * FROM Product
WHERE Price > 100 AND Quantity > 10;

Products with either condition true

Products with both conditions true

All products

Syntax error

Question : Which clause cannot be used without GROUP BY?

ORDER BY

HAVING

WHERE

DISTINCT

Question : Which SQL statement uses OR correctly?

SELECT * FROM Student WHERE City='Patna' OR Age>20;

SELECT * Student OR Age>20;

SELECT FROM Student OR Age>20;

SELECT OR FROM Student;

Question : Which clause executes before HAVING?

ORDER BY

GROUP BY

SELECT

DISTINCT

Question : Which keyword is used for column aliasing?

WITH

HAVING

WHERE

Question : What is the output of:

SELECT COUNT(*) AS Total
FROM Employee;

Counts rows

Deletes rows

Sorts rows

Creates table

Question : Which clause filters rows before grouping?

HAVING

GROUP BY

WHERE

Question : Which clause filters groups after grouping?

WHERE

HAVING

DISTINCT

FROM

Question : Which query finds employees from HR department earning more than 40000?

SELECT * FROM Employee
WHERE Department='HR' AND Salary>40000;

SELECT * FROM Employee
WHERE Department='HR' OR Salary>40000;

SELECT Department AND Salary FROM Employee;

SELECT Employee WHERE Salary>40000;

Question : Which statement about WITH clause is true?

Creates permanent table

Creates temporary result set

Deletes data

Updates records

Question : Which query uses HAVING correctly?

SELECT Department, AVG(Salary)
FROM Employee
GROUP BY Department
HAVING AVG(Salary)>50000;

SELECT HAVING Salary>50000;

HAVING SELECT Salary;

GROUP Salary HAVING;

Question : Which operator has higher priority?

AND

Both equal

NOT

Question : Which keyword gives a temporary name to a table?

DISTINCT

WHERE

GROUP

Question : What does the following query do?

SELECT * FROM Student
WHERE NOT Age = 18;

Selects students aged 18

Selects students not aged 18

Deletes students

Syntax error

Question : Which clause is used with aggregate functions?

HAVING

DISTINCT

WHERE only

Question : Which query uses Common Table Expression (CTE) correctly?

WITH Temp AS (
SELECT * FROM Employee
)
SELECT * FROM Temp;

AS Temp SELECT Employee;

WITH Employee;

SELECT WITH Employee;

Question : Which keyword is optional while aliasing columns in many databases?

WITH

WHERE

HAVING

Question : Which query returns employees from IT or Finance?

SELECT * FROM Employee
WHERE Department='IT' OR Department='Finance';

SELECT Employee IT Finance;

SELECT OR Department;

SELECT * OR Finance;

Question : What is wrong in the query?

SELECT Department, COUNT(*)
FROM Employee
HAVING COUNT(*)>2;

COUNT cannot be used

HAVING used without GROUP BY

SELECT missing

Syntax is perfect

Question : Which clause can contain aggregate functions directly?

WHERE

HAVING

FROM

DISTINCT

Question : Which condition is evaluated first?

WHERE Marks>80 OR Grade='A' AND Age<20

OR condition

AND condition

Both together

Age only

Question : Which query gives alias to a table?

SELECT * FROM Employee AS E;

SELECT AS Employee;

FROM Employee WHERE AS;

SELECT Employee Alias;

Question : Which statement is true about WHERE and HAVING?

Both are identical

WHERE filters rows, HAVING filters groups

HAVING filters rows only

WHERE works after GROUP BY

About us

Term & conditions

Privacy & Policy

Free Mock Test - SQL : SQL Clause (Test 1)

Cookies & Disclaimer