Which two statements are true about the DUAL table? (Choose two.)
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
BD
The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2 (1) column called DUMMY that has a value of ‘X’. It is suitable for use in selecting a pseudo column such as SYSDATE or USER.
From the wiki, and of course dba experience:
The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of ‘X’. It is suitable for use in selecting a pseudo column such as SYSDATE or USER.
-> B and D is correct.