Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 191:

  Examine these queries and their output:

  

  An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created.

  You want to recover PDB1 to Restore Point R1.

  How do you achieve this?

  A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

  B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

  C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

  D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

  E. This cannot be done due to the lack of a clean restore point.

  Correct Answer: D

  In 19c, you can actually flashback a PDB from a restore point even if it's not clean:

  When using restore points, you can perform a flashback database operation either to a CDB restore point, PDB restore point, PDB clean restore point, or PDB guaranteed restore point.

  https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394

• Question 192:

  The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.

  Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

  A. Backups must be done incrementally.

  B. Backups must be contained in backup sets.

  C. Backups can be taken only if the database is in ARCHIVELOG mode.

  D. Backups can be done incrementally.

  E. The database must be registered in an RMAN catalog.

  F. Only consistent backups can be created.

  Correct Answer: CD

  A good example of how Oracle mixes up CAN/MUST to confuse us, in tests, as all answers sound correct!

  A - FALSE. It CAN be done incrementally, not MUST B - FALSE. They CAN be contained in backup sets, not MUST C - TRUE. By definition, you can only take online backups in ARCHIVELOG mode D - TRUE. Yes, they CAN be done incrementally. They don't have to be. E - FALSE. You CAN register in an RMAN catalog, you don't have to F - FALSE. An online backup is INCONSISTENT.

• Question 193:

  Which four are true about RMAN backup sets? (Choose four.)

  A. A backup piece can belong to only one backup set.

  B. A data file can be split into multiple sections stored in different backup sets.

  C. A data file can be split into multiple sections stored in different backup pieces in the same backup set.

  D. Blocks from multiple data files can be contained in one backup piece,

  E. A backup set can contain only one backup piece.

  F. A backup set must be written to media.

  G. A backup set must be written to disk.

  H. Blocks from multiple data files can be contained in one backup set,

  Correct Answer: ACEH

  I believe alternative D is wrong due to the term "blocks of multiple datafiles".

  A backup set can contain multiple data files. For example, you can back up 10 data files into a single backup set consisting of a single backup piece. In this case, RMAN creates one backup piece as output. The backup set contains only this

  backup piece.

  If you specify the SECTION SIZE parameter on the BACKUP command, then RMAN produces a multisection backup. This is a backup of a single large file, produced by multiple channels in parallel, each of which produces one backup piece.

  Each backup piece contains one file section of the file being backed up.

• Question 194:

  Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

  A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

  B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

  C. SPFILE backups can be created while connected to an application root PDB.

  D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

  E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

  Correct Answer: BE

  E is correct

  tested: backup pluggable database "cdb$root". the quotes due to the $ symbol. it backups only the root container files (no pdb datafiles).

  tested CD: both incorrect

  Tested b: correct

  A is not correct due to the "must". you can connect to cdb and distinguish between tbs with same name in different pdbs with qualifying

  RMAN> BACKUP TABLESPACE pdb1:system, pdb1:sysaux, pdb1:users, pdb2:system;

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-655DC5F5-FF8D-4A73-B67D-F5AAE20CA382

• Question 195:

  Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

  A. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

  B. It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.

  C. A Virtual Private Catalog used to register a container database must be created in a pluggable database.

  D. A Virtual Private Catalog used to register a container database can be created in a pluggable database.

  E. It is always possible for RMAN to connect to a pluggable database as a target.

  F. A Virtual Private Catalog used to register a container database can be created in a non-container database.

  Correct Answer: DEF

• Question 196:

  Which three are true in Oracle 19c and later releases? (Choose three.)

  A. If the password file location changes, then the new location is used automatically by the Oracle Server.

  B. Schema Only accounts can be granted administrator privileges.

  C. All the Oracle-supplied accounts are Schema Only accounts.

  D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.

  E. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

  F. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

  Correct Answer: BDF

  https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-5490FE65-562B-49DC-9246-661592C630F9

• Question 197:

  You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command:

  

  Which three are true? (Choose three.)

  A. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

  B. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

  C. All archive logs created after this backup are kept for two years.

  D. The SPFILE is included in the self-contaied archival backup.

  E. The control file is included in the self-contained archival backup.

  F. The restore point is a label for the system change number (SCN) before the archival backup was taken.

  Correct Answer: BDE

  The restore point is a label for the SCN to which this archival backup can be restored and recovered , and is captured just after the data file backups complete. (F is wrong)

  Normal restore points are retained in the database for at least the number of days specified for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter (A incorrect)

  -The control file autobackup that RMAN automatically makes when you use the backup .. keep command has a copy of the restore point (and also the spfile D and E are correct)

  KEEP - Specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy.

  UNTIL TIME - Specifies the time until which the backup or copy must be kept (B correct)

  https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_6011.htm

  http://devel.hotpilot.cz/ora11gR2u2-full/backup.112/e10643/rcmsubcl011.htm

  An example:

  http://www.online-database.eu/recovery-manager-rman/143-rman-backupsets-with-restore-point

• Question 198:

  Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

  A. By default, AWR snapshots are taken every 60 minutes.

  B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

  C. By default, AWR snapshots are retained for 7 days.

  D. The taking of AWR snapshots can be disabled.

  E. AWR data is stored in the SYSTEM tablespace.

  Correct Answer: ABD

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214

• Question 199:

  Which two are true about automatic block repair? (Choose two.)

  A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.

  B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

  C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

  D. It is not possible for media corrupt blocks.

  E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

  Correct Answer: BE

  BE -> In both cases to repair (Primary or Physical Databases) you must enable RTQ on the Physical Database.

• Question 200:

  Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

  

  Which three are true? (Choose three.)

  A. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

  B. An application seed PDB is created for APP1.

  C. An application root PDB is created for APP1.

  D. A default service is created for the application root APP1.

  E. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

  F. APP1 can never be unplugged.

  Correct Answer: CDE

  AB not APP1$SEED created because not uses AS SEED

  F is incorrect -> If not have any PDBs plug to the APP container, you can unplug an APP container.