oracle ocp 19c考題,科目082考試題-date/time functions
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部落格 ” ,連結:http://blog.itpub.net/70010796/viewspace-2848839/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle ocp 19c考題,科目082考試題-Oracle NetOracle
- oracle ocp 19c考題,科目082考試題-temporary undoOracle
- oracle ocp 19c考題,科目082考試題-INTERSECT operatorOracle
- ocp 19c考題,科目082考試題(28) - oracle profilesOracle
- ocp 19c考題,科目082考試題(34)
- ocp 19c考題,科目082考試題(33)
- ocp 19c考題,科目082考試題-bigfile
- ocp 19c考題,科目082考試題(32) -
- oracle ocp 19c考題7,科目082考試題-listener tnsnamesOracle
- oracle ocp 19c考題,科目082考試題(18)-unused columnOracle
- oracle ocp 19c考題,科目082考試題(20)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(19)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(17)-using an invisible columnOracle
- oracle ocp 19c考題10,科目082考試題 - shared server dispatchersOracleServer
- ocp 19c考題,科目082考試題(24)-about sequence
- ocp 19c考題,科目082考試題(27) - order by clause
- ocp 19c考題,科目082考試題(22)- drop columns
- ocp 19c考題,科目082考試題(26) - order by clause
- ocp 19c考題,科目082考試題(25)- instance situations
- ocp 19c考題,科目082考試題(29) - about profiles
- ocp 19c考題,科目082考試題(13)-variable prompt
- ocp 19c考題,科目082考試題(30) - default profile
- ocp 19c考題,科目082考試題(15)-move datafile to
- oracle ocp 19c考題8,科目082考試題-logical and physical database structuresOracleDatabaseStruct
- oracle ocp 19c考題,科目082考試題(21)-read-only tableOracle
- oracle ocp 19c考題11,科目082考試題 - about SET VERIFY ON commandOracle
- ocp 19c考題,科目082考試題(31) - resource_limitMIT
- ocp 19c考題,科目082考試題(14)-starting with the letter D
- ocp 19c考題,科目082考試題(12)-about self-join
- ocp 19c考題,科目082考試題(16)-about dropping and unused columns
- ocp 19c考題,科目082考試題(23)- space management within blocks managed ASSMBloCSSM
- Oracle 19c OCP 1Z0-082認證考試題庫(7-12)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(13-18)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(19-23)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(24-29)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(30-35)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(36-41)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(51-60)Oracle