Oracle Database Administration I — Question 4

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

Answer options

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

Correct answer: B, F

Explanation

Option B is correct because the DUAL table indeed consists of one row and one column, specifically of the VARCHAR2 data type. Option F is incorrect as the DUAL table only contains one row and one column; it does not display multiple rows and columns. Options A, C, D, and E do not accurately represent the properties of the DUAL table.