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.
