[Q49-Q73] Real Oracle 1Z1-182 Exam Questions [Updated 2025]

Real Oracle 1Z1-182 Exam Questions [Updated 2025]

1Z1-182 Exam Dumps Pass with Updated 2025 Oracle Database 23ai Administration Associate

NEW QUESTION # 49
Which three statements are true about a dedicated server configuration?

• A. A dedicated server process can be spawned without a listener when using local clients.
• B. A dedicated server process can be spawned by the listener when using local clients.
• C. A dedicated server process may be reused by a new session after the session using that process terminates.
• D. The DBA configures the maximum number of dedicated server processes that can share the samedispatcher process.
• E. Each dedicated server process has its own dispatcher process.
• F. A dedicated server process communicates directly with a client or middle-tier process once the session is established.

Answer: A,B,F

Explanation:
A .False. Dispatchers are for shared servers, not dedicated.
B .False. Dedicated processes die with the session.
C .True. Direct client-server communication occurs.
D .False. No dispatchers in dedicated mode.
E .True. Listener spawns for local/remote clients.
F .True. Local logins (e.g., sqlplus /) bypass the listener.

NEW QUESTION # 50
Which four statements are true about the Oracle Server architecture?

• A. A session represents the state of a user's login to an instance.
• B. Each server process or background process has their own Program Global Area (PGA).
• C. The buffer cache and the redo log buffer are held in the large pool.
• D. A person or program can have more than one session with an instance by logging in with different users.
• E. A person or program can have more than one session with an instance by logging in with the same user.
• F. A connection represents the state of a user's login to an instance.

Answer: A,B,D,E

Explanation:
A .True. Multiple sessions with different users are possible.
B .False. Buffer cache and redo log buffer are in SGA, not large pool.
C .True. Session tracks login state.
D .True. Each process has its own PGA.
E .False. Connection is the network link; session is the state.
F .True. Same user can have multiple sessions (e.g., via different terminals).

NEW QUESTION # 51
Which three are benefits of using temp UNDO when performing DML on global temporary tables?

• A. It reduces I/Os to the SYSAUX tablespace.
• B. It reduces the amount of UNDO stored in the UNDO tablespace.
• C. It permits DML on global temporary tables even if the database is opened read-only.
• D. It reduces I/Os to the SYSTEM tablespace.
• E. It reduces the amount of redo generated.

Answer: B,D,E

Explanation:
Temp UNDO, introduced in Oracle 12c and refined in 23ai, stores undo for global temporary tables (GTTs) in temporary tablespaces:
A . It permits DML on GTTs even if the database is opened read-only.False. In read-only mode, DML on GTTs is allowed regardless of temp UNDO, as GTT data is session-private, but temp UNDO doesn't specifically enable this.
B . It reduces the amount of UNDO stored in the UNDO tablespace.True. Temp UNDO stores undo in the temporary tablespace, reducing usage of the permanent UNDO tablespace.
C . It reduces I/Os to the SYSTEM tablespace.True. By avoiding permanent undo, it reduces metadata updates in the SYSTEM tablespace related to undo management.
D . It reduces the amount of redo generated.True. Temp UNDO changes are not redo-logged to the same extent as permanent undo, minimizing redo generation.
E . It reduces I/Os to the SYSAUX tablespace.False. SYSAUX is unrelated to undo management; temp UNDO affects temporary and SYSTEM tablespaces.

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

• A. Undo segments can extend when a transaction fills the last extent of the undo segment.
• B. Undo segments can be stored in the SYSTEM tablespace.
• C. A single transaction may use multiple undo segments simultaneously.
• D. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.
• E. Undo segments can be stored in the SYSAUX tablespace.

Answer: A,C

Explanation:
A .False. Undo is stored in a dedicated undo tablespace, not SYSTEM.
B .True. Large transactions can span multiple undo segments.
C .False. Undo isn't stored in SYSAUX.
D .True. Undo segments extend as needed, space permitting.
E .False. Undo doesn't "wrap"; new extents are allocated.

NEW QUESTION # 53
orcl.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle SCHEMAS=sh,oe REMAP_SCHEMA=sh:hr DUMPFILE=orcl.dmp EXCLUDE=index TABLE_EXISTS_ACTION=replace LOGFILE=impdp.log Which two statements are true?

• A. It skips only tables that exist in ORCL:SH and ORCL:OE.
• B. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
• C. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.
• D. It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.
• E. It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.

