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

Home

Previous Year Question

Free Mock Test

Technology

Blog

Contact us

Free Mock Test - SQL : SQL Select(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 SQL statement is used to retrieve data from a database table?

GET

FETCH

SELECT

SHOW

Question : Which symbol is used to select all columns from a table?

%

#

*

ALL

Question : Which keyword removes duplicate values from the result?

UNIQUE

DISTINCT

DIFFERENT

REMOVE

Question : What is the output of the following query?

SELECT COUNT(*) FROM students;

Counts rows

Counts columns

Counts NULL values only

Counts distinct values only

Question : Which statement returns the first 5 rows in SQL Server?

ELECT FIRST 5 * FROM table;

SELECT TOP 5 * FROM table;

SELECT LIMIT 5 * FROM table;

SELECT ROWS 5 * FROM table;

Question : Which clause is commonly used in MySQL to fetch limited rows?

TOP

LIMIT

FIRST

FETCHONLY

Question : Which query selects unique department names?

A. SELECT department FROM emp;

B. SELECT UNIQUE department FROM emp;

C. SELECT DISTINCT department FROM emp;

Both B and C

Question : Which function is used to calculate the total sum of values?

ADD()

TOTAL()

SUM()

COUNT()

Question : What does COUNT(column_name) do?

Counts all rows

Counts non-NULL values

Counts NULL values

Counts duplicate values only

Question : Which query retrieves random rows in MySQL?

SELECT * FROM emp RANDOM();

SELECT * FROM emp ORDER BY RAND();

SELECT RANDOM * FROM emp;

SELECT * FROM emp ORDER RANDOM;

Question : Which operator checks multiple values in a condition?

BETWEEN

LIKE

IN

ALL

Question : What is the purpose of DISTINCT?

Delete duplicates

Display unique values

Sort records

Count rows

Question : Which query finds total marks?

SELECT COUNT(marks) FROM exam;

SELECT SUM(marks) FROM exam;

SELECT TOTAL(marks) FROM exam;

SELECT ADD(marks) FROM exam;

Question : Which SQL clause is used with dates?

DATE

WHERE

HAVING

ORDER

Question : Which query returns records where salary is NULL?

SELECT * FROM emp WHERE salary = NULL;

SELECT * FROM emp WHERE salary IS NULL;

SELECT * FROM emp WHERE salary == NULL;

SELECT * FROM emp NULL salary;

Question : Which keyword is used to check NOT NULL values?

NOT NULL

IS NOT NULL

!= NULL

NULL NOT

Question : Which query selects multiple columns?

SELECT name salary FROM emp;

SELECT name, salary FROM emp;

SELECT (name salary) FROM emp;

SELECT MULTIPLE name salary FROM emp;

Question : What is the output of:

SELECT COUNT(DISTINCT city) FROM customers;

Counts all cities

Counts duplicate cities

Counts unique cities

Counts NULL cities only

Question : Which statement is correct for selecting last records?

SQL has direct LAST keyword in all DBMS

LAST is standard SQL

ORDER BY with DESC is commonly used

LAST works only in MySQL

Question : Which clause sorts query results?

GROUP BY

ORDER BY

SORT BY

ARRANGE BY

Question : Which query selects employees with IDs 1, 3, and 5?

SELECT * FROM emp WHERE id = (1,3,5);

SELECT * FROM emp WHERE id IN (1,3,5);

SELECT * FROM emp WHERE id BETWEEN 1,3,5;

SELECT * FROM emp MULTIPLE 1,3,5;

Question : Which function ignores NULL values automatically?

SUM()

COUNT(column)

AVG()

All of the above

Question : Which query returns 10 random records in MySQL?

SELECT RANDOM 10 * FROM emp;

SELECT * FROM emp ORDER BY RAND() LIMIT 10;

SELECT * FROM emp LIMIT RANDOM 10;

SELECT * FROM emp RANDOM LIMIT 10;

Question : Which SQL keyword is used to rename a column in output?

RENAME

CHANGE

AS

MODIFY

Question : Which query correctly selects records between two dates?

SELECT * FROM orders
WHERE order_date BETWEEN '2026-01-01' AND '2026-12-31';

SELECT * FROM orders DATE 2026;

SELECT * FROM orders IN DATE;

SELECT DATE orders;

Question : What does SELECT DISTINCT salary FROM emp; do?

Deletes duplicate salaries

Displays only unique salary values

Counts salaries

Sorts salaries

Question : Which statement is true about NULL?

NULL means zero

NULL means empty string

NULL means unknown/missing value

NULL means false

Question : Which query finds total number of employees?

SELECT SUM(*) FROM emp;

SELECT COUNT(*) FROM emp;

SELECT TOTAL(*) FROM emp;

SELECT NUMBER(*) FROM emp;

Question : Which SQL query selects students born after 2000?

SELECT * FROM students
WHERE birth_date > '2000-12-31';

SELECT birth_date FROM students > 2000;

SELECT * DATE > 2000;

SELECT * FROM students AFTER 2000;

Question : Which statement retrieves only one random row in PostgreSQL?

SELECT * FROM emp RANDOM 1;

SELECT * FROM emp RANDOM 1;

SELECT * FROM emp ORDER BY RANDOM() LIMIT 1;

SELECT RANDOM(*) FROM emp;

Term & conditions

Privacy & Policy