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

All the best!!

Name

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

Deselect Answer

communicating with the operating system

user access

organization of the data in the database

translating SQL queries sent by the user

creating web-based applications

None

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

Deselect Answer

FIRST NULLS

NULLS ASC

NULLS LAST

NULLS FIRST

LAST NULLS

None

What does RDBMS stand for?

Deselect Answer

Relationship Database Management Systems

Relational Database Management System

Relational Database Management Software

Relational Database Manager System

None

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

Deselect Answer

Insert

Delete

Update

Truncate

None

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

50 and 45.9

40 and 45

45 and 45.93

50 and 45.93

None

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

Deselect Answer

Arial

maria

Maria

Alexandria

None

Which operator can be used for appending two strings?

Deselect Answer

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

Error, ELSE is mandatory block for CASE

Either 0 or NULL

NULL

None of the option is correct

None

Which of the following sentence is true?

Deselect Answer

a table contains databases, a database contains data

data contains databases, a database contains tables

a database contains tables, a table contains data

data contains database, table contains database

None

10.

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

Deselect Answer

None

11.

How many input parameters are mandatory in NVL function?

Deselect Answer

None

12.

Which of the following SQL clauses specifies a search condition?

Deselect Answer

WHILE

FROM

WHERE

None

13.

What does SQL stand for?

Deselect Answer

Strict Query Language

Strong Query Language

Structured Query Language

Standard Query Language

None

14.

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 it finds a match.

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 searches or compares only the first level and exists without checking other levels of WHEN..THEN

None

15.

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

Deselect Answer

4500

Error

NULL

None

16.

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

1st of January

1st

01ST

01ST JAN

None

17.

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

Deselect Answer

ABBCD

ABCD

AXXB

None

18.

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

Deselect Answer

You cannot remove space

RTRIM()

LTRIM()

LPAD()

RPAD()

None

19.

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

20.

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

WHERE Customer_Name IS NULL;

WHERE Customer_Name=NULL;

None

21.

What is true about the COALESCE function?

Deselect Answer

It always returns the first NULL value among the 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 of the options are true

It accepts minimum 2 and maximum 10 input parameters

None

22.

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

Deselect Answer

Sum()

Count(column)

Min()

Max()

Avg()

Count(*)

None

23.

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

Deselect Answer

ASC

DEFAULT

RANDOM

DESC

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 2 is TRUE

Only 1 is TRUE

Both 2 and 3 are TRUE

Both 3 and 4 are TRUE

None

25.

What does a relational database consists of?

Deselect Answer

Tables

Rows

Records

Key-value

Fields

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