ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-07-17 09:27:08
Which statement is true about a database in ARCHIVELOG mode?B) A Fast Recovery Area (FRA) must be configured for the database.D) All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.(解析：归档模式下可以进行热备，归档之前的备份是不能用来做完.........【阅读全文】
发布时间：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.........【阅读全文】
