If you are looking for free 1z0-083 dumps than here we have some sample question answers available. You can prepare from our Oracle 1z0-083 exam questions notes and prepare exam with this practice test. Check below our updated 1z0-083 exam dumps.
DumpsGroup are top class study material providers and our inclusive range of 1z0-083 Real exam questions would be your key to success in Oracle Oracle Database 19c Certification Exam in just first attempt. We have an excellent material covering almost all the topics of Oracle 1z0-083 exam. You can get this material in Oracle 1z0-083 PDF and 1z0-083 practice test engine formats designed similar to the Real Exam Questions. Free 1z0-083 questions answers and free Oracle 1z0-083 study material is available here to get an idea about the quality and accuracy of our study material.
Sample Question 4
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c
Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases
(PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these
commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $
sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID
CON_NAME OPEN MODE RESTRICTED -------------------------------------------------¬-------------
2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL>
ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered.
SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?
A. It fails because PDB$SEED is in MIGRATE state. B. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded. C. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded. D. It fails because PDB2 is not in UPGRADE state. E. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded. F. Only CDB$ROOT and PDB$SEED are upgraded.
Answer: D
Sample Question 5
choose three Identify three reasons for using a recovery catalog with Recovery Manager
(RMAN).
A. to allow database duplication without a connection to the target instance. B. to store backup metadata that would cause the controlfile to become too large. C. to store backups that would cause the controlfile to become too large. D. to report on the database schema at an earlier point in time. E. to allow database duplication without a connection to the auxiliary instance.
Answer: A,B,D
Sample Question 6
Choose the best answer. You want to transport the UNIVERSITY tablespace from one
database to another. The UNIVERSITY tablespace is currently open read/write. The source
and destination platforms have the same endian Examine this list of steps:. 1. Make the
UNIVERSITY tablespace read-only on the source 2. Export the UNIVERSITY tablespace
metadata using EXPDP. 3. Create a cross-platform backup set from the UNIVERSITY
source system, using an RMAN command that includes the DATAPUMP clause. 4. Copy
the cross-platform backup sets to the destination system. 5. Copy the Data Pump dump set
from the source to the destination system. 6. Restore the cross-platform backup set on the
destination system using an RMAN command that includes the DATAPUMP clause. 7.
Import the UNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITY
tablespace read/write on the destination system. Which are the minimum number of steps
required, in the correct order, to transport the UNIVERSITY tablespace?
A. 3,4,6 B. 2,3,4,5,6,7 C. 1,3,4,6,8 D. 1,2,3,4,5,6,7,8
Answer: A
Sample Question 7
choose three Which three RMAN persistent settings can be set explicitly?
A. SPFILE backup duplexing B. control file auto backup formats C. archive log deletion policy D. image copy duplexing E. redo log backup duplexing F. archive log backup duplexing
Answer: B,C,F
Sample Question 8
Choose three. Which three are true about Oracle Grid Infrastructure for a Standalone
Server?
A. It requires Oracle ASMLib to manage Automatic Storage Management (ASM) disks. C,D B. It creates one disk group during installation. C. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software. D. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner. E. It requires Oracle ASM Fitter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks. F. It requires the operating system ORACLE_BASE environment variable to be predefined before installation.
Answer: B,
Sample Question 9
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup
istaking too long and suspect a performance bottleneck. Which three are true about
diagnosing and tuning these problems? (Choose three.)
A. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks. B. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O. C. If an RMAN BACKUP VALIDATE command takes noticeably lessthan an actual backup, then write I/O is a likely bottleneck. D. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck. E. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used. F. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/ G. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
Answer: B,C,E
Sample Question 10
Choose two. Which two are true about the SQL Tuning Advisor?
A. It can recommend semantic changes to SQL statements. B. It prevents performance regressions for SQL statements when changes are made. C. It checks each query being analyzed for missing or stale statistics. D. It considers all SQL statements being analyzed by the advisor task as a group. E. It only recommends syntactic changes to SQL statements.
Answer: A,C
Sample Question 11
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
A. A base recovery catalog should exist. B. The owner of VPC cannot own recovery catalog. C. At least one target database should be registered in the recovery catalog. D. The register database privilege should be granted to the virtual catalog owner. E. The recovery_catalog_owner role should be granted to the virtual catalog owner.
Answer: A,B,D
Sample Question 12
Choose the best answer. Which statement correctly describes the SQL profiling performed
by the SQL Tuning Advisor?
A. It is a set of recommendations by the optimizer to change the access methods used. B. It is auxiliary information collected by the optimizer for a SQL statement to eliminat estimation error. C. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid
suboptimal execution plans. D. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders. E. It is a set of recommendations by the optimizer to create new indexes.
Answer: A
Sample Question 13
You notice a performance change in your production Oracle 12c database. You want to
know which change caused this performance difference. Which method or feature should
you use?
A. Compare Period ADDM report B. AWR Compare Period report C. Active Session History (ASH) report D. Taking a new snapshot and comparing it with a preserved snapshot.
Answer: B
Sample Question 14
Choose two. Which two are true about monitoring waits for sessions and services?
A. V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred. B. V$SESSION_WAIT and V$SESSION both contain details of the event on which a nonwaiting session last waited. C. V$SESSION_WAIT and V$SESSION both contain details of the event on which a waiting session is currently waiting. D. V$SESSION_EVENT displays all waits events for those events that have occurred at least once for sessions that have now terminated. E. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for
terminated sessions.
Answer: A,C
Sample Question 15
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.
APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in
APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus
sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database;
CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1
NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session
altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER
SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE
app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL>
ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL>
FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete.
Which table or set of tables will exist after the Flashback operation has completed?
A. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB B. CDB1_TAB and APP_PDB1_TAB C. CDB1_TAB and APP_ROOT_TAB D. CDB1_TAB only E. none of the tables, because all three tables will be dropped
Answer: B
Sample Question 16
Choose the best answer. How do you configure a CDB for local undo mode?
A. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance. B. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance. C. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance. D. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance. E. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
Answer: B
Sample Question 17
Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?
A. TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN
only. B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker. C. The C # # A_ADMIN user can perform wallet operations. D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM). E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
Answer: B,D,E
Sample Question 18
choose three Which three are true about unified auditing in full mode?
A. The unified audit trail is written to a read-only table. B. The unified audit trail is written to a read-only external file. C. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements. D. Audit records are created for SYS. E. Audit records are created for non-sys users.
Answer: A,D,E
Sample Question 19
Your production database is running in archivelog mode. You use RMAN with a recovery
catalog to back up your database to media and the database is uniquely identified in the
recovery catalog. You want to create a test database from the production database and
allow the production database to remain open during the duplicate process. You restore the
database backups to a new host with the same directory structure as the production
database and want to use the recovery catalog for future backups after the database is
successfully restored to the new host. How would you achieve this?
A. by using the RMAN switch command to set the new location for the data files B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host C. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host D. by creating a new database in the new host, and then using the RMAN recover command
Answer: B
Sample Question 20
Choose two. Which two are true about PDB archive files?
A. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive. B. They contain a PDB manifest file and all the data files in uncompressed form for a PDB. C. They contain all the data files only in uncompressed form for a PDB. D. They must be created using the DBMS_PDB package. E. They contain a PDB manifest file and all the data files in compressed form for a PDB. F. They contain all the data files only in compressed form for a PDB.
Answer: A,E
Sample Question 21
choose two You take your database backups by using the RMAN media management
interface (MMI). Which two are true about the use of the RMAN MMI?
A. You can B. You can C. You can D. You can E. You can
Answer: B,E
Sample Question 22
In one of your databases, unified auditing is enabled and an SH.SALES table exists. You
successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol
ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true
about SALES_POL?
A. It is enabled for all users having SELECT privilege on SH.SALES. B. Only successful queries of SH.SALES are written to the audit trail. C. It is only enabled for user SH. D. Audit records are always stored in an external audit file.
Answer: A
Sample Question 23
You plan to create a database by using the Database Configuration Assistant (DBCA), with
t he following specifications: Applications will connect to the database via a middle tier. The
number of concurrent user connections will be high. The database will have mixed
workload, with t he execution of complex BI queries scheduled at night. Which DBCA
option must you choose to create the database?
A. a General Purpose database template with default memory allocation B. a Data Warehouse database template, with t he dedicated server mode option and AMM enabled C. a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled D. a default database configuration
Answer: C
Sample Question 24
Choose three. Which three are true about corrupted data blocks and their recovery in an
Oracle Database?
A. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt. B. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption. C. A media corrupt block is one where the block is not formatted correctly. D. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it. E. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt. F. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.
Answer: D,E,F
Sample Question 25
Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a
TARGET connection?
A. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed. B. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance. C. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance. D. The UNDO TABLESPACE clause is never required. E. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
Answer: A,B
Sample Question 26
Choose two. Which two are true about a read-only Oracle home?
A. It is enabled by performing a software-only Oracle Database installation and then running the roohctl ¬enable script. B. It requires the Rapid Home Provisioning service. C. Its configuration data and log files reside in subdirectories under the Oracle home. D. It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script. E. It contains an image that can be distributed across multiple servers.
Answer: A,E
Sample Question 27
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a
"CREATE DATABASE" statement?
A. It will create a multitenant container database (CDB) with only the root opened. B. ItwillcreateaCDBwithrootopenedandseedreadonly. C. It will create a CDB with root and seed opened and one PDB mounted. D. It will create a CDB that must be plugged into an existing CDB. E. ItwillcreateaCDBwithrootopenedandseedmounted.
Answer: B
Sample Question 28
Choose three. Which three actions are mandatory post database upgrade?
A. Updating client scripts with the new Oracle home. B. Resetting passwords to enforce case-sensitivity. C. Run OPatch commands from the new Oracle home. D. Setting threshold values for tablespace alerts. E. Migration to unified auditing. F. Upgrading user tables that depend on Oracle-maintained abstract data types.
Answer: A,C,F
Sample Question 29
Choose two. RMAN has just been connected to a target database and the recovery catalog
database. In which two cases would an automatic full resynchronization occur between this
target database's control file and the RMAN recovery catalog?
A. when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME B. when a new tablespace is added to a registered target database C. when a backup of the current control file is created D. when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME E. when the target is first registered
Answer: B,E
Sample Question 30
Choose the best answer. Examine this output of an export from the current release of an
Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select
name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------
PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you
execute: $ expdp system/oracle full=y What is the outcome?
A. It fails because Data Pump cannot be container. B. It creates a full export of the root C. It creates a full export of the root D. It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.
Answer: A
Sample Question 31
Choose three. Which three are true about Data Pump in an Oracle multitenant
environment?
A. It can be used to transport data from a non-CDB to a PDB. B. It can be used to clone a CDB. C. It can be used to transport data between PDBs. D. It can be used to transport data from a PDB to a non-CDB. E. It can be used to create a new PDB.
Answer: A,C,D
Sample Question 32
Choose the best answer. Which should be tuned first when doing a performance tuning
exercise for an Oracle Database environment?
A. log writer performance B. database writer performance C. general operating system health D. SQL statements E. database instance memory management and sizes
Answer: E
Sample Question 33
The persistent configuration settings for RMAN have default for all parameters. Identify four
RMAN commands that produce a multi-section backup.
A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M; D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M; E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M; F. BACKUP SPFILE SECTION SIZE 1M; G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
Answer: A,B,C,G
Sample Question 34
Choose two You upgrade your database from pre-12c to a multitenant container database
(CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL>
SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA
SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS
TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add
users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?
A. Re-create or migrate the password file to the Oracle Database 12c format B. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. C. Copy the password file from a sample file in the DBS dierectory D. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
Answer: A,B
Sample Question 35
Which two statements are true about the Database Configuration Assistant (DBCA)?
A. It can configure Automatic Storage Management (ASM) diskgroups. B. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host. C. It can be used to add a new tablespace. D. It can be used to create a database template from an existing database. E. It can generate SQL database creation scripts.
Answer: D,E
Sample Question 36
Choose the best answer. Which operating system group is NOT needed to perform an
Oracle Database installation?
A. OSASM B. OSRACDBA C. OSKMDBA D. OSDBA EOSOPER
Answer: B
Sample Question 37
Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using
Oracle Universal Installer (OUI). There is no existing Oracle installation on the server.
Which two are prerequisites?
A. an operating system user to own this installation B. the Oracle Inventory group oinstall C. an operating system account called grid D. a group called dba E. the installation of Oracle ASMLIB
Answer: A,B
Sample Question 38
Which two statements are true about Resource Manager plans for individual pluggable
databases (PDB plans) in a multitenant container database (CDB)?
A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB. B. In a PDB plan, subplans may be used with up to eight consumer groups. C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB. D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated. E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
Answer: A,E
Sample Question 39
Identify three benefits of Unified Auditing.
A. Decreased use ofstorage to store audit trail rowsin the database. B. It improves overall auditing performance. C. It guarantees zero-loss auditing. D. The audit trail cannot be easily modified because it is read-only. E. It automatically audits Recovery Manager (RMAN) events.
Answer: B,D,E
Sample Question 40
Choose four. Which four are true about performing Tablespace Point-In-Time Recovery
(TSPITR) using Recovery Manager (RMAN)?
A. It can be performed using an auxiliary instance managed by RMAN. B. It can be performed using an auxiliary instance managed by a DBA. C. It can be used to recover a truncated table. D. It can be performed repeatedly until the correct time is found without using an RMAN catalog. E)RMAN always includes tablespaces containing UNDO segments in the recovery set. E. RMAN automatically adds any required tablespaces to the recovery set to make it selfcontained. G) FLASHBACK DATABASE must be enabled for it to work. H) It can be used to recover a dropped tablespace.
Answer: A,C
Sample Question 41
Choose three. Which three are true about upgrading an application in an application
container?
A. An application root clone gets created automatically. B. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED. C. After an application upgrade, the application container's PDBs remain synchronized with the existing application root. D. The upgrade must be performed when connected to CDB$ROOT. E. An application name and version number must be specified to upgrade the application. F. After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.
Answer: A,E,F
Sample Question 42
Examine this configuration: While CDB1 is open,
‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl’is accidentally deleted. To
recover from this critical failure, you execute these commands:
What will be the outcome?
A. It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’ B. It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’. C. It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’ D. It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’. E. It will fail because there is no autobackup of the controlfiles.
Answer: C
Sample Question 43
Choose two. Which two are true about Lockdown profiles in a container database (CDB)
and its pluggable databases (PDBs)?
A. A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified. B. A PDB Lockdown profile can be created in an application root. C. A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified. D. A PDB Lockdown profile can be created in a regular PDB. E. A PDB Lockdown profile can be created in CDB$ROOT .
Answer: B,E
Sample Question 44
Choose three. Which three are true about Oracle pluggable databases (PDBs)?
A. A PDB can be plugged into a CDB only if both are of the same Oracle Database release. B. An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files. C. A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas. D. A non-CDB can be converted into a PDB. E. A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs. F. A PDB created from PDB$SEED must be set to READ WRITE after loading data. G. A PDB created from PDB$SEED must be set to READ ONLY after loading data.
Answer: C,D,E
Sample Question 45
Choose two. Which two are true about backup encryption?
A. The Transparent Data Encryption (TDE) keystore is backed up using RMAN. B. Vendor-specific media management software can be used for making encrypted RMAN backups to media. C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets. D. Image copies can be encrypted. E. Keystore-based encryption is the default mode for RMAN backup encryption. F. Backup encryption can be enabled selectively for specific tablespaces.
Answer: C,E
Sample Question 46
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a
remote pluggable database (PDB) starting from Oracle 19c?
A. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned B. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned C. backing up tD. opening the cloned PDB E. leaving the cloned PDB in mount state Answer: A,D he cloned PDB D. opening the cloned PDB E. leaving the cloned PDB in mount state