ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2018-08-02 11:24:33
32、 Examine these commands and their output:? SQL> SELECT * FROM emp;? ENO ENAME? ---- -----? 100 Adam? 101 Alan? SQL> INSERT INTO emp VALUES(102,'Ben");? 1 row created.? SQL> COMMIT;? Commit completed.? SQL> UPDATE emp SET ename='Bryan' WHERE eno.........【阅读全文】
发布时间：2018-08-02 11:03:19
31、Which two events always request the LGWR to write?A) when LGWR is notified by a server process that performs a Commit or ROLLBACKB) When PMON restarts a server processC) when DBWn writes dirty buffersD) when a log switch occursE) when a checkpoint occursAnswer:CD.........【阅读全文】
发布时间：2018-08-01 13:52:02
30、Which is true when a database instance is shut down?A. Only transactional and normal modes wait for all uncommitted transactions to commit or rollback and then close the database.B. Immediate, transactional, and normal modes all result in a checkpoint.C. Neither the immediate nor .........【阅读全文】
发布时间：2018-07-31 13:28:10
29、In one of your databases:* The database default tablespace is EXAMPLE.* Deferred_segment_creation is false.Examine these commands:SQL> create user user1 identified by oracle_4u password expire;User created.SQL> alter user user1 account unlock;User altered.SQL>gr.........【阅读全文】
发布时间：2018-07-31 11:50:08
28、Which two are true about external tables?A. They support the ORACLE_DATAPUMP access driver.B. They have extents.C. They support all DML operations.D. They can always be updated using SQL.E. They can be stored in an ASM Cluster File System (ACFS).Correct Answer: AE.........【阅读全文】
