Question #1

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

Answer: AC

Question #2

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

Answer: B

Question #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
• 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. Connect Time Failover requires the connect string to have two or more listener addresses configured

Answer: CDE

Question #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 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. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Answer: CE

Question #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 tablespace
• B. in the SYSAUX tablespace
• C. in the SGA
• D. in the temporary tablespace

Answer: D

Question #6 ... 163

Oracle Database Administration I

Note: The 1Z0-082 DEMO includes only a small portion of the actual product content. To access the complete material, please consider purchasing the product. Upon purchase, you'll receive a PDF file containing the entire content.

Additionally, our 1Z0-082 brain dumps has been curated to exclude outdated, invalid, and erroneous information, ensuring a more effective learning experience for you.