Which of the following is not an Oracle DML function?

  1. DECODE

  2. TRUNCATE

  3. TO_CHAR

  4. NVL

  5. Trick question, all of these are Oracle DML functions.


Correct Option: B
Explanation:

To solve this question, the user needs to know the meaning of Oracle DML (Data Manipulation Language) functions and should be able to identify which of the given options is not an Oracle DML function.

Oracle DML functions are used to manipulate data stored within the database. They are used to insert, update, select, and delete data from tables. These functions are used to modify the data values present in the database.

Now let's go through each option and explain why it is right or wrong:

A. DECODE: This is an Oracle DML function. It is used to compare expressions and return a value when the first matching condition is found.

B. TRUNCATE: This is not an Oracle DML function. It is a DDL (Data Definition Language) command used to remove all data from a table, but not its structure.

C. TO_CHAR: This is an Oracle DML function. It is used to convert a number or date to a string.

D. NVL: This is an Oracle DML function. It is used to replace NULL values with another value.

E. Trick question, all of these are Oracle DML functions: This statement is incorrect. Option B (TRUNCATE) is not an Oracle DML function.

Therefore, the answer is: B. TRUNCATE

Find more quizzes: