CUUG内部OCP题库解析-071-文档2
15页1、CUUG内部OCP题库解析-071-文档2题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。(071-sql部分考试)下面的题是(071考试-第2个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/191、(4-2)choose the best answer:View the Exhibit and examine the structure of the CUSTOMERS table.CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERStable.CUSTOMERS needs to be updated to reflect the latest information about the customers.What is the error in t
2、he following MERGE statement?MERGE INTO customers cUSING customer_vu cvON (c.customer_id = cv.customer_id)WHEN MATCHED THENUPDATE SETc.customer_id = cv.customer_id,c.cust_name = cv.cust_name,c.cust_email = cv.cust_email,c.income_level = cv.income_levelWHEN NOT MATCHED THENINSERT VALUES(cv.customer_id,cv.cust_name,cv.cust_email,cv.income_level)WHERE cv.income_level 100000;A) The INTO clause is misplaced in the command.B) The WHERE clause cannot be used with INSERT.C) CU TOMER_VU cannot be used as
3、 a data source.D) The CUSTOMER_ID column cannot be updated.2、(4-7) choose the best answer:You need to display the first names of all customers from the CUSTOMERS table that contain thecharacter e and have the character a in the second last position.Which query would give the required output?A) SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, e) ANDSUBSTR(cust_first_name, -2, 1)=a;B) SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, e)0 ANDSUBSTR(cust_first_name, -2
4、, 1)=a;C) SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, e)0 ANDSUBSTR(cust_first_name, LENGTH(cust_first_name -2)=a;D) SELECT cust_first_nameFROM customersWHERE INSTR(cust_first_name, e)IS NOT NULL ANDSUBSTR(cust_first_name, 1,-2)=a;Answe :B051的题3、(4-10) choose the best answer:The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:GRANT ALLON orders, order_itemsTO PUBLIC;What must be done to fix the statement?A) ALL should be replaced with a
《CUUG内部OCP题库解析-071-文档2》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-071-文档2》请在金锄头文库上搜索。
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页