Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 166

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

It can display multiple rows but only a single column.

It can be accessed only by the SYS user.

It can be accessed by any user who has the SELECT privilege in any schema.

It can display multiple rows and columns.

It consists of a single row and single column of VARCHAR2 data type.

It can be used to display only constants or pseudo columns.

Correct Answer: C, E

The DUAL table is a special one-row, one-column table present by default in Oracle databases. This table can be accessed by any user who has the SELECT privilege, making option C true. The table consists of a single row and a single column, which is correct as described in option E. Therefore, the correct answers are C and E.

Discussion

lucemqyOptions: CE

CE is correct answer

WingLOptions: CE

CE correct see the reference below https://docs.oracle.com/cd/B14117_01/server.101/b10759/queries009.htm

DarnunOptions: CE

CE are correct. https://www.examtopics.com/discussions/oracle/view/14717-exam-1z0-071-topic-1-question-293-discussion/

Darnun

https://www.examtopics.com/discussions/oracle/view/14717-exam-1z0-071-topic-1-question-293-discussion/