Oracle Database Administration I - 1Z1-082 Exam Questions [2026]

QUESTION NO: 1
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

A. Undo segments can extend when a transaction fills the last extent of the undo segment B. A single transaction may use multiple undo segments simultaneously C. Undo segments have a minimum of three extents D. An undo segment may be used by multiple transactions simultaneously E. Undo segments must be stored in a SMALLFILE tablespace F. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment G. Undo segments must be stored in a BIGFILE tablespace

Correct Answer: A,D,E

QUESTION NO: 2
You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

A. It must be bigger than the largest SMALLFILE tablespace B. Additional data files may not be added C. It will always have a 32K blocksize D. AUTOEXTEND is possible for the datafile E. It will be a dictionary-managed tablespace by default

Correct Answer: A,D

QUESTION NO: 3
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A. NULLS are not ignored during duplicate checking B. The number of columns selected in each SELECT statement must be identical C. The names of columns selected in each SELECT statement must be identical D. Duplicates are eliminated automatically by the UNION ALL operator E. The output is sorted by the UNION ALL operator

Correct Answer: A,B

QUESTION NO: 4
Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

A. input files B. control files C. password files D. dump files E. bad files

Correct Answer: A,B,E

QUESTION NO: 5
Which three object types support deferred segment creation? (Choose three.)

A. index organized tables B. partitioned tables C. heap organized tables D. external tables E. clustered tables F. temporary tables

Correct Answer: A,B,C

QUESTION NO: 6
Which three statements are true about single-row functions? (Choose three.)

A. They return a single result row per table B. They can be used only in the WHERE clause of a SELECT statement C. The argument can be a column name, variable, literal or an expression D. They can be nested to any level E. The data type returned can be different from the data type of the argument F. They can accept only one argument

Correct Answer: A,C,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

A. the first varchab2 column in the first select of the compound query B. the first number column in the first select of the compound query C. the first column in the first select of the compound query D. the first number or varchar2 column in the last select of the compound query E. the first column in the last select of the compound query

Correct Answer: C

QUESTION NO: 8
You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

A. ROW STORE COMPRESS BASIC B. COLUMN STORE COMPRESS FOR QUERY LOW C. ROW STORE COMPRESS ADVANCED D. COLUMN STORE COMPRESS FOR ARCHIVE LOW E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 9
Which statement is true about database links?

A. A public database link can be created only by sys. B. A database link can be created only between two Oracle databases. C. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance. D. Private database link creation requires the same user to exist in both the local and the remote databases. E. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.

Correct Answer: C

QUESTION NO: 10
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

A. Grant DBA to KING B. Set OS_AUTHENT_PREFIX to OPS$ C. Alter user KING to be IDENTIFIED EXTERNALLY D. Unset REMOTE_LOGIN_PASSWORDFILE E. Have the OS administrator add KING to the OSDBA group

Correct Answer: D

QUESTION NO: 11
You start your database instance in NOMOUNT state. Which two actions are performed?

A. The consistency of the database is checked. B. SYS can access the database. C. The control files are opened. D. Memory is allocated for the SG1 E. All required background processes are started.

Correct Answer: D,E

QUESTION NO: 12
Which two are true about instance recovery for a database that is open in read write mode?
(Choose two.)

A. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT. B. Only the CURRENT REDO log group is required to perform instance recovery. C. It is always performed when opening a database. D. The database opens after the roll forward phase of instance recovery has completed. E. It is guaranteed to complete within fast_start_mttr_target number of seconds. F. No users can log on until instance recovery has completed.

Correct Answer: A,C

QUESTION NO: 13
What two are benefits of Data Pump? (Choose two.)

A. It makes use of client system resources. B. It can export data into sequential media, such as tapes. C. It can restart failed export jobs. D. It can execute in parallel. E. It represents database metadata information as DDL statements in the dump file.

Correct Answer: C,D

QUESTION NO: 14
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

A. INTERSECT ignores NULLs B. Column names in each SELECT in the compound query can be different C. Reversing the order of the intersected tables can sometimes affect the output D. INTERSECT returns rows common to both sides of the compound query E. The number of columns in each SELECT in the compound query can be different

Correct Answer: A,B

QUESTION NO: 15
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

A. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo. B. It succeeds and the generated undo is stored in SYSTEM. C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo. D. It succeeds and the generated undo is stored in SYSAUX. E. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".

Correct Answer: C