Which two statements are true about the DUAL table?
A.
It can display multiple rows and columns.
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 but only a single column.
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.
The Answer Is:
C, E
This question includes an explanation.
Explanation:
A. Incorrect. DUAL consists of a single row and column. B. Incorrect. DUAL is a special one-row, one-column table present by default in all Oracle database installations and can be accessed by any user with SELECT privilege. C. Correct. Any user with the SELECT privilege can select from the DUAL table. It is a dummy table used primarily for selecting a constant, pseudocolumn, or expression not involving any tables. D. Incorrect. DUAL has only one row and one column. E. Correct. The DUAL table has a single VARCHAR2 column called DUMMY, which has a value of 'X'. F. Incorrect. DUAL can be used for a variety of purposes, such as selecting system constants, user environment variables, expressions, and sequences.
This information is detailed in the Oracle Database SQL Language Reference, which describes the properties and uses of the DUAL table.
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"