165
164
082题库
- OCP 19c 认证1Z0-082考试题库（第5题）（CUUG内部082题库解析）2020-09-25
OCP 19c 认证1Z0-082考试题库（第5题）（CUUG内部082题库解析）5.A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored?A. in the undo tablespaceB. in the SYSAUX tablespaceC. in the SGAD. in the PGAE. in the temporary tablespaceAnswer: E(解析：temporary undo 是 12c 的一个新特性，目的是为了减少对正常 und........详情
- OCP 19c 认证1Z0-082考试题库（第4题）（CUUG内部082题库解析）2020-09-25
OCP 19c 认证1Z0-082考试题库（第4题）（CUUG内部082题库解析）4.Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional secondsB. SYSDATE can be queried only from the DUAL tableC. CURRENT_DATE returns the current date a........详情
- OCP 19c 认证1Z0-082考试题库（第3题）（CUUG内部082题库解析）2020-09-25
OCP 19c 认证1Z0-082考试题库（第3题）（CUUG内部082题库解析）3.Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)A. Connect Time Failover requires the use of Transparent Application Failover (TAF)B. Source Routing requires the use of a name serverC. Source Routing enables the use of Connection Manage........详情
- OCP 19c 认证1Z0-082考试题库（第2题）（CUUG内部082题库解析）2020-09-25
OCP 19c 认证1Z0-082考试题库（第2题）（CUUG内部082题库解析）2.Which statement is true about the INTERSECT operator used in compound queries?A. Multiple INTERSECT operators are not possible in the same SQL statementB. It processes NULLs in the selected columnsC. INTERSECT is of lower precedence than UNION or UNION ALLD. It ignores NULLsAnswer: B(解析：为了符合新出现的 SQL 标准，Oracle 的未来版本将........详情
- OCP 19c 认证1Z0-082考试题库（第1题）（CUUG内部082题库解析）2020-09-25
OCP 19c 认证1Z0-082考试题库（第1题）（CUUG内部082题库解析）1. You execute this command:CREATE BIGFILE TABLESPACE big_tbsDATAFILE '/u01/oracle/data/big_f1.dbf'SIZE 20G;Sufficient storage is available in filesystem /u01.Which two statements are true about the BIG_TBS tablespace? (Choose two.)A. AUTOEXTEND is possible for the datafileB. It must be bigger than the largest SMALLFILE tablespaceC. Addit........详情
