4.Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
B. SYSDATE can be queried only from the DUAL table
C. CURRENT_DATE returns the current date and time as per the session time zone
D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
Source:cuug
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70010796/viewspace-2848839/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- 从小白到专家 PG技术大讲堂 - Part 2：PG源代码安装
- 从小白到专家 PG 技术大讲堂 - Part 1：PG 简介
- ocp 19c考题，科目082考试题(34)
- ocp 19c考题，科目082考试题(33)
- ocp 19c考题，科目082考试题(32) -
- ocp 19c考题，科目082考试题(31) - resource_limit
- ocp 19c考题，科目082考试题(30) - default profile
- ocp 19c考题，科目082考试题(29) - about profiles
- ocp 19c考题，科目082考试题(28) - oracle profiles
- ocp 19c考题，科目082考试题(27) - order by clause