Answer: D,E

Explanation:
A .False. EXCLUDE=index skips all indexes, not re-creates them.
B .False. TABLE_EXISTS_ACTION=replace drops and re-creates tables.
C .True. EXCLUDE=index omits all indexes from import.
D .True. replace drops and re-creates existing tables.
E .False. Skips all indexes, not just overlapping ones.

NEW QUESTION # 54
What memory structure caches the data dictionary providing access to all database user processes?

• A. The Shared Pool
• B. The Streams Pool
• C. The Large Pool
• D. The Java Pool

Answer: A

Explanation:
D .True. The Shared Pool caches data dictionary metadata (e.g., table definitions) in the Library Cache and Dictionary Cache, accessible to all processes. Others serve different purposes (e.g., Large Pool for backups).

NEW QUESTION # 55
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 two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

• A. Analysis of privileges that a user has on their own schema objects.
• B. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.
• C. Analysis of all privileges used by the SYS user.
• D. Analysis of privileges that a user has on other schemas' objects.
• E. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

Answer: B,E

Explanation:
A .False. Limited to captured privileges, not all schema objects.
B .False. SYS is excluded from capture.
C .True. Captures indirect role privileges used.
D .True. Captures direct role privileges used.
E .False. Focus is on roles, not self-owned objects broadly.

NEW QUESTION # 56
Examine this command: ALTER DATABASE MOVE DATAFILE '\u01/sales1.dbf' TO '\u01/sales01.dbf' REUSE; Which two statements are true?

• A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
• B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• C. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• E. The file is renamed and stored in the same location.

Answer: A,E

Explanation:
This command moves/renames a data file online. Let's evaluate:
A . DML may be performed on tables with one or more extents in this data file during the execution of this command.
True. Introduced in 12c and refined in 23ai, MOVE DATAFILE is an online operation, allowing DML (e.g., INSERT, UPDATE) on tables within the file. Oracle ensures consistency via redo and undo.
Mechanics:The file is copied to the new location/name while tracking changes, then switched atomically.
Practical Use:Minimizes downtime in production systems.
B . If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
False. With OMF, omitting the TO clause would place the file in DB_CREATE_FILE_DEST, but here, TO '\u01/sales01.dbf' explicitly specifies the target, overriding OMF defaults.
Mechanics:OMF only applies if the destination is unspecified (e.g., MOVE DATAFILE ... without TO).
Why Incorrect:Explicit path trumps OMF behavior.
C . The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
False. READ ONLY isn't required; the operation is online and supports active use.
Why Incorrect:Conflicts with Oracle's online move feature.
D . The file is renamed and stored in the same location.
True. The command renames /u01/sales1.dbf to /u01/sales01.dbf (correcting \u01 to /u01 as a Windows/Unix typo), keeping it in /u01/. REUSE allows overwriting if sales01.dbf exists.
Mechanics:File is copied and renamed in-place within the same filesystem directory.
E . The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
False. Offline mode isn't needed; the online move handles activetablespaces.

NEW QUESTION # 57
Which two are benefits of external tables?

• A. They support UPDATEs, which transparently updates records in the file system as if they were table rows.
• B. They support DELETEs, which transparently deletes records in the file system as if they were table rows.
• C. They can be queried while the database is in the MOUNT state like dynamic performance views.
• D. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.
• E. They can be queried, transformed, and joined with other tables without having to load the data first.

Answer: D,E

Explanation:
A .False. External tables are read-only; no DELETE.
B .False. Require OPEN state, unlike V$ views.
C .False. No UPDATE support; read-only.
D .True. Queryable like regular tables without loading.
E .True. Data Pump can unload query results to files.

NEW QUESTION # 58
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. Connect Time Failover requires the connect string to have two or more listener addresses configured.
• C. Load Balancing requires the use of a name server.
• D. Source Routing requires the use of encrypted connections.
• E. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.

Answer: B,E

Explanation:
A .False. Connect Time Failover doesn't need TAF; TAF is for runtime failover.
B .False. Source Routing doesn't mandate encryption.
C .True. Needs multiple addresses (e.g., (ADDRESS_LIST=...)) for failover.
D .False. Load balancing works with tnsnames.ora, no name server required.
E .True. Balances connections across shared server dispatchers.

NEW QUESTION # 59
Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

