Oracle Database Administration I

Here you have the best Oracle 1z0-082 practice exam questions

You have 158 total questions to study from
Each page has 5 questions, making a total of 32 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on November 12, 2024

Question 1 of 158

You execute this command:

Sufficient storage is available in filesystem /u01.

Which two statements are true about the BIG_TBS tablespace? (Choose two.)

AUTOEXTEND is possible for the datafile

It must be bigger than the largest SMALLFILE tablespace

Additional data files may not be added

It will be a dictionary-managed tablespace by default

It will always have a 32K blocksize

Correct Answer: A, C

The BIG_TBS tablespace, being a BIGFILE tablespace, allows the AUTOEXTEND option for the datafile, meaning the datafile can automatically grow as needed without manual intervention. Additionally, a BIGFILE tablespace can only contain a single, large datafile and does not allow adding additional datafiles. Therefore, options stating that AUTOEXTEND is possible and additional data files may not be added are correct.

Question 2 of 158

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

Multiple INTERSECT operators are not possible in the same SQL statement

It processes NULLs in the selected columns

INTERSECT is of lower precedence than UNION or UNION ALL

It ignores NULLs

Correct Answer: B

The INTERSECT operator returns only the rows that appear in both result sets, including NULL values. NULLs are processed and can be part of the result if they are present in both result sets. The other statements are incorrect: you can have multiple INTERSECT operators in the same SQL statement, INTERSECT has the same precedence as UNION and UNION ALL, and it does not ignore NULLs.

Question 3 of 158

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Connect Time Failover requires the use of Transparent Application Failover (TAF)

Source Routing requires the use of a name server

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

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

Load Balancing requires the use of a name server

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

Correct Answer: C, D, F

Source Routing enables the use of Connection Manager (CMAN) which allows for routing network traffic through a firewall, enabling secure connections. Load Balancing can indeed distribute the number of connections among dispatchers within a Shared Server configuration, optimizing resource utilization. Connect Time Failover requires the connect string to have two or more listener addresses configured to provide an alternative in case the initial connection attempt fails.

Question 4 of 158

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.)

CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

SYSDATE can be queried only from the DUAL table

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

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

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

CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Correct Answer: C, F

CURRENT_DATE returns the current date and time as per the session time zone. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE, but it includes additional details such as fractional seconds and the time zone information associated with the session.

Question 5 of 158

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?

in the undo tablespace

in the SYSAUX tablespace

in the SGA

in the PGA

in the temporary tablespace

Correct Answer: E

When a database is configured to use automatic undo management with temporary undo enabled, the undo for temporary tables is stored in the temporary tablespace. This is to separate the handling of undo for temporary tables from that of persistent tables, which remains in the undo tablespace. The temporary undo records are thus managed within the temporary tablespace.