CUUG内部OCP题库解析-071-文档7
10页1、CUUG内部OCP题库解析-071-文档7题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。(071-sql部分考试)下面的题是(071考试-第7个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/19题库解析:QUESTION 66Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAME-Renske Ladwig JasonMallin Samuel McCainAllan MCEwen IreneMikilineniJulia NayerYou need to display customers second names where the second name starts with Mc or MC.Which query gives the required output?A. SELEC
2、T SUBSTR (cust_name, INSTR (cust_name, )+1)FROM customersWHERE SUBSTR (cust_name, INSTR (cust_name, )+1) LIK INITCAP (MC%);B. SELECT SUBSTR (cust_name, INSTR (cust_name, )+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, )+1) = Mc;C. SELECT SUBSTR (cust_name, INSTR (cust_name, )+1)FROM customersWHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, )+1) LIKE Mc%;D. SELECT SUBSTR (cust_name, INSTR (cust_name, )+1)FROM customersWHERE INITCAP (SUBSTR( st_name, INSTR (cust_name, )+1) =
3、 INITCAP MC%;Correct Answer: CSection: (none) Explanation:注意 INSTR 和 substr 的用法,还有 initcap 的用法。QUESTION 67View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMEStables.The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES tablereferencing the CUSTOMERS and TIMES tables, respectively.Evaluate the following CREATE TABLE command:CREATE TABLE new_sales
4、 (prod_id, cust_id, order_date DEFAULT SYSDATE) ASSELECT prod_id, cust_id time_id FROM sales;Which statement is true regarding the above command?A. The NEW_SALES table would get created and all the NOTNULL constraints defined on thespecified columns would be passed to the new table.B. The NEW_SALES table would not get created because the DEFAULTvalue cannot bespecified in the column definition.C. The NEW_SALES table would not get created because the column names in the CREATETABLEcommand and the
《CUUG内部OCP题库解析-071-文档7》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-071-文档7》请在金锄头文库上搜索。
CUUG内部OCP题库解析-052-文档2
CUUG内部OCP题库解析-053-文档2
CUUG内部OCP题库解析-052-文档12
CUUG内部OCP题库解析-052-文档10
CUUG内部OCP题库解析-052-文档11
CUUG内部OCP题库解析-053-文档6
CUUG内部OCP题库解析-052-文档9
CUUG内部OCP题库解析-071-文档5
CUUG内部OCP题库解析-071-文档2
CUUG内部OCP题库解析-052-文档4
CUUG内部OCP题库解析-071-文档4
CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档5
CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-053-文档4
CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-071-文档6
CUUG内部OCP题库解析-071-文档3
CUUG内部OCP题库解析-052-文档6
CUUG内部OCP题库解析-053-文档5
2023-06-30 7页
2022-09-15 93页
2022-06-04 27页
2022-04-25 3页
2022-03-24 7页
2022-03-24 7页
2022-03-24 8页
2022-03-24 4页
2022-03-24 43页
2022-03-24 7页