Free Practice Oracle 1Z0-182 Exam Questions 2025

Stay ahead with 100% Free Oracle Database 23ai Administration Associate 1Z0-182 Dumps Practice Questions

Page: 1 / 19

Total 95 Questions | Updated On: Mar 25, 2025

Add To Cart

Question 1

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

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle /sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?

A : Free space is managed using freelists.

B : It uses the database default block size.

C : It must be smaller than the smallest BIGFILE tablespace.

D : It is a locally managed tablespace.

E : Any data files added to the tablespace must have a size of 5 gigabytes.

Answer: B,D

Question 4

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl. No name server is used. Which statement is true about ORCL?

A : It must be the name of the database to whose instance HR wishes to connect.

B : It must resolve to a valid connect descriptor in the client's tnsnames.ora file.

C : It must be the name of the server running the database to whose instance HR wishes to connect.

D : It must resolve to a valid connect descriptor in the server's tnsnames.ora file.

E : It must be the value of the SERVICE_NAMES parameter on the client side.

Answer: B

Question 5