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 : 23 September 2025

All the best!!

Name

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

Deselect Answer

None

What is true about the COALESCE function?

Deselect Answer

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

None of the options are true

It accepts minimum 2 and maximum 10 input parameters

None

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

Deselect Answer

NUMBER to VARCHAR2

NUMBER to DATE

VARCHAR2 to DATE

DATE to VARCHAR2

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

NULL

Error, ELSE is mandatory block for CASE

None of the option is correct

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.9

50 and 45.93

50.9 and 45.94

40 and 45

45 and 45.93

None

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

Deselect Answer

maria

Alexandria

Maria

Arial

None

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

Deselect Answer

Update

Delete

Truncate

Insert

None

How many input parameters are mandatory in NVL function?

Deselect Answer

None

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

10.

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

Deselect Answer

NULL

Error

4500

None

11.

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

Deselect Answer

AXXB

ABBCD

ABCD

None

12.

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 of January

01ST

1st

01ST JAN

1ST

None

13.

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

Deselect Answer

NULLS LAST

FIRST NULLS

NULLS ASC

LAST NULLS

NULLS FIRST

None

14.

Which operator can be used for appending two strings?

Deselect Answer

None

15.

What does a relational database consists of?

Deselect Answer

Rows

Fields

Key-value

Tables

Records

None

16.

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

Deselect Answer

translating SQL queries sent by the user

user access

communicating with the operating system

organization of the data in the database

creating web-based applications

None

17.

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

Deselect Answer

DESC

RANDOM

DEFAULT

ASC

None

18.

Which of the following sentence is true?

Deselect Answer

data contains databases, a database contains tables

a database contains tables, a table contains data

a table contains databases, a database contains data

data contains database, table contains database

None

19.

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

Deselect Answer

RPAD()

LTRIM()

You cannot remove space

LPAD()

RTRIM()

None

20.

Which of the following SQL clauses specifies a search condition?

Deselect Answer

FROM

WHILE

WHERE

None

21.

What does RDBMS stand for?

Deselect Answer

Relationship Database Management Systems

Relational Database Management System

Relational Database Management Software

Relational Database Manager System

None

22.

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

Deselect Answer

Count(*)

Min()

Sum()

Avg()

Count(column)

Max()

None

23.

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==NULL;

WHERE Customer_Name IS NULL;

WHERE Customer_Name=NULL;

WHERE Customer_Name='NULL';

None

24.

What does SQL stand for?

Deselect Answer

Standard Query Language

Strict Query Language

Structured Query Language

Strong Query Language

None

25.

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

Only 2 is TRUE

Only 1 is TRUE

Both 1 and 2 are TRUE

Both 2 and 3 are TRUE

Both 3 and 4 are TRUE

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! ?