Which SQL clause is used to sort the result set in ascending or descending order?

The correct answer is B: ORDER BY. The ORDER BY clause sorts the result set in ascending (ASC) or descending (DESC) order. Default is ascending.

In a bank database with accounts and transactions tables, to find accounts with transactions greater than 100,000, which clause must follow GROUP BY?

The correct answer is B: HAVING. HAVING clause filters grouped results after aggregation. WHERE filters before grouping. Use HAVING with aggregate functions.

What will be the output of: SELECT MAX(salary) FROM employees GROUP BY department;

The correct answer is B: The maximum salary for each department. MAX() with GROUP BY returns the maximum salary value for each distinct department.

What is the output of: SELECT COALESCE(NULL, NULL, 'SQL', 'Database');?

The correct answer is B: 'SQL'. COALESCE returns first non-NULL value. It skips two NULLs and returns 'SQL' as first non-NULL argument.

Home

Home › Subjects › Database

Database

SQL queries, DBMS, normalization, transactions

19 Q 1 Topics Take Mock Test

Difficulty: All Easy Medium Hard 1–10 of 19

Topics in Database

All SQL Basics 57

Q.1 Easy SQL Basics

Which feature of SQL allows preventing duplicate values in a column?

A PRIMARY KEY constraint

B UNIQUE constraint

C NOT NULL constraint

D FOREIGN KEY constraint

Correct Answer: B. UNIQUE constraint

EXPLANATION

UNIQUE constraint prevents duplicate values. PRIMARY KEY is unique + NOT NULL. NOT NULL only prevents nulls. FOREIGN KEY maintains referential integrity.

Test

Q.2 Easy SQL Basics

Which SQL statement is used to add a new column to existing table?

A ADD COLUMN

B ALTER TABLE ... ADD

C INSERT COLUMN

D UPDATE TABLE ... ADD

Correct Answer: B. ALTER TABLE ... ADD

EXPLANATION

ALTER TABLE ... ADD COLUMN syntax is correct for adding columns. Other options are invalid SQL syntax.

Test

Q.3 Easy SQL Basics

Which aggregate function ignores NULL values in SQL?

A COUNT(*)

B COUNT(column_name)

C SUM()

D Both B and C

Correct Answer: D. Both B and C

EXPLANATION

COUNT(column_name), SUM(), AVG(), MAX(), and MIN() all ignore NULL values. COUNT(*) counts all rows including NULLs.

Test

Q.4 Easy SQL Basics

What is the default sort order for ORDER BY clause in SQL?

A Ascending

B Descending

C Random

D Alphabetical

Correct Answer: A. Ascending

EXPLANATION

ORDER BY sorts in ascending order by default. Use DESC keyword for descending order.

Test

Q.5 Easy SQL Basics

In a student enrollment database, you need to find students enrolled in multiple courses. Which JOIN type should be used to match course_id from enrollment table with course table?

A INNER JOIN

B LEFT JOIN

C RIGHT JOIN

D CROSS JOIN

Correct Answer: A. INNER JOIN

EXPLANATION

INNER JOIN returns only matching records from both tables, perfect for finding students with matching course enrollments.

Test

Q.6 Easy SQL Basics

Which SQL command is used to remove all records from a table without removing the table structure?

A DELETE

B TRUNCATE

C DROP

D REMOVE

Correct Answer: B. TRUNCATE

EXPLANATION

TRUNCATE removes all rows but keeps the table structure. DELETE removes rows one by one and can be rolled back. DROP removes the entire table.

Test

Q.7 Easy SQL Basics

What is the result of: SELECT CASE WHEN 1=1 THEN 'A' WHEN 2=2 THEN 'B' ELSE 'C' END;?

A 'B'

B 'A'

C 'C'

D NULL

Correct Answer: B. 'A'

EXPLANATION

CASE statement evaluates conditions sequentially and returns value for first TRUE condition. 1=1 is TRUE, so 'A' is returned.

Test

Q.8 Easy SQL Basics

What will be the result of: SELECT 10 % 3; in SQL?

A 3

B 1

C 3.33

D Error

Correct Answer: B. 1

EXPLANATION

The modulus operator (%) returns remainder after division. 10 divided by 3 gives remainder 1.

Test

Q.9 Easy SQL Basics

Which SQL JOIN returns only matching rows from both tables?

A LEFT JOIN

B RIGHT JOIN

C INNER JOIN

D FULL OUTER JOIN

Correct Answer: C. INNER JOIN

EXPLANATION

INNER JOIN returns only rows where join condition is satisfied in both tables. Other JOINs include non-matching rows.

Test

Q.10 Easy SQL Basics

What is the purpose of the DISTINCT keyword in SQL?

A To sort results in ascending order

B To remove duplicate rows from results

C To limit the number of rows returned

D To group rows by column values

Correct Answer: B. To remove duplicate rows from results

EXPLANATION

DISTINCT eliminates duplicate rows from query results, ensuring each unique combination appears only once.

Test

1 2

All Subjects & Topics

Govt. Exams

Entrance Exams

Teacher Exams

Subjects

Quick Links

Database

About Database Practice on iGET

Why prepare with iGET?

How to use this page effectively