ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-07-04 09:55:51
In your database, USERS is the default permanent tablespace.SQL> CREATE USER user02 identified by us123 QUOTA 10M ON users;SQL> GRANT create session, sysdba TO user02;You plan to execute the commands:SQL> CREATE TABLE mytab (id number, lname varchar2(20));A) The MYTAB table is .........【阅读全文】
发布时间：2019-07-04 09:22:20
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.A) Increase the size of the redo log buffer.C).........【阅读全文】
发布时间：2019-06-27 14:02:41
Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?B) A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler windowD) A scheduler window can control resourc.........【阅读全文】
发布时间：2019-06-27 13:15:39
The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:FROM employeesHR then opens a second session.A) SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;C) SELECT em.........【阅读全文】
发布时间：2019-06-26 15:54:37
When is the UNDO_RETENTION parameter value ignored by a transaction?B) when the undo tablespace is of a fixed size and retention guarantee is not enabledD) when the data file of the undo tablespace is autoextensible(解析：启用闪回数据库时，对undo_retention这个参数是没有任何关系，其它的.........【阅读全文】
