ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-07-25 13:14:42
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U. ? PASSWORD_REUSE_MAX is 5. ? PASSWORD_REUSE_TIME is 10. ? PASSWORD_GRACE_TIME is 15. Which two conditions must be met for USER1 to reuse oracle_4U? A)At least 5 days m.........【阅读全文】
发布时间：2019-07-25 10:39:39
Which four statements are true about truncating a table? A)Any insert triggers for the table will be executed. B)Any of the table’s indexes are also truncated. C)Any delete triggers for the table will be executed. D)All table storage can be retained. E)Only .........【阅读全文】
发布时间：2019-07-24 14:14:13
SQL> SELECT * FROM emp; --- ------- 101 Alan 1 row created. Commit completed. 1 row updated. SQL>SELECT ename FROM emp; A)Only Adam and Alan are displayed. C)Only Adam, Alan, and Bryan are displayed. E)Only Adam, Alan, and Ben are .........【阅读全文】
发布时间：2019-07-24 13:27:38
USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO. USER1 executes these commands: SQL> UPDATE dept SET loc='UK' where dno=1; 1 row updated. SQL> UPDATE emp SET sal=1000 where eno=100; 1 row updated. SQL>ALTER TABLE de.........【阅读全文】
发布时间：2019-07-18 13:10:42
When does a database checkpoint occur?B) When the SHUTDOWN ABORT command is issued.D) When a server process terminates abnorthally.(解析：日志切换时会发生检查点，目的是把记录在该日志中的事务造成的脏块写入数据文件。)......【阅读全文】
