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

All the best!!

Name

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

Error, ELSE is mandatory block for CASE

Either 0 or NULL

NULL

None of the option is correct

None

What does RDBMS stand for?

Deselect Answer

Relational Database Manager System

Relational Database Management System

Relational Database Management Software

Relationship Database Management Systems

None

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

Deselect Answer

None

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

Deselect Answer

FIRST NULLS

NULLS FIRST

LAST NULLS

NULLS ASC

NULLS LAST

None

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

Deselect Answer

None of the options are correct

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

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

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

None

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

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

Deselect Answer

LTRIM()

You cannot remove space

LPAD()

RPAD()

RTRIM()

None

What will be the output of below SQL?

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

Deselect Answer

45 and 45.93

50 and 45.93

50 and 45.9

50.9 and 45.94

40 and 45

None

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

Deselect Answer

user access

organization of the data in the database

communicating with the operating system

creating web-based applications

translating SQL queries sent by the user

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

ABCD

AXXB

ABBCD

None

12.

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

13.

What does a relational database consists of?

Deselect Answer

Fields

Tables

Rows

Key-value

Records

None

14.

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 1 and 2 are TRUE

Only 1 is TRUE

Both 3 and 4 are TRUE

Both 2 and 3 are TRUE

Only 2 is TRUE

None

15.

Which operator can be used for appending two strings?

Deselect Answer

None

16.

Which of the following sentence is true?

Deselect Answer

data contains database, table contains database

a table contains databases, a database contains data

data contains databases, a database contains tables

a database contains tables, a table contains data

None

17.

What does SQL stand for?

Deselect Answer

Standard Query Language

Strict Query Language

Strong Query Language

Structured Query Language

None

18.

Which of the following SQL clauses specifies a search condition?

Deselect Answer

WHERE

WHILE

FROM

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

01ST

1st of January

1st

01ST JAN

1ST

None

20.

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

Deselect Answer

Delete

Insert

Truncate

Update

None

21.

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

Deselect Answer

Avg()

Min()

Count(*)

Sum()

Max()

Count(column)

None

22.

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 accepts minimum 2 and maximum 10 input parameters

None of the options are true

It always returns the first NULL value among the input parameters

None

23.

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

Deselect Answer

Maria

Arial

Alexandria

maria

None

24.

How many input parameters are mandatory in NVL function?

Deselect Answer

None

25.

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

Deselect Answer

DATE to VARCHAR2

VARCHAR2 to DATE

NUMBER to DATE

NUMBER to VARCHAR2

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