ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间:2018-08-08 11:43:06
35、Your database is using Automatic Memory Management.Which two SGA components must be managed manually?A) default buffer cacheB) redo log bufferC) large poolD) shared poolE) keep buffer poolAnswer:BE......【阅读全文】
发布时间:2018-08-03 14:07:03
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) control filesB) password fileC) pfileD) online redo logsE) flashback logsF) data filesAnswer:AF......【阅读全文】
发布时间:2018-08-03 14:02:53
33、Where Is backup metadata stored for use by Recovery Manager (RMAN)?A) In the control fileB) In the SYSAUX tablespaceC) in the SPFILED) in the SYSTEM tablespaceE) In the diagnostic destination fliesAnswer:A......【阅读全文】
发布时间: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.........【阅读全文】