Free Oracle 1Z0-182 Exam Questions

Question 1

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

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 4