SQL Interview Questions and Answers For Freshers and Experienced

Which SQL keyword is used to retrieve a maximum value ?

MOST

TOP

MAX

UPPER

Answer

Workspace

Report

Discuss

Which of the following SQL commands is used to retrieve data?

DELETE

INSERT

SELECT

JOIN

Answer

Workspace

Report

Discuss

A command that lets you change one or more fields in a record is

Insert

Modify

Look-up

All of the above

Answer

Workspace

Report

Discuss

Which operator performs pattern matching?

BETWEEN operator

LIKE operator

EXISTS operator

None of these

Answer

Workspace

Report

Discuss

Which of the following is not true about single row functions?

They cannot be nested

They operate on single rows only and return one result per row

They may modify the data type

They accept arguments that could be a column or any expression.

Answer

Workspace

Report

Discuss