OCP 11g考试题库详解:1Z0-051-081题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询OCP 11g考试题库详解:1Z0-051-081题,完整题库请点击这里联系老师咨询了解
81. You are currently located in Singapore and have connected to a remote database in Chicago.
You issue the following command:
SQL> SELECT ROUND(SYSDATE-promo_begin_date,0)
FROM promotions
WHERE (SYSDATE-promo_begin_date)/365 > 2;
PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?
A. a n error because the ROUND function specified is invalid
B. a n error because the WHERE condition specified is invalid
C. number of days since the promo started based on the current Chicago date and time
D. number of days since the promo started based on the current Singapore date and time
Answer: C
试题解析:
日期-日期,返回的是天数,是一个数字,
由本地连接到远程,SYSDATE是一个 SQL 函数,它用于返回当前所连接的远程服务器上数据库的日期和时间。
故选C.