发布时间：2021-12-24 15:28:01

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:Be stored in a format supporting date arithmetic without using conversion functionsStore a loan period of up to 10 yearsBe used for calculating interest for the number .........【阅读全文】

发布时间：2021-12-23 14:36:21

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 tablespaceS.........【阅读全文】

发布时间：2021-12-22 13:48:16

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 DU.........【阅读全文】

发布时间：2021-12-21 17:49:17

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 server.........【阅读全文】

发布时间：2021-12-15 10:51:55

Oracle OCP 19c 认证1Z0-082考试题库(第2题)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.........【阅读全文】