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.
Which two are true about various Oracle security and auditing capabilities? (Choose two).
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.
Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?
A. A PDB snapshot depends on an existing storage snapshot of the source PDB.
B. A PDB snapshot can be a full copy of a source PDB.
C. A PDB snapshot can be a sparse copy of a source PDB
D. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
E. A snapshot copy PDB can be created from a stand-alone clone PDB.
Examine this command: $ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path
For which two purposes can you use this command? (Choose two).
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
Examine these 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.
B. It fails because no parallel channels are allocated for the auxiliary database.
C. It fails because connection to the AUXILIARY instance must be as SYSDBA.
D. It succeeds only if the target database is greater than 400M.
E. No catalogued backup of the TARGET is used to duplicate the database.
Some archived log backups have been accidentally deleted from storage.
Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups? (Choose two).
A. RESYNC CATALOG
B. CROSSCHECK BACKUP OF ARCHIVELOG ALL
C. LIST ARCHIVELOG ALL
D. LIST EXPIRED
E. LIST ARCHIVELOG
F. REPORT OBSOLETE
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;
Which three are true about Transparent Data Encryption (TDE)? (Choose three)
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.
Which two are true about PDB archive files? (Choose two).
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.
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. It will create a CDB with root opened and seed read only.
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. It will create a CDB with root opened and seed mounted.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-083 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.