Make success possible with our Latest and Unique Oracle Database 19c 1z0-083 Practice Exam!
Name: Oracle Database Administration II
Exam Code: 1z0-083
Certification: Oracle Database 19c
Vendor: Oracle
Total Questions: 286
Last Updated: December 02, 2025
276 Satisfied Customers
Success is simply the result of the efforts you put into the preparation. We at Dumpsgroup wish to make that preparation a lot easier. The Oracle Database Administration II 1z0-083 Practice Exam we offer is solely for best results. Our IT experts put in their blood and sweat into carefully selecting and compiling these unique Practice Questions. So, you can achieve your dreams of becoming a Oracle Database 19c professional. Now is the time to press that big buy button and take the first step to a better and brighter future.
Passing the Oracle 1z0-083 exam is simpler if you have globally valid resources and Dumpsgroup provides you just that. Millions of customers come to us daily, leaving the platform happy and satisfied. Because we aim to provide you with Oracle Database 19c Practice Questions aligned with the latest patterns of the Oracle Database Administration II Exam. And not just that, our reliable customer services are 24 hours at your beck and call to support you in every way necessary. Order now to see the 1z0-083 Exam results you always desired.
You must have heard about candidates failing in a large quantity and perhaps tried yourself and fail to pass Oracle Database Administration II. It is best to try Dumpsgroup’s 1z0-083 Practice Questions this time around. Dumpsgroup not only provides an authentic, valid, and accurate resource for your preparation. They simplified the training by dividing it into two different formats for ease and comfort. Now you can get the Oracle 1z0-083 in both PDF and Online Test Engine formats. Choose whichever or both to start your Oracle Database 19c certification exam preparation.
Furthermore, Dumpsgroup gives a hefty percentage off on these Spoto 1z0-083 Practice Exam by applying a simple discount code; when the actual price is already so cheap. The updates for the first three months, from the date of your purchase, are FREE. Our esteemed customers cannot stop singing praises of our Oracle 1z0-083 Practice Questions. That is because we offer only the questions with the highest possibility of appearing in the actual exam. Download the free demo and see for yourself.
We know you have been struggling to compete with your colleagues in your workplace. That is why we provide the 1z0-083 Practice Questions to let you gain the upper hand that you always wanted. These questions and answers are a thorough guide in a simple and exam-like format! That makes understanding and excelling in your field way lot easier. Our aim is not just to help to pass the Oracle Database 19c Exam but to make a Oracle professional out of you. For that purpose, our 1z0-083 Practice Exams are the best choice.
There are many resources available online for the preparation of the Oracle Database Administration II Exam. But that does mean that all of them are reliable. When your future as a Oracle Database 19c certified is at risk, you have got to think twice while choosing Oracle 1z0-083 Practice Questions. Dumpsgroup is not only a verified source of training material but has been in this business for years. In those years, we researched on 1z0-083 Practice Exam and came up with the best solution. So, you can trust that we know what we are doing. Moreover, we have joined hands with Oracle experts and professionals who are exceptional in their skills. And these experts approved our 1z0-083 Practice Questions for Oracle Database Administration II preparation.
Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these commands successfully: Which two are true? (Choose two.)
A. Uncommitted transactions in PDB1 have been rolled back.
B. PDB1 is closed.
C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
D. CDB1 is shut down.
E. CDB1 is in MOUNT state
ANSWER : A,B
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
A. Reduced logical I/O
B. Reduced virtual memory utilization
C. Improved Serial Execution performance
D. Reduced physical I/O
E. Reduced CPU utilization
ANSWER : B,E
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps: Install the SALES_APP application, induding the common tables, in the application root. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. Create an application seed. Install the SALES_APP application in the application seed. Create the SALES_APP1 and SALES_APP2 application PDBs. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed. Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?
A. 1,3,5,7
B. 2,5,6
C. 1,5,6
D. 3,4,1.6,8
E. 1,3,5,6,7
ANSWER : C
.Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?
A. The password for the encryption must be set up.
B. Oracle wallet for the encryption must be set up.
C. All the tablespaces in the database must be encrypted
D. Oracle Database Vault must be enabled.
ANSWER : B
RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?
A. RMAN uses the pull method to restore files using image copies
B. RMAN uses the push method to transfer image copies
C. RMAN uses the push method to transfer backup sets
D. RMAN uses the pull method to restore files using backup sets
ANSWER : D
choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?
A. user-managed backups of data files and control files
B. flashback logs
C. RMAN backups that are obsolete
D. archived redo log files that have multiple copies in a different archive location
ANSWER : B,C
Which three statements are true about the keystore storage framework for transparent data encryption?
A. It facilitates and helps to enforce keystore backup requirements.
B. It handles encrypted data without modifying applications.
C. It enables a keystore to be stored only in a file on a file system.
D. It enables separation of duties between the database administrator and the security administrator.
E. It transparently decrypts data for the database users and applications that access this data.
F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
ANSWER : A,D,F
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?
A. The statistics_level parameter is set to all when any of the PDBs is reopened.
B. The statistics_level parameter is set to all only for PDB2 when it is reopened.
C. The statistics_level parameter is set to all when the root database is restarted.
D. The statement is ignored because there is no SPFILE for a PDB.
ANSWER : B
Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?
A. Plugging the application root into a different CDB plugs in all its application PDBs.
B. The application root of an application container should be plugged into the other CDB before its application PDBs are plugged in.
C. Application PDBs in the application container must be unplugged before the application root is unplugged.
D. Unplugging the application root from a CDB unplugs all its application PDBs.
E. It requires only local UNDO mode in the database where the application container will be unplugged.
F. It requires local UNDO mode in both container databases.
ANSWER : B,C
Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?
A. all backups prior to 10th of August
B. all backups prior to 22nd of August
C. all backups prior to 20th of August
D. all backups prior to 24th of August
E. all backups prior to 17th of August
ANSWER : E
Choose three. Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?
A. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
B. It can be used to deploy Oracle Database homes.
C. It is an Oracle Database service.
D. It cannot be used to provision applications.
E. It cannot be used to provision middleware.
F. It is an Oracle Grid Infrastructure service.
ANSWER : A,B,F
Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)
A. It is used to change failure priority only for HIGH or LOW priorities.
B. It is used to execute the advised repair script.
C. It is used to change failure priority only for the CRITICAL priority.
D. It is used to explicitly close the open failures.
E. It is used to inform the database about the repair after the repair script executes.
ANSWER : A,D
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
A. when the duplicate ... from active database command contains the section size clause
B. when you perform active database duplication on a database with flashback disabled
C. when you specify set encryption before the duplicate ... from active database command
D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
E. when you perform active database duplication on a database that has readonly tablespaces
ANSWER : A,C,D
choose three You want to duplicate one of your databases when connected to the target database and to the recovery catalog. Which three are true about this type of database duplication ) The duplication process can create backup sets or image copies
A. The target database must be open
B. The duplication process can use existing backup sets or image copies
C. The duplication process can use existing backup sets or image copies.
D. The target database must be in mount state.
E. The duplication -process pushes backup sets to the auxiliary instance.
F. The duplication process pushes image copies to the auxiliary instance.
ANSWER : A,C,F
choose three Which three are true about Transparent Data Encryption (TDE)?
A. It uses a single master key for a database.
B. It replaces secure application roles.
C. It encrypts only data on the client.
D. It stores the current and all past master keys in the keystore.
E. Master encryption keys are managed by Oracle Database Vault.
F. It can encrypt data at the column level.
ANSWER : D,E,F
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
A. It is integrated with the SQL Access Advisor.
B. It predicts the impact of system changes on SQL workload response time.
C. It provides before and after execution statistics for each SQL statement in the analysis task
D. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
E. SQL statements that were originally run concurrently are run concurrently by SPA.
ANSWER : B,C
Choose two. Which two statements are true when row-archival management is enabled?
A. The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.
B. The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query
C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.
D. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.
E. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.
ANSWER : B,C
Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?
A. redo logs
B. control files
C. all data dictionary metadata
D. user-defined PL/SQL packages
E. temporary tablespaces
F. mandatory Oracle-supplied PL/SQL packages
G. undo tablespaces
ANSWER : A,B,C
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
A. Decreasing PCTUSED
B. Decreasing PCTFREE
C. Increasing the number of DBWN process
D. Using Automatic Segment Space Management (ASSM)
E. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
ANSWER : D
Choose two. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 . CDB1 user SYS executes these commands after connecting successfully to PDB2: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)
A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
B. The inserts on USER1.EMP were committed when the session inserted a row into USER2. DEPT.
C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
E. The inserts on USER1.EMP were rolled back when the session connected to PDB2
F. The insert on USER2.DEPT is uncommitted.
G. The inserts on USER1.EMP were committed when the session connected to PDB2.
ANSWER : A,C
Which two are true about the Oracle database methodology? (Choose two.)
A. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
B. Tuning activities should stop once the user is satisfied with performance.
C. Tuning activities should stop once agreed service levels for performance have been met.
D. The database instance memory should always be tuned before tuning any file systems.
E. SQL statements should always be tuned before tuning any file systems.
F. The alert log should be used to find the database and instance areas most in need of tuning.
ANSWER : A,E
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?
A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
E. Re-createthepasswordfileintheOracleDatabase12cformat. Correct
ANSWER : B,D
Examine the statements that use flashback technologies: FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS'); SELECT * FROM customers AS OF SCN 123456; FLASHBACK TABLE customers TO BEFORE DROP; FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?
A. 1,3,6
B. 1,2,5
C. 3,4,5
D. 2,3,5,6
ANSWER : B
Choose two. Which two are true about various Oracle security and auditing capabilities?
A. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.
B. Application-common TSDP policies are always container specific.
C. Application-common OLS policies can be created only if all the PDBs in the application container are closed.
D. Unified auditing can be automatically synchronized to all application PDBs in an application container.
E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.
ANSWER : D,E
Choose the best answer. A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?
A. FLASHBACK DATABASE
B. FLASHBACK TABLE
C. FLASHBACK VERSION QUERY
D. FLASHBACK DATA ARCHIVE
E. FLASHBACK TRANSACTION
ANSWER : A
choose two Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TCddb PLUGGABLE DATABASE pdbl,pdb5; Which two statements are true about the DUPLICATE command?
A. The root and the seed database in the container database (CDB) are also duplicated.
B. A backup of PDB1 and PDB5 must exist before executing the command.
C. The SPFILE is copied along with the data files of the pluggable databases (PDBs).
D. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. E) The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.
ANSWER : A,D
Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?
A. FULL redaction is active on the SAL column
B. RANDOM redaction is active on the MGR column
C. RANDOM redaction is active on the HIREDATE column
D. PARTIAL redaction is active on the MGR column.
E. PARTIAL redaction is active of the HIREDATE column.
ANSWER : C
Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?
A. he SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
B. A backup of pdb1 and pdb5 must exist before executing the command.
C. The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.
D. A backup of CDB and pdb1 and pdb5 must exist before executing the command.
E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
ANSWER : C,E
Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?
A. Tune individual SQL statements using the SQL Tuning Advisor.
B. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
C. Test the application as a whole using tuned SQL statements.
D. Test tuned SQL statements one at a time for all statements in the application.
E. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
F. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
ANSWER : A,B,C
Which two statements are true about RMAN duplexed backups?
A. It is not supported for image copies.
B. It is only supported for backups to tape via the media management interface.
C. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
D. Duplex backups can contain only data files and control files.
E. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
ANSWER : A,C
Choose three. Which three are true about Oracle Restart?
A. It is used in both clustered and non-clustered environments.
B. You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands.
C. It runs from the Oracle Grid Infrastructure home.
D. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.
E. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.
F. It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances.
ANSWER : A,B,F
Choose two. Examine this command: $ rhpctl move database -sourcehome Oracle_home_path ¬destinationhome Oracle_home_path For which two purposes can you use this command?
A. to switch to a patched Oracle Database home
B. to upgrade an Oracle Database on the centralized Rapid Home Provisioning server
C. to move an Oracle Database to the centralized Rapid Home Provisioning server
D. to switch back to the previous Oracle home as part of a rollback operation
E. to switch to a read-only Oracle home
ANSWER : A,B
Choose two. Which two are true about memory advisors?
A. If Automatic Memory Management is enabled, no memory advisors are available.
B. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.
C. All memory advisors use data from Automatic Workload Repository.
D. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
E. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
ANSWER : C,D
Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?
A. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
B. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new
ORACLE_HOME.
C. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
D. The new extended data type capability must be enabled by running the utlrp.sql script
E. The Oracle Application Express configuration should be updated after upgrading Oracle Database.
ANSWER : A,D,E
choose one .Examine the RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which statement is true about the DUPLICATE command?
A. It succeeds and creates multisection backup sets that are used for active database duplication.
B. It fails because there is no connection to a recovery catalog.
C. It succeeds only if the target database is in MOUNT state.
D. It fails because no parallel channels are allocated for the auxiliary database.
ANSWER : A
Choose two. Which two are true about the Optimizer Statistics Advisor?
A. It always analyzes all schemas in the database.
B. It can recommend changes to improve the statistics gathering process.
C. It can be run only manually.
D. It runs automatically every night by default. E) It can be run only automatically.
ANSWER : B,D
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?
A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
B. Settingthetargettablespacetoread-only
C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED D. Setting the target tablespace offline
E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
ANSWER : B,C
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
Choose three. Which three are true about a container database (CDB)?
A. It can be created from a non-CDB.
B. It can contain only one PDB$SEED, which is created when the CDB is created.
C. It can have local users with the same name in different PDBs.
D. It can contain only one Application Container seed, which is created when the Application Container is created.
E. It can be created by cloning an existing CDB.
F. It can have any number of pluggable databases (PDBs) limited only by space availability.
G. It contains predefined common roles in both the root and the seed.
ANSWER : B,E,G
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
ANSWER : A,D
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
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
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
Dumpsgroup is a verified platform for certification preparation. Our expert professionals are working day and night to create the perfect Practice Exam so you can pass your exam with flying colors. We provide only the authentic and valid Practice Questions approved by IT Experts. Start your certification journey now!
www.dumpsgroup.com
support@dumpsgroup.com
1104 Long Street, NY, 11206, USA
Feel free to contact us, we are available 24/7.