![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
ocp
文章平均质量分 80
hobbypei
Java程序员
展开
-
ocp 1Z0-051 1-22题解析
1. View the Exhibit andexamine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables. The PROD_ID column isthe foreign key in the SALES table, which references the PRODUCTS table. Simil转载 2013-12-19 19:10:06 · 6019 阅读 · 0 评论 -
ocp 1Z0-051 23-70题解析
23. Examine thestructure proposed for the TRANSACTIONS table: name Null Type TRANS_ID NOT NULLNUMBER(6) CUST_NAME NOT NULLVARCHAR2(20) CUST_STATUS NOT NULLCHAR TRANS_DATE NOT NULL DATE TRANS_VAL转载 2013-12-19 19:11:04 · 5878 阅读 · 0 评论 -
ocp 1Z0-051 106-140题解析
106. Examine the data inthe LIST_PRICE and MIN_PRICE columns of the PRODUCTS table: LIST_PRICE MIN_PRICE 10000 8000 20000 30000 30000 Which two expressionsgive the same output? (Choose two.) A.转载 2013-12-19 19:12:31 · 3816 阅读 · 0 评论 -
ocp 1Z0-051 71-105题解析
71. Which arithmeticoperations can be performed on a column by using a SQL function that is builtinto Oracle database ?(Choose three .) A. a ddition B. s ubtraction C. r aising to a power D. f in转载 2013-12-19 19:11:51 · 3982 阅读 · 0 评论 -
trunc 函数使用
1、日期比较时精确到日,可以使用 TRUNC(sysdate,'dd')函数。 函数支持格式有:yyyy MM dd hh Mi 可以用 select TRUNC(sysdate,'yyyy') from dual 看看结果是什么。 不要按下面的方式比较日期: TO_DATE(TO_CHAR(LOGTIME,'YYYY-MM-DD'), 'YYYY-MM-DD')原创 2013-12-20 10:29:03 · 566 阅读 · 0 评论 -
ocp 1Z0-051 141-175题解析
141. View the Exhibitand examine the structure of CUSTOMERS and GRADES tables. You need to displaynames and grades of customers who have the highest credit limit. Which two SQL statementswould accom转载 2013-12-19 19:13:23 · 2863 阅读 · 0 评论