Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database 23ai 1z0-182 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-182 Premium Access

View all detail and faqs for the 1z0-182 exam

Go to Exam

735 Students Passed

84% Average Score

94% Same Questions

Viewing page 3 out of 3 pages

Viewing questions 21-30 out of questions

Questions # 21:

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

Options:

Dependent indexes become UNUSABLE.

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

Only queries are allowed on ORDERS while SHRINK is executing.

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

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

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

Questions # 22:

Which of the following is true about the status of a PDB that has been unplugged from a CDB?

Options:

The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.

The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.

The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.

The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

Questions # 23:

Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance?

Options:

Undo segments can be stored in the SYSTEM tablespace.

A single transaction may use multiple undo segments simultaneously.

Undo segments can be stored in the SYSAUX tablespace.

Undo segments can extend when a transaction fills the last extent of the undo segment.

Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.

Questions # 24:

Which two statements are true about trace files produced by the Oracle Database server?

Options:

All trace files contain error information that requires contacting Oracle Support.

They can be written by server processes to a file system.

They can be written by background processes to a file system.

Trace file names are based on the database name concatenated with a sequential number.

They can be written by server processes to the Fast Recovery Area (FRA).

Questions # 25:

In the SPFILE of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: LISTENER_1 = (ADDRESS = (PROTOCOL = TCP)(HOST = host1.abc.com)(PORT = 1521)). Which statement is true?

Options:

The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.

LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.

The LREG process registers services dynamically with the LISTENER_1 listener.

Dynamic service registration cannot be used for this database instance.

There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.

Answer

Explanation

Dynamic service registration allows a database to automatically register its services with a listener without manual configuration in LISTENER.ORA. Let’s analyze each option:

A. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.

Explanation:False. The CONNECT_DATA section is part of a client-side TNSNAMES.ORA entry for connecting to a service, not for listener registration. Dynamic registration is handled by the database’s LREG (Listener Registration) process, which uses the LOCAL_LISTENER parameter to locate the listener’s address (e.g., host1.abc.com:1521). No CONNECT_DATA is needed in the listener address definition itself. This option confuses client connection syntax with listener configuration.

Mechanics:The listener address in TNSNAMES.ORA (LISTENER_1) is sufficient for LREG to find and register with it, as long as the listener is running at that address.

B. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.

Explanation:False. Dynamic registration doesn’t require the listener to be explicitly defined in LISTENER.ORA. The LOCAL_LISTENER parameter pointing to LISTENER_1 (resolved via TNSNAMES.ORA) tells LREG where to register services. If the listener is running on host1.abc.com:1521, LREG will find it without a LISTENER.ORA entry. However, LISTENER.ORA is needed tostartthe listener process, but that’s separate from dynamic registration.

Practical Note:If LISTENER.ORA isn’t configured, a default listener might run on port 1521, but the question implies LISTENER_1 is operational.

C. The LREG process registers services dynamically with the LISTENER_1 listener.

Explanation:True. In Oracle 23ai, the LREG background process (replacing PMON’s registration role in earlier versions) dynamically registers database services with listeners specified by LOCAL_LISTENER. Here, LOCAL_LISTENER=LISTENER_1 resolves to host1.abc.com:1521 via TNSNAMES.ORA. LREG periodically sends service information (e.g., service names, instance details) to the listener, enabling clients to connect without static configuration.

Mechanics:LREG uses the TNS alias (LISTENER_1) to locate the listener’s IP and port, registers services like orcl or orclpdb, and updates the listener’s service table. This happens automatically every 60 seconds or on significant events (e.g., instance startup).

D. Dynamic service registration cannot be used for this database instance.

Explanation:False. The setup (LOCAL_LISTENER set and a valid TNSNAMES.ORA entry) explicitly supports dynamic registration. No blockers (e.g., REGISTRATION_EXCLUDED_LISTENERS) are mentioned, so LREG can function normally.

E. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.

Explanation:False. The question mentions only LISTENER_1 in the SPFILE and TNSNAMES.ORA. There’s no evidence of a second listener (LISTENER) or a LISTENERS configuration (possibly a typo). Two listeners can’t share the same port (1521) on the same host due to port conflicts unless explicitly configured with different IPs, which isn’t indicated here.

[References:Oracle Database Net Services Administrator’s Guide 23ai, "Understanding Dynamic Service Registration"; Oracle Database Reference 23ai, "LOCAL_LISTENER Parameter.", , ]

Questions # 26:

At which two container database levels can COMMON Unified Audit Policies be used?

Options:

COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.

At the CDB level.

At the Application Root level of an Application Container.

At any level by using the COMMON option in the policy.

At the PDB level if the policy is created by a COMMON user.

Questions # 27:

You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the appropriate mode to open the PDB to achieve this?