Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)
A. ADDM can run in a nonroot container.
B. AWR snapshots can be created in CDB$ROOT.
C. AWR reports can be generated while connected to any container.
D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
E. AWR snapshots can be created in a PDB.
F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.
Examine this configuration:
1.
CDB1 is a container database.
2.
COMMON_USER_PREFIX is set to an empty string.
3.
PDB1 is a pluggable database in CDB1.
4.
APP1_ROOT is an application container in CDB1.
5.
APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
What is true?
A. It will return an error because creation of a local role is not allowed in CDB$ROOT.
B. ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
C. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
D. ROLE1 will be created only in CDB$ROOT.
E. It will return an error because common roles must start with C##.
Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
A. It is a set of recommendations by the optimizer to create new indexes.
B. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
C. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
D. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
E. It is a set of recommendations by the optimizer to change the access methods used.
Which three are true about the FLASHBACK DATABASE feature? (Choose three.)
A. FLASHBACK LOGS are archived after a log switch.
B. A database can be flashed back using SQL*PLUS.
C. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
E. It always generates REDO and UNDO.
F. It requires that the target database be in ARCHIVELOG mode.
Which three are true about patchsets? (Choose three.)
A. They can be applied in a rolling fashion for Clusterware and the databases.
B. They can introduce new features.
C. They are installed via OPatch or OPatchAuto.
D. Installing a patchset is considered an "upgrade".
E. They are only released quarterly.
F. A base release is not needed to install patchsets.
Which two are true about backup set compression using RMAN default compression? (Choose two.)
A. Compressed backups can be written only to media.
B. Binary compression adds CPU overhead to backup operations.
C. Unused blocks below the high water mark are backed up.
D. Compressed backups cannot have a section size defined.
E. Compression can be done only for locally managed tablespaces.
Which two are true about memory advisors? (Choose two.)
A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
B. If Automatic Memory Management is enabled, no memory advisors are available.
C. All memory advisors use data from Automatic Workload Repository.
D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
E. 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.
Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)
A. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
B. The SPFILE is included in the archival backup.
C. They are never considered obsolete by RMAN.
D. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.
E. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
F. They can optionally be written to a fast recovery area (FRA).
G. Use of a recovery catalog is always required to support the creation and use of archival backups.
Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';
Which three are true about PDB1? (Choose three.)
A. Service PDB1 is created for remote logins to PDB1.
B. It is in mount state after creation.
C. It has no local users.
D. It has the same number of roles as CDB1.
E. It has the same common users defined as does CDB1.
F. It has only local roles.
Examine this configuration:
1.
CDB1 and CDB2 are two container databases.
2.
PDB1 is a pluggable database in CDB1.
3.
PDB1_C1_SRV is a service for PDB1.
4.
CDB1_LINK is a database link in CDB2 referring to PDB1.
5.
CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV'); Which two are true? (Choose two.)
A. PDB1 will be created in CDB2 and automatically opened.
B. PDB1 will be created in CDB2 and left in MOUNT state.
C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D. PDB1_C2_SRV will be created and started automatically.
E. PDB1_C2_SRV will be created but not started.
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.