Oracle Database 23ai Administration Associate - 1Z1-182 Exam Practice Test

A. It creates new default schemas for the PDB. B. It creates a new local user ADMIN with SYSDBA privileges. C. It creates tablespaces to store metadata. D. It creates a new local user ADMIN with restricted privileges. E. The PDB must be opened Read Only to complete the integration of the PDB into the CDB. F. After the PDB is created, it is automatically opened Read/Write.

A. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used. B. It overwrites any existing file with the name sales02.dbf in /u02 by default. C. Tables with one or more extents in this data file may be queried during the execution of this command. D. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move. E. DML may be performed on tables with one or more extents in this data file during the execution of this command.

A. Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation. B. Oracle Database Metrics monitor performance using thresholds to generate alerts. C. Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events. D. Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts. E. Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

A. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR). B. Online index segment shrink. C. Oracle Managed Files (OMF). D. Online table segment shrink. E. Automatic data file extension (AUTOEXTEND).

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

A. It overwrites the data for Alan and adds data for Curl and Bob. B. It appends data from EMP.DAT to EMP. C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations. D. It generates a SQL script that it uses to load data from EMP.DAT to EMP. E. It overwrites all data in EMP with data from EMP.DAT.

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

A. 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. B. Private database link creation requires the same user to exist in both the local and the remote 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. A public database link can be created only by SYS. E. A database link can be created only between two Oracle databases.

A. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows. B. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures. C. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated. D. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot. E. Optimizer Statistics are collected by the Statistics Advisor.

A. The command fails because the script must refer to the full path name. B. The command fails and reports an error because @ is used twice. C. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed. D. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed. E. The command succeeds and HR will be connected to the orcl database and after logging out to the abc database.