Oracle
1Z0-071 · Question #326
Which two statements are true about the DUAL table? (Choose two.)
The correct answer is B. It can be accessed by any user who has the SELECT privilege in any schema. D. It consists of a single row and single column of VARCHAR2 data type. See the full explanation below for the reasoning.
Question
Which two statements are true about the DUAL table? (Choose two.)
Options
- AIt can display multiple rows but only a single column.
- BIt can be accessed by any user who has the SELECT privilege in any schema.
- CIt can display multiple rows and columns.
- DIt consists of a single row and single column of VARCHAR2 data type.
- EIt can be used to display only constants or pseudo columns.
- FIt can be accessed only by the SYS user.
How the community answered
(29 responses)- A3% (1)
- B76% (22)
- E7% (2)
- F14% (4)
Community Discussion
No community discussion yet for this question.