发布时间：2021-12-28 17:22:18

Which three statements are true concerning logical and physical database structures? (Choose three.)A. All tablespaces may have one or more data filesB. The extents of a segment must always reside in the same datafileC. A smallfile tablespace might be bigger than a bigfile tablespace.........【阅读全文】

发布时间：2021-12-27 17:00:35

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:LISTENER_1=(ADDRESS=(PROTOCOL=TCP)(HOST=host1.abc.com)(PORT=1521))Which statement is true?A. Dyna.........【阅读全文】

发布时间：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.........【阅读全文】