• A. Uncommitted transactions are allowed to continue to the next ROLLBACK.
• B. Uncommitted transactions are allowed to continue to the next COMMIT.
• C. Sessions remain connected even if they are not running a transaction.
• D. New connection requests made to the database instance are refused.
• E. Instance recovery occurs automatically during the shutdown.

Answer: B,C,D

Explanation:
A .False. Recovery happens on startup, not shutdown.
B .False. TRANSACTIONAL waits for commits or rollbacks, then disconnects.
C .True. New connections are blocked during shutdown.
D .True. Inactive sessions persist until shutdown completes.
E .True. Active transactions can commit before disconnection.

NEW QUESTION # 60
Which two statements are true about Fine-Grained Auditing (FGA)?

• A. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.
• B. FGA policies by default can be created by a schema owner on an object in their schema.
• C. FGA policies can only be created by a user with SYSDBA privilege.
• D. FGA policies can be created by a user having the AUDIT_ADMIN privilege.
• E. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.

Answer: A,D

Explanation:
A .False. Schema owners need EXECUTE on DBMS_FGA.
B .False. Not limited to SYSDBA.
C .True. AUDIT_ADMIN includes FGA creation rights.
D .False. No such role exists.
E .True. DBMS_FGA.ADD_POLICY requires this privilege.

NEW QUESTION # 61
You start your database instance in NOMOUNT state. Which two actions are performed?

• A. Memory is allocated for the SGA.
• B. The control files are opened.
• C. The consistency of the database is checked.
• D. All required background processes are started.
• E. SYS can access the database.

Answer: A,D

Explanation:
A .True. Background processes (e.g., PMON) start.
B .False. Consistency checks require MOUNT.
C .False. Control files open in MOUNT.
D .True. SGA is allocated at startup.
E .False. SYS access requires OPEN.

NEW QUESTION # 62
Which three statements are true about resumable space allocation in Oracle databases?

• A. Resumable space allocation is only possible with locally managed tablespaces.
• B. Resumable space allocation may be enabled for some sessions and not others.
• C. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.
• D. All sessions must have the same timeout value when waiting for resumable space allocations.
• E. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
• F. A user's session may be suspended and resumed multiple times.

Answer: B,C,F

Explanation:
A .True. Enabled per session with ALTER SESSION ENABLE RESUMABLE.
B .True. Multiple suspensions can occur in one session.
C .False. Works with dictionary-managed tablespaces too.
D .False. Timeout is session-specific.
E .True. Privilege doesn't prevent suspension; quota limits do.
F .False. Triggers execute but can't suspend themselves.

NEW QUESTION # 63
Which two statements are true concerning logical and physical database structures?

• A. A segment might have only one extent.
• B. A segment's blocks can be of different sizes.
• C. All tablespaces may have one or more data files.
• D. A segment's blocks can be of different sizes.
• E. Segments can span multiple tablespaces.
• F. A segment can span multiple data files in some tablespaces.

Answer: A,F

