OCP11g+12c考试资料群:1015267481 验证码:ocp
摘要: 7、(5-1) choose two:View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks would require subqueries? A) Display the minimum l 阅读全文
posted @ 2019-02-14 10:44 cnblogs_5359 阅读(374) 评论(0) 推荐(0)
摘要: 6、(4-21) choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statement: SQL> SELECT 阅读全文
posted @ 2019-02-13 17:02 cnblogs_5359 阅读(346) 评论(0) 推荐(0)
摘要: 5、(4-12) choose two: You executed the following CREATE TABLE statement that resulted in an error: SQL> CREATE TABLE employees( emp_id NUMBER(10) PRIMA 阅读全文
posted @ 2019-02-13 17:00 cnblogs_5359 阅读(527) 评论(0) 推荐(0)
摘要: 4、(4-11) choose two:View the Exhibit and examine the data in the PRODUCT_INFORMATION table.Which two tasks would require subqueries? (Choose two.) A) 阅读全文
posted @ 2019-02-12 16:50 cnblogs_5359 阅读(398) 评论(0) 推荐(0)
摘要: 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_i 阅读全文
posted @ 2019-02-12 16:40 cnblogs_5359 阅读(563) 评论(0) 推荐(0)
摘要: 2019-02-12 16:23:54 2、(4-7) choose the best answer:You need to display the first names of all customers from the CUSTOMERS table that contain thechara 阅读全文
posted @ 2019-02-12 16:26 cnblogs_5359 阅读(1330) 评论(0) 推荐(0)
摘要: 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 ha 阅读全文
posted @ 2019-02-12 16:09 cnblogs_5359 阅读(1818) 评论(0) 推荐(0)
摘要: 38、Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A) Its findings are accessible only by using Oracle Enterprise Manager 阅读全文
posted @ 2018-08-09 14:00 cnblogs_5359 阅读(477) 评论(0) 推荐(0)
摘要: 37、USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2. SYS executes this command: SQL> REVOKE UPDATE ON user1.emp FROM user1; W 阅读全文
posted @ 2018-08-09 13:53 cnblogs_5359 阅读(320) 评论(0) 推荐(0)
摘要: 36、Which two are true about roles? A) A role can be granted a combination of system and object privileges and other roles. B) The CONNECT role Is gran 阅读全文
posted @ 2018-08-08 11:47 cnblogs_5359 阅读(222) 评论(0) 推荐(0)