ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-10-14 10:24:31
Exanine the desciption of the EMPLOYEES table:----------------------------------------------------------EMP_NAME VARCHAR2 (40)SALARY NUMBER(8,2)Which query is valid?B) SELECT depe_id,join_date, SUM(salary) FROM employees GROUP BY dept_id:D) SELECT dept_ id,AVG (MAX (salary).........【阅读全文】
发布时间：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......【阅读全文】
发布时间：2019-07-17 09:27:08
Which statement is true about a database in ARCHIVELOG mode?B) A Fast Recovery Area (FRA) must be configured for the database.D) All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.(解析：归档模式下可以进行热备，归档之前的备份是不能用来做完.........【阅读全文】
