SQL statements Online Quiz

Which of the following is not true about SQL statements?

• SQL statements are not case sensitive.

• SQL statements can be written on one or more lines.

• Keywords cannot be split across lines.

• Clauses must be written on separate lines.

What is returned by INSTR(‘TUTORIALS POINT’, ‘P’)?

• 11

• 10

• POINT

• TUTORIALS

You want to calculate the tax payable by the employees of an organization. If the employee gets a commission, then the tax would be calculated on commission plus salary, if the employee does not get any commission, then the tax would be calculated on salary only. Which function should you use for calculating tax?

• NVL

• NVL2

• NULLIF

• COALESCE

Which of the following is true about a group function?

• Group functions operate on sets of rows to produce multiple results per group.

• DISTINCT keyword makes a group function consider duplicate values.

• Group functions ignore null values.

• None of the above.

In which of the following cases a DML statement is not executed?

• When existing rows are modified

• When some rows are deleted

• When a table is deleted

• All of the above

Which of the following is not true about the database objects?

• Indexes improve performance of queries.

• Views give alternative names to objects.

• Sequences are numeric value generators.

• Tables are the basic unit of storage.

A database administrator can

• Create users.

• Create privileges.

• Grant privileges.

• All of the above.

Which SQL statement is used to extract data from a database?

• OPEN

• GET

• SELECT

• EXTRACT

Which SQL statement is used to update data in a database?

• SAVE AS

• SAVE

• MODIFY

• UPDATE

Which SQL statement is used to delete data from a database?

• COLLAPSE

• REMOVE

• DELETE