Multiple choice technology programming languages

Which of the following is not true about 'Dual'

  1. It is a oracle table with only one row and one column

  2. It supports arithmetic calculations

  3. It doesnot support date retrival

  4. The table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'.

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The DUAL table in Oracle is a special table with one row and one column (DUMMY, value 'X'). It DOES support arithmetic calculations (SELECT 1+2 FROM DUAL) and DOES support date retrieval (SELECT SYSDATE FROM DUAL). Therefore option C is NOT true, making it the correct answer to the question.