Chinaunix首页 | 论坛 | 博客
  • 博客访问: 17238
  • 博文数量: 36
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 210
  • 用 户 组: 普通用户
  • 注册时间: 2021-11-30 10:47
文章分类
文章存档

2022年(28)

2021年(8)

我的朋友

分类: Oracle

2021-12-22 13:48:16

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

阅读(505) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~