Unmasking The Best of SQL: Test Your Expertise! (2024)

Welcome to your Unmasking The Best of SQL: Test Your Expertise!

This quiz has multiple choice questions and each has only one correct answer.

Total Questions : 25

You have 30 Minutes to complete this quiz

To pass this quiz you need to score 80% or above

Today's Date : 4 December 2025

All the best!!

Name

Which statement is/are true?

The OR operator displays a record if ANY conditions listed are true
The AND operator displays a record if ALL of the conditions listed are true
The OR operator displays a record if ALL conditions listed are true
The AND operator displays a record if ANY conditions listed are true

Deselect Answer

Both 3 and 4 are TRUE

Only 1 is TRUE

Only 2 is TRUE

Both 2 and 3 are TRUE

Both 1 and 2 are TRUE

None

Which of the following SQL clauses specifies a search condition?

Deselect Answer

WHERE

WHILE

FROM

None

What will be the output of below SQL?

SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual;

Deselect Answer

50 and 45.93

50.9 and 45.94

50 and 45.9

45 and 45.93

40 and 45

None

Which of the following values is returned in case of a false value if the ELSE block in the CASE statement is undefined?

Deselect Answer

Either 0 or NULL

Error, ELSE is mandatory block for CASE

NULL

None of the option is correct

None

Which operator can be used for appending two strings?

Deselect Answer

None

Which of the following string satisfies the condition 'A_B%'?

Deselect Answer

ABCD

AXXB

ABBCD

None

Which of the following function the DBMS is not responsible for?

Deselect Answer

organization of the data in the database

user access

creating web-based applications

translating SQL queries sent by the user

communicating with the operating system

None

Which of the following is NOT a valid implicit conversion performed by Oracle?

Deselect Answer

NUMBER to DATE

DATE to VARCHAR2

NUMBER to VARCHAR2

VARCHAR2 to DATE

None

Which statement do we use to have null values to return at the top in my query result?

Deselect Answer

LAST NULLS

FIRST NULLS

NULLS LAST

NULLS FIRST

NULLS ASC

None

10.

Which of the following sentence is true?

Deselect Answer

a database contains tables, a table contains data

data contains database, table contains database

a table contains databases, a database contains data

data contains databases, a database contains tables

None

11.

What does a relational database consists of?

Deselect Answer

Records

Tables

Fields

Rows

Key-value

None

12.

What is returned by function MOD(2024,30)?

Deselect Answer

None

13.

How many input parameters are mandatory in NVL function?

Deselect Answer

None

14.

What is the output of coalesce(NULLIF(4500.00,4500),1)?

Deselect Answer

NULL

Error

4500

None

15.

What does SQL stand for?

Deselect Answer

Strong Query Language

Structured Query Language

Standard Query Language

Strict Query Language

None

16.

With this condition :where last_name like '%ria'; row is not displayed when last_name is equal to?

Deselect Answer

maria

Alexandria

Arial

Maria

None

17.

All aggregate functions except _____ ignore null values in their input collection.

Deselect Answer

Count(column)

Max()

Min()

Sum()

Avg()

Count(*)

None

18.

If we don't specify ASC or DESC after the ORDER BY clause, the following is used by default

Deselect Answer

ASC

DEFAULT

DESC

RANDOM

None

19.

Assuming the SYSDATE is 01-JAN-24, what will be the outcome of the following query?

SELECT TO_CHAR (SYSDATE, 'DDTH') FROM dual;Deselect Answer

1ST

01ST

1st of January

01ST JAN

1st

None

20.

What is true about the COALESCE function?

Deselect Answer

None of the options are true

It can accept unlimited (normally, it might take in up to 65535 arguments, but you can still nest the functions if necessary) number of input parameters

It always returns the first NULL value among the input parameters

It accepts minimum 2 and maximum 10 input parameters

None

21.

A table is having some NULL values in a column name "Customer_Name", What condition will return all rows where "Customer_Name" is NULL?

Deselect Answer

WHERE Customer_Name IS NULL;

WHERE Customer_Name='NULL';

WHERE Customer_Name=NULL;

WHERE Customer_Name==NULL;

None

22.

In SQL, which of the following is not a Data Manipulation Language (DML) Commands?

Deselect Answer

Delete

Truncate

Insert

Update

None

23.

What does RDBMS stand for?

Deselect Answer

Relationship Database Management Systems

Relational Database Manager System

Relational Database Management System

Relational Database Management Software

None

24.

For removing extra space at last of name 'Techy Buddy ', which function should be used?

Deselect Answer

RTRIM()

LTRIM()

You cannot remove space

RPAD()

LPAD()

None

25.

Which of the following options is true if more than one WHEN..THEN levels present in a CASE statement?

Deselect Answer

The CASE statement will search in all the levels of WHEN..THEN until all levels are completed.

None of the options are correct

The CASE statement will search in all the levels of WHEN..THEN until it finds a match.

The CASE searches or compares only the first level and exists without checking other levels of WHEN..THEN

None

If you have anything to suggest or correction on any quiz, feel free to comment in the box below

Discover the power of technology and learning with TechyBuddy

Welcome to your Unmasking The Best of SQL: Test Your Expertise!

Are you sure to submit the quiz: Unmasking The Best of SQL: Test Your Expertise! ?