Free Oracle 1Z0-182 Exam Questions

Become Oracle Certified with updated 1Z0-182 exam questions and correct answers

Page: 1 / 19

Total 95 Questions | Updated On: Mar 13, 2026

Add To Cart

Question 1

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

A : Dependent indexes become UNUSABLE.

B : The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

C : Only queries are allowed on ORDERS while SHRINK is executing.

D : The high-water mark (HWM) of ORDERS is adjusted.

E : Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

F : The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

Answer: E,F

Question 2

Which two statements are true about the configuration and use of UNDO?

A : Active UNDO is always retained.

B : Unexpired UNDO is always retained.

C : UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

D : UNDO_RETENTION specifies how long all types of UNDO are retained.

E : UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Answer: A,E

Question 3

Which two account management capabilities can be configured using Oracle profiles?

A : The maximum number of sessions permitted for a user before the password must be changed.

B : The maximum amount of CPU time allowed for a user’s sessions before their account is locked.

C : The number of days for which an account may be logged in to one or more sessions before it is locked.

D : The ability to prevent a password from ever being reused.

E : The number of days for which an account may be inactive before it is locked.

Answer: D,E

Question 4

Which three statements are true about row chaining and row migration done by Oracle database block space management?

A : A migrated row results in an update to any index on the table to point the row ID in the index to the row’s new location.

B : Update statements can result in one or more migrated rows.

C : Update statements can result in one or more chained rows.

D : Row pieces of a chained row must always reside in different blocks.

E : Insert statements can result in a migrated row.

Answer: A,B,C

Question 5

Which two statements are true about the tools used to configure Oracle Net Services?

A : The lsnrctl utility requires a listener.ora file to exist before it is started.

B : Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

C : The Oracle Net Configuration Assistant is only used when running the Oracle installer.

D : Oracle Net Manager can be used to locally configure naming methods on a database server.

E : Oracle Net Manager can be used to centrally configure listeners on any database server target.

Answer: B,D

Page: 1 / 19

Total 95 Questions | Updated On: Mar 13, 2026

Add To Cart