Oracle Database SQL — Question 122

Which two statements are true about the DUAL table: (Choose two.)

Answer options

• A. It can display multiple rows but only a single column.
• B. It can be accessed only by the SYS user.
• C. It can be accessed by any user who has the SELECT privilege in any schema.
• D. It can display multiple rows and columns.
• E. It consists of a single row and single column of VARCHAR2 data type.
• F. It can be used to display only constants or pseudo columns.

Correct answer: C, E

Explanation

Option C is correct because any user with the SELECT privilege can access the DUAL table, regardless of the schema. Option E is also correct as the DUAL table has exactly one row and one column, specifically of VARCHAR2 data type. The other options are incorrect because DUAL does not show multiple rows or columns, and it is not limited to the SYS user.