1Z0-082 Exam Questions and Answers | Exam-Dumps.net (Page: 6)

QUESTION: 26

In which three situations does a new transaction always start? (Choose three.)

when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
when issuing a DML statement after a DML statement failed in the same session

Answer(s): A,D,F

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

INTERSECT
UNION ALL
UNION
SUBTRACT
MINUS

Answer(s): E

Reveal Solution Next Question

QUESTION: 28

Your database instance is started with a PFILE. Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache. You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;

What is the outcome?

The value is changed only in the PFILE and takes effect at the next instance startup
The value is changed for the current instance and in the PFILE
It fails because the SCOPE clause is missing
Change is applied to the current instance, but does not persist after instance restart

Answer(s): D

Reference:

https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902

Reveal Solution Next Question

QUESTION: 29

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Oracle Managed Files (OMF)
Online table segment shrink
Online index segment shrink
Automatic data file extension (AUTOEXTEND)
Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Answer(s): A,D,E

Reveal Solution Next Question

QUESTION: 30

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

You can no longer monitor it
You can reattach to it and monitor it
It is paused and can be resumed
It continues to run in the background
It terminates

Answer(s): A,E

Reference:

https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/

Reveal Solution Next Question

Oracle 1Z0-082 Exam (page: 6)
Oracle Database Administration I
Updated on: 31-Aug-2025

QUESTION: 26

QUESTION: 27

QUESTION: 28

Reference:

QUESTION: 29

QUESTION: 30

Reference:

Oracle 1Z0-082 Exam (page: 6) Oracle Database Administration I Updated on: 31-Aug-2025

QUESTION: 26

QUESTION: 27

QUESTION: 28

Reference:

QUESTION: 29

QUESTION: 30

Reference:

Oracle 1Z0-082 Exam (page: 6)
Oracle Database Administration I
Updated on: 31-Aug-2025