OCP11g+12c考试资料群:1015267481 验证码:ocp
摘要: 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 阅读(532) 评论(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 阅读(400) 评论(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 阅读(567) 评论(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 阅读(1335) 评论(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 阅读(1821) 评论(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 阅读(481) 评论(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 阅读(322) 评论(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 阅读(223) 评论(0) 推荐(0)
摘要: 35、Your database is using Automatic Memory Management. Which two SGA components must be managed manually? A) default buffer cache B) redo log buffer C 阅读全文
posted @ 2018-08-08 11:40 cnblogs_5359 阅读(276) 评论(0) 推荐(0)
摘要: 34、Which two can be backed up by using RMAN when a database Is open in ARCHIVELOG mode, so that media recovery can be performed If required? A) contro 阅读全文
posted @ 2018-08-03 14:06 cnblogs_5359 阅读(162) 评论(0) 推荐(0)