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 27, 2025

Add To Cart

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

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

Question 4

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 5

Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?

A : Connect Time Failover requires the use of Transparent Application Failover (TAF).

B : Source Routing requires the use of encrypted connections.

C : Connect Time Failover requires the connect string to have two or more listener addresses configured.

D : Load Balancing requires the use of a name server.

E : Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.

Answer: C,E

Page: 1 / 19

Total 95 Questions | Updated On: Mar 27, 2025

Add To Cart