Free 1Z0-182 Questions for Oracle 1Z0-182 Exam

Question #1

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

A. Unexpired UNDO is always retained.

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

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

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

E. Active UNDO is always retained.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #2

Which statement regarding PDBs (Pluggable Databases) is correct?

A. When the relocation of a PDB is finished, the source PDB must be dropped.

B. You can drop a PDB as long as it is not the PDB seed.

C. You can drop an application root along with the associated PDBs.

D. You cannot drop a source PDB of a refreshable PDB.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

Which two are true about shrinking a segment online?

A. It is not possible to shrink either indexes or Index Organized Tables (IOTs).

B. It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

C. To shrink a table it must have row movement enabled.

D. To shrink a table it must have a UNIQUE KEY constraint.

E. To shrink a table it must have a PRIMARY KEY constraint.

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #4

Which three statements are true about dynamic performance views?

A. They are owned by the SYSTEM user.

B. Read consistency is not guaranteed.

C. They can be queried only when the database is open.

D. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.

E. V$FIXED_TABLE can be queried to display the names of all dynamic performance views.

Discussion 0

Correct Answer: B,D,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #5

Which three statements are true about Deferred Segment Creation in Oracle databases?

A. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

B. It is supported for SYS-owned tables contained in locally managed tablespaces.

C. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.

D. It is the default behavior for tables and indexes.

E. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?

A. In the SPFILE and PFILE

B. Only in memory

C. Only in the SPFILE

D. In the SPFILE, PFILE, and memory

E. In the SPFILE and memory

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

A. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

B. Analysis of privileges granted indirectly to a role that are then used by a user who has beengranted that role.

C. Analysis of privileges that a user has on their own schema objects that they did not use.

D. Analysis of all privileges used by all users including administrative users in the database.

E. Analysis of all privileges used by all users but excluding administrative users in the database.

F. Analysis of privileges that a user has on their own schema objects that they did use.

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

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

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

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

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

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

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

F. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

Discussion 0

Correct Answer: A,E,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #9

Which three tasks are performed by background processes in an Oracle database instance?

A. Reading database blocks into the buffer cache.

B. Reading database blocks into the buffer cache.

C. Creating dedicated server connections.

D. Writing dirty database block images from the buffer cache.

E. Registering services with Oracle Net listeners.

F. Writing redo to log files.

Discussion 0

Correct Answer: D,E,F Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #10

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?

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

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

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free 1Z0-182 Questions for Oracle Database 23ai Administration Associate 1Z0-182 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z0-182 Demo