ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：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.........【阅读全文】
发布时间：2019-07-17 10:01:16
Which two statements are true about Oracle network connections?B) A server process checks a user's authentication credentials and creates a session if the credentials are valid.D) The listener always spawns a new server process to deal with each new connection.Answer：BC......【阅读全文】
