ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：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.(解析：日志切换时会发生检查点，目的是把记录在该日志中的事务造成的脏块写入数据文件。)......【阅读全文】
发布时间：2019-07-18 10:54:40
Which three statements are true about naming methods?B) The local naming method does not support connect-time failover and load-balancing options.D) Local naming supports multiple protocols, but for any one connection, the client and server must use the same protocol.Answer：AD.........【阅读全文】
