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 : 30 May 2025

All the best!!

Name

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

Deselect Answer

NULL

4500

Error

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

WHERE Customer_Name==NULL;

WHERE Customer_Name=NULL;

WHERE Customer_Name='NULL';

None

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

Deselect Answer

NUMBER to DATE

DATE to VARCHAR2

VARCHAR2 to DATE

NUMBER to VARCHAR2

None

What does SQL stand for?

Deselect Answer

Strict Query Language

Standard Query Language

Strong Query Language

Structured Query Language

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

What does a relational database consists of?

Deselect Answer

Fields

Key-value

Rows

Tables

Records

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

None of the option is correct

Error, ELSE is mandatory block for CASE

NULL

Either 0 or NULL

None

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

Deselect Answer

None

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

Deselect Answer

LPAD()

RPAD()

You cannot remove space

RTRIM()

LTRIM()

None

10.

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

Deselect Answer

DESC

RANDOM

ASC

DEFAULT

None

11.

What is true about the COALESCE function?

Deselect Answer

None of the options are true

It always returns the first NULL value among the input parameters

It accepts minimum 2 and maximum 10 input parameters

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

None

12.

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

Deselect Answer

Sum()

Count(column)

Min()

Count(*)

Avg()

Max()

None

13.

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

Deselect Answer

user access

translating SQL queries sent by the user

organization of the data in the database

communicating with the operating system

creating web-based applications

None

14.

Which of the following SQL clauses specifies a search condition?

Deselect Answer

WHERE

FROM

WHILE

None

15.

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

Deselect Answer

FIRST NULLS

NULLS FIRST

NULLS LAST

LAST NULLS

NULLS ASC

None

16.

What will be the output of below SQL?

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

Deselect Answer

50.9 and 45.94

45 and 45.93

50 and 45.93

40 and 45

50 and 45.9

None

17.

Which of the following sentence is true?

Deselect Answer

data contains databases, a database contains tables

a database contains tables, a table contains data

data contains database, table contains database

a table contains databases, a database contains data

None

18.

How many input parameters are mandatory in NVL function?

Deselect Answer

None

19.

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

Deselect Answer

ABCD

AXXB

ABBCD

None

20.

What does RDBMS stand for?

Deselect Answer

Relationship Database Management Systems

Relational Database Management System

Relational Database Management Software

Relational Database Manager System

None

21.

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

Deselect Answer

Insert

Update

Delete

Truncate

None

22.

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

Deselect Answer

Arial

Alexandria

Maria

maria

None

23.

Which operator can be used for appending two strings?

Deselect Answer

None

24.

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

Only 2 is TRUE

Both 2 and 3 are TRUE

Both 3 and 4 are TRUE

None

25.

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

1st

1ST

01ST

01ST JAN

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