Oracle Oracle Database 1Z0-082 Questions & Answers

• Question 91:

  Which two statements are true regarding a SAVEPOINT? (Choose two.)

  A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

  B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement

  C. Only one SAVEPOINT may be issued in a transaction

  D. A SAVEPOINT does not issue a COMMIT

  E. Rolling back to a SAVEPOINT can undo a DELETE statement

  Correct Answer: DE

• Question 92:

  You execute this command:

  

  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 datafile

  B. It must be bigger than the largest SMALLFILE tablespace

  C. Additional data files may not be added

  D. It will be a dictionary-managed tablespace by default

  E. It will always have a 32K blocksize

  Correct Answer: AC

• Question 93:

  Which statement is true about the INTERSECT operator used in compound queries?

  A. Multiple INTERSECT operators are not possible in the same SQL statement

  B. It processes NULLs in the selected columns

  C. INTERSECT is of lower precedence than UNION or UNION ALL

  D. It ignores NULLs

  Correct Answer: B

  SET operators all have the same priority in Oracle Database. NULL values are processed with set operators

• Question 94:

  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

  C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

  D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

  E. Load Balancing requires the use of a name server

  F. Connect Time Failover requires the connect string to have two or more listener addresses configured

  Correct Answer: CDF

  Reference: https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013

• Question 95:

  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 seconds

  B. SYSDATE can be queried only from the DUAL table

  C. CURRENT_DATE returns the current date and time as per the session time zone

  D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR

  E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

  F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

  Correct Answer: CF

• Question 96:

  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 tablespace

  B. in the SYSAUX tablespace

  C. in the SGA

  D. in the PGA

  E. in the temporary tablespace

  Correct Answer: E

  Oracle database 12c Release 1 (12.1) introduced the concept of temporary undo, allowing the undo segments for global temporary tables to be stored in the temporary tablespace. This allows global temporary tables to be used in physical standby databases and read-only databases, as well as removing the need to create redo.

  16.7 Managing Temporary Undo By default, undo records for temporary tables are stored in the undo tablespace and are logged in the redo, which is the same way undo is managed for persistent tables. However, you can use the TEMP_UNDO_ENABLED initialization parameter to separate undo for temporary tables from undo for persistent tables. When this parameter is set to TRUE, the undo for temporary tables is called temporary undo.

  16.7.1 About Managing Temporary Undo Temporary undo records are stored in the database's temporary tablespaces and thus are not logged in the redo log. When temporary undo is enabled, some of the segments used by the temporary tablespaces store the temporary undo, and these segments are called temporary undo segments.

  Reference: http://www.dba-oracle.com/t_temp_undo_enabled.htm Reference: https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11479