READ Free Dumps For Oracle- 1z1-051
Question ID 4804 | Which two statements are true regarding working with dates? (Choose two.) |
Option A | A. The default internal storage of dates is in the character format |
Option B | B. The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required |
Option C | C. The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century |
Option D | D. The default internal storage of dates is in the numeric format |
Correct Answer | B,D |
Question ID 4805 | You work as a database administrator at ABC.com. You study the exhibit carefully. |
Option A | A. An alias cannot be used in an expression |
Option B | B. The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expression |
Option C | C. The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values |
Option D | D. The alias NAME should not be enclosed within double quotation marks |
Correct Answer | A |