Explanation:
False. All blocks in a segment use the tablespace's block size (e.g., 8KB). While a database can have tablespaces with different block sizes (e.g., 8KB, 32KB), a single segment's blocks are uniform, as it resides in one tablespace.
Explanation:
Logical structures (e.g., segments, extents) map to physical structures (e.g., data files, blocks). Let's dissect each option:
A : A segment can span multiple data files in some tablespaces.
True. A segment (e.g., a table or index) is a logical entity stored in a tablespace. In a smallfile tablespace (default in Oracle), a segment's extents can span multiple data files if the tablespace has multiple files and space allocation requires it. This is common in large tables or when autoextend adds new files.
Mechanics:Oracle allocates extents across available data files in a round-robin fashion (with ASSM) or as needed, ensuring the segment's data is distributed. This doesn't apply to bigfile tablespaces, which use a single data file.
Example:A 10GB table in a tablespace with two 5GB data files will span both.
B : Segments can span multiple tablespaces.
False. A segment is confined to a single tablespace. Oracle enforces this to maintain logical separation (e.g., a table's data stays in its assigned tablespace). Partitioned tables can have partitions in different tablespaces, but each partition is a separate segment.
Why Not:The segment header and extent map reside in one tablespace, preventing cross-tablespace spanning for a single segment.
C : A segment might have only one extent.
True. A segment starts with one extent upon creation (e.g., a small table or index). If no further growth occurs, it remains a single-extent segment. This is common with small objects or when INITIAL extent size suffices.
Mechanics:In locally managed tablespaces (default), the initial extent is allocated based on INITIAL or tablespace defaults (e.g., 64KB), and additional extents are added only as needed.
D : All tablespaces may have one or more data files.
False. Bigfile tablespaces are restricted to one data file (up to 128TB). Smallfile tablespaces (traditional) can have multiple data files (up to 1022), but the "all" phrasing makes this false due to bigfile exceptions.
Clarification:The question's intent may assume smallfile tablespaces, but Oracle 23ai supports both types.

NEW QUESTION # 64
Which three relationships between instances and Oracle databases are possible without using Multi-tenant?

• A. One instance on one server that has no database mounted.
• B. Two or more instances on separate servers all mounting and opening the same database.
• C. One instance on one server mounting and opening one database.
• D. One instance on one server mounting and opening multiple databases.
• E. One instance on one server mounting multiple databases.

Answer: A,B,C

Explanation:
A .False. One instance can't mount multiple DBs without multitenant.
B .True. RAC allows multiple instances to share one DB.
C .False. Same as A; not possible without CDB.
D .True. An instance can start in NOMOUNT with no DB.
E .True. Standard single-instance configuration.

NEW QUESTION # 65
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. Row pieces of a chained row must always reside in different blocks.
• D. Insert statements can result in a migrated row.
• E. Update statements can result in one or more chained rows.

Answer: A,B,E

Explanation:
A .True. Migration updates index ROWIDs.
B .True. Updates can migrate rows if space is insufficient.
C .True. Large updates can chain rows across blocks.
D .False. Chained rows may span blocks but aren't required to.
E .False. Inserts don't migrate; they chain if too large initially.

NEW QUESTION # 66
You execute the SHUTDOWN ABORT command. Which two statements are true?

• A. Data files are closed normally.
• B. Uncommitted transactions are not rolled back by the shutdown.
• C. A checkpoint is written.
• D. Subsequent instance startup performs instance recovery.
• E. Subsequent instance startup performs media recovery.

Answer: B,D

Explanation:
A .False. No checkpoint occurs with ABORT.
B .False. Instance recovery, not media recovery, is needed.
C .True. Crash recovery rolls back uncommitted changes on startup.
D .False. Files aren't closed cleanly with ABORT.
E .True. Shutdown doesn't roll back; recovery does.

NEW QUESTION # 67
Which statement is true about database links?

• A. A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data.
• B. A public database link can be created only by SYS.
• C. A database link can be created only between two Oracle databases.
• D. A public database link can be used by any user allowing remote database instance connection for selecting schema data.
• E. Private database link creation requires the same user to exist in both the local and the remote databases.

Answer: A

Explanation:
A .False. Links can connect to non-Oracle DBs via gateways.
B .False. No such user requirement; authentication is separate.
C .False. Any user with CREATE PUBLIC DATABASE LINK can create one.
D .True. Links enable remote schema access (e.g., SELECT * FROM emp@remote).
E .False. Public links allow access, but privileges on remote objects are needed.

NEW QUESTION # 68
What are the three components of Oracle Database Automatic Maintenance Tasks?

• A. A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.
• B. A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.
• C. Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.
• D. The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.
• E. A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.
• F. A packaging system that allows you to combine all error and failure logs to share with Oracle Support.

Answer: A,C,D

Explanation:
A .False. Diagnostic collection is ADR, not AMT.
B .True. Resource Manager allocates resources to AMTs.
C .True. Scheduler defines maintenance windows.
D .False. Packaging is IPS/ADR, not AMT.
E .False. Alert log is separate from AMTs.
F .True. Tasks like stats collection are AMTs.

NEW QUESTION # 69
Which statement is true about database links?

• A. A public database link can be created only by SYS.
• B. A database link can be created only between two Oracle databases.
• C. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
• D. Private database link creation requires the same user to exist in both the local and the remote databases.
• E. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

Answer: C

Explanation:
Database links enable cross-database queries in Oracle. Let's analyze each option with extensive detail:
A . A public database link can be created only by SYS.
False. Any user with the CREATE PUBLIC DATABASE LINK privilege (not just SYS) can create a public link (e.g., CREATE PUBLIC DATABASE LINK remote_db CONNECT TO scott IDENTIFIED BY tiger USING 'orcl'). While SYS typically has this privilege, it's not exclusive to SYS.
Mechanics:Privilege is granted via GRANT CREATE PUBLIC DATABASE LINK TO user;. Public links are accessible to all users in the local DB.
Why Incorrect:Overly restrictive; Oracle's security model allows delegation.
B . A database link can be created only between two Oracle databases.
False. Database links can connect to non-Oracle databases using Oracle Heterogeneous Services or gateways (e.g., ODBC or JDBC drivers), such as linking to SQL Server. Example: CREATE DATABASE LINK mssql_link USING 'hsodbc';.
Mechanics:Requires configuration of hs_ parameters in init.ora and a gateway listener.
Historical Note:Heterogeneous links were introduced in 8i, expanded in 23ai for cloud integration.
C . A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.
True. A database link is unidirectional; it enables queries from the local instance to the remote instance (e.g., SELECT * FROM emp@remote_db), but the remote instance can't use it to query back unless a separate link is created there.
Mechanics:Stored in DBA_DB_LINKS, the link defines a one-way connection via a TNS alias or connect string.
Practical Use:Ensures controlled access; bidirectional access requires explicit configuration.
Edge Case:Loops are prevented unless explicitly designed with mutual links.
D . A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
False. Public links allow all local users to use them, but access to remote schemas depends on the link's credentials (e.g., CONNECT TO scott) and the user's remote privileges. "Any schema" overstates it; access is limited to what the link's user can see.
Why Incorrect:Misrepresents privilege scope; remote schema access isn't universal.
E . Private database link creation requires the same user to exist in both the local and the remote databases.
False. A private link (e.g., CREATE DATABASE LINK my_linkCONNECT TO scott IDENTIFIED BY tiger USING 'orcl') requires the remote user (scott) to exist, but the local creator (e.g., HR) need not match. The link is owned locally and authenticated remotely.
Mechanics:Only the CREATE DATABASE LINK privilege is needed locally.

NEW QUESTION # 70
You execute this command: [oracle@host01 ~]$ expdp system/oracle FULL=Y DUMPFILE=exp_db_full.dmp PARALLEL=4 LOGFILE=exp_db_full.log JOB_NAME=exp_db_full. During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=IMMEDIATE. Are you sure you wish to stop the job ([yes]/no): yes. Which two statements are true about the job?

• A. You cannot monitor it.
• B. It continues to run in the background.
• C. It terminates.
• D. You can reattach to it and monitor it.

Answer: C,D

Explanation:
A .False. STOP_JOB=IMMEDIATE halts the job, not backgrounds it.
B .False. You can monitor before stopping or after restarting.
C .True. Before stopping, you can reattach with expdp attach=exp_db_full.
D .True. STOP_JOB=IMMEDIATE terminates the job instantly.

NEW QUESTION # 71
Which three statements are true about Oracle Managed Files (OMF)?

• A. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
• B. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.
• C. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.
• D. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
• E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.
• F. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.

Answer: D,E,F

Explanation:
A .True. Without DB_CREATE_ONLINE_LOG_DEST_n, redo logs and control files default to DB_RECOVERY_FILE_DEST.
B .False. If only DB_CREATE_FILE_DEST is set, redo logs and control files also use it unless overridden.
C .True. DB_CREATE_ONLINE_LOG_DEST_1 becomes the default for data files and temp files if DB_CREATE_FILE_DEST is unset.
D .True. DB_CREATE_FILE_DEST serves as the default for all file types if no log-specific parameter is set.
E .False. Data files and temp files would also use DB_CREATE_ONLINE_LOG_DEST_1 if no other parameter is specified.
F .False. No such requirement exists; DB_RECOVERY_FILE_DEST operates independently.

NEW QUESTION # 72
What services does the Automatic Workload Repository (AWR) provide for the database self-tuning functionality?

• A. Enables the creation of a Non-CDB from a CDB.
• B. Creates a new PDB with the original SID of the Non-CDB.
• C. Creates a new PDB by plugging in a previously unplugged Non-CDB.
• D. Simplifies the process of migrating Non-CDB databases to the cloud.

Answer: D

Explanation:
A .False. AWR doesn't create PDBs.
B .True. AWR stats aid migration planning (e.g., performance baselines).
C .False. AWR doesn't convert CDB to Non-CDB.
D .False. SID management isn't AWR's role.

NEW QUESTION # 73
......

1Z1-182 Exam Dumps, 1Z1-182 Practice Test Questions: https://www.practicetorrent.com/1Z1-182-practice-exam-torrent.html

Free 1Z1-182 Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=15E5c-16tuPzyjnYc0ZPEPSpVpWF6zdef