Oracle Certification Exam Question:

What will be the output for this query:
select 1 from dual minus select a from dual;

Answer:

This will produce Error:
Expression must have same datatype as corresponding expression

Download Oracle Certification PDF Read All 25 Oracle Certification Questions

Previous Question

Next Question

How to create a multiple databases with the same configuration?

Explain Which two statements are true regarding working with dates? (Choose two.)
A. The default internal storage of dates is in the numeric format
B. The default internal storage of dates is in the character format
C. The RR date format automatically calculates the century from the SYSDATE function and does
not allow the user to enter the century
D. The RR date format automatically calculates the century from the SYSDATE function but allows
the user to enter the century if required?