Oracle 1z0-082 Exam Practice Questions (P. 1)
- Full Access (178 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
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.)

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- AAUTOEXTEND is possible for the datafileMost Voted
- BIt must be bigger than the largest SMALLFILE tablespace
- CAdditional data files may not be addedMost Voted
- DIt will be a dictionary-managed tablespace by default
- EIt will always have a 32K blocksize
Correct Answer:
AB
AB
send
light_mode
delete
Question #2
Which statement is true about the INTERSECT operator used in compound queries?
- AMultiple INTERSECT operators are not possible in the same SQL statement
- BIt processes NULLs in the selected columnsMost Voted
- CINTERSECT is of lower precedence than UNION or UNION ALL
- DIt ignores NULLs
Correct Answer:
B
B

The INTERSECT operator in SQL does indeed process NULL values. This means that if NULL appears in similar positions across the selected columns of the intersecting queries, the result set will include these NULLs. It's crucial to remember that unlike some SQL operations where NULLs are sometimes treated as 'unknown' or excluded, in the case of INTERSECT, they are considered in the outcome, provided they match across all queries being intersected. This understanding is vital for efficiently utilizing INTERSECT in your SQL queries to ensure accurate results where NULL values are involved.
send
light_mode
delete
Question #3
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- AConnect Time Failover requires the use of Transparent Application Failover (TAF)
- BSource Routing requires the use of a name server
- CSource Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewallMost Voted
- DLoad Balancing can balance the number of connections to dispatchers when using a Shared Server configurationMost Voted
- ELoad Balancing requires the use of a name server
- FConnect Time Failover requires the connect string to have two or more listener addresses configuredMost Voted
Correct Answer:
BCF
Reference:
https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
BCF
Reference:
https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
send
light_mode
delete
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.)
- ACURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- BSYSDATE can be queried only from the DUAL table
- CCURRENT_DATE returns the current date and time as per the session time zoneMost Voted
- DSYSDATE can be used in expressions only if the default date format is DD-MON-RR
- ESYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
- FCURRENT_TIMESTAMP returns the same date as CURRENT_DATEMost Voted
Correct Answer:
CF
CF

The correct answers are indeed options C and F. CURRENT_DATE provides the current date and time according to the session's time zone. This is distinct from SYSDATE, which aligns with the server's operating system date and time. CURRENT_TIMESTAMP, on the other hand, extends this by including fractional seconds and also the session's time zone, making it more detailed compared to CURRENT_DATE, which purely provides date and time without the fractional seconds or timezone. These nuances are crucial for precise time handling in database operations.
send
light_mode
delete
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?
An UPDATE is executed on a temporary table.
Where is the UNDO stored?
- Ain the undo tablespace
- Bin the SYSAUX tablespace
- Cin the SGA
- Din the PGA
- Ein the temporary tablespaceMost Voted
Correct Answer:
A
Reference:
https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11478
(16.7)
A
Reference:
https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11478
(16.7)
send
light_mode
delete
All Pages