ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间:2021-03-08 10:43:52
7、请选择两项。DELETE FROM employees e(SELECT 'dummy'WHERE employee_id = e.employee_id) ;A)子查询先于DELETE语句执行。C)子查询不是相关子查询。E)即使子查询选择多行, DELETE 语句也会成功执行。......【阅读全文】
发布时间:2021-03-02 14:27:53
10、Choose three.A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are metC. creating the OSDBA (dba) groupE. creating the grid OS user......【阅读全文】
发布时间:2021-03-02 11:31:58
9、choose twoWhich two statements are true about the dependent objects of the CUSTOMERS table?B) Materialized views that use the CUSTOMERS table are flashed back.D) All the constraints defined on the table, except the referential integrity constraints, are flashed back.......【阅读全文】
发布时间:2021-03-02 10:35:52
8、Examine the statements that use flashback technologies:2. SELECT * FROM customers AS OF SCN 123456;4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');6. ALTER TABLE customers FLASHBACK ARCHIVE;A) 1,3,6C) 3,4,5......【阅读全文】
发布时间:2021-03-01 14:31:00
7、choose oneYou execute the following command to change the requirement:What is the outcome?B) An error is returned because the retention period cannot be reduced.D) All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to.........【阅读全文】