ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（488）
发布时间：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.(解析：归档模式下可以进行热备，归档之前的备份是不能用来做完.........【阅读全文】
发布时间：2019-07-04 09:55:51
In your database, USERS is the default permanent tablespace.SQL> CREATE USER user02 identified by us123 QUOTA 10M ON users;SQL> GRANT create session, sysdba TO user02;You plan to execute the commands:SQL> CREATE TABLE mytab (id number, lname varchar2(20));A) The MYTAB table is .........【阅读全文】
