Oracle
1Z0-082 · Question #2
Which two statements are true about the DUAL table? (Choose two.)
The correct answer is A. It can be accessed only by the SYS user B. It consists of a single row and single column of VARCHAR2 data type. https://en.wikipedia.org/wiki/DUAL_table
Administering a Multitenant Container Database
Question
Which two statements are true about the DUAL table? (Choose two.)
Options
- AIt can be accessed only by the SYS user
- BIt consists of a single row and single column of VARCHAR2 data type
- CIt can display multiple rows but only a single column
- DIt can be used to display only constants or pseudo columns
- EIt can be accessed by any user who has the SELECT privilege in any schema
- FIt can display multiple rows and columns
How the community answered
(36 responses)- A75% (27)
- C14% (5)
- D8% (3)
- E3% (1)
Explanation
Topics
#DUAL table#SYS schema#system objects#SQL fundamentals
Community Discussion
No community discussion yet for this question.