Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 211:

  A container database (CDB) contains two pluggable databases PDB1 and PDB2.

  The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB.

  Data file 24 of PDB2 was deleted and you need to restore and recover it.

  The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.

  Which three are true? (Choose three.)

  A. Data file 24 can be recovered only while connected to PDB2.

  B. Data file 24 can be restored and recovered while connected to CDB$ROOT.

  C. Data file 24 can be restored only while connected to CDB$ROOT.

  D. Data file 24 can be restored only while connected to PDB2.

  E. Data file 24 can be recovered while connected to PDB2.

  F. Data file 24 can be recovered while connected to CDB$ROOT.

  Correct Answer: BEF

  Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question.

• Question 212:

  Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

  A. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

  B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

  C. An existing Oracle base can be used.

  D. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

  E. Existing Oracle Database instances must be shut down before starting the upgrade.

  F. Only the grid user can perform the upgrade.

  Correct Answer: BCE

  F is incorrect, grid OS system can be named anyway. D patches won't be apply automatically A Oracle Grid only supports out-of-place upgrades

• Question 213:

  A database is configured in ARCHIVELOG mode.

  A full RMAN backup exists but no control file backup to trace has been taken.

  A media failure has occurred.

  In which two scenarios is incomplete recovery required? (Choose two.)

  A. after losing a SYSAUX tablespace data file

  B. after losing all members of an INACTIVE online redo log group

  C. after losing all members of the CURRENT online redo log group

  D. after losing all copies of the control file

  E. after losing an UNDO tablespace that is in use

  Correct Answer: CD

  CandD is correct because if you lose all control the required incomplete recovery. if incomplete recovery then db must be open in resetlog option.

  E: undo tablespace. >> (Incorrect) http://oracle-help.com/backup-and-recovery/recovery-recover-loss-system-critical-undo-tablespace-original-location/

  D: (correct see the details) http://oracle-help.com/backup-and-recovery/recovery-restore-loss-current-control-files-default-location/

• Question 214:

  Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.

  You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.

  Which two are always true? (Choose two.)

  A. CDB1 and CDB2 must be in shared undo mode.

  B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

  C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

  D. Cloning HR_ROOT automatically clones HR_PDB1.

  E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

  Correct Answer: BE

  After you create the application PDB, it is in mounted mode, and its status is NEW https://docs.oracle.com/en/database/oracle/oracle-database/21/multi/creating-application-pdb.html#GUID-88E61123-F651-47D7-9977-B589268EBD29

• Question 215:

  Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

  A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.

  B. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.

  C. An Oracle database can be restored from backup files copied using O/S utilities.

  D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

  E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

  F. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

  G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

  Correct Answer: CDE

  Backing up a database with OS utilites can be performed only when the database is shut down, so... A, B, G are incorrect

  OS copies are not backupsets, so again F is incorrect.

• Question 216:

  Examine this configuration:

  1.

  CDB1 is a container database.

  2.

  PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully:

  

  Which two are true? (Choose two.)

  A. PDB1 and PDB2 are in MOUNT state.

  B. Redo logs are opened.

  C. PDB1 and PDB2 are in READ ONLY state.

  D. CDB$ROOT is in MOUNT state.

  E. PDB$SEED is in READ ONLY state.

  Correct Answer: AD

  Version 19.6.0.0.0

  SQL> show pdbs

  CON_ID CON_NAME OPEN MODE RESTRICTED

  2 PDB$SEED READ ONLY YES

  3 PDB1 READ WRITE YES

  4 PDB2 READ WRITE YES

  5 PDB3 MOUNTED

  SQL> shutdown immediate;

  Database closed.

  Database dismounted.

  ORACLE instance shut down.

  SQL> startup mount;

  ORACLE instance started.

  .

  Database mounted.

  SQL> show pdbs

  CON_ID CON_NAME OPEN MODE RESTRICTED

  2 PDB$SEED MOUNTED 3 PDB1 MOUNTED 4 PDB2 MOUNTED 5 PDB3 MOUNTED SQL>

• Question 217:

  Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

  A. A PDB snapshot is always a full copy of the source PDB.

  B. A PDB snapshot is always a sparse copy of the source PDB.

  C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

  D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.

  E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

  F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

  G. A snapshot copy PDB can be created from a stand-alone clone PDB.

  Correct Answer: CG

  A, B incorrects -> http://ora-srv.wlv.ac.uk/oracle19c_doc/multi/introduction-to-the-multitenant-architecture.html#GUID-47847140-8DE4-4C4E-8C93-4E9C197D1402 C correct, D,E,F incorrect -> https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-B00A0E48-C892-4DC8-8455-C6F2ABC8EF91 G -> correct -> A clone from a PDB snapshot is a full, standalone PDB. -> https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-22118625-3157-4C38-8A88-79A561A3E6ED

  http://ora-srv.wlv.ac.uk/oracle19c_doc/multi/introduction-to-the-multitenant-architecture.html#GUID-47847140-8DE4-4C4E-8C93-4E9C197D1402

• Question 218:

  Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

  A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

  B. Oracle DBCA templates can store only logical structure and not database files.

  C. New templates can only be created by modifying an existing user-created template.

  D. The Data Warehouse template is most suitable when transaction response time is the key criterion.

  E. Oracle DBCA templates can be used to create new databases and duplicate existing databases.

  Correct Answer: AE

  Reference: https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22-8BB67DCC9885.htm#ADMQS0235

• Question 219:

  Your SALES_ROOT application container has two application PDBs.

  The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.

  Examine this query and its output:

  

  Which two are true? (Choose two.)

  A. The CONTAINERS clause cannot be used in queries on the REVENUE table.

  B. The REVENUE table must be a list-partitioned table.

  C. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.

  D. The MAPTABLE table is a metadata-linked table.

  E. A container map exists for the REVENUE table, but is not enabled.

  F. The REVENUE table partitions are not pruned across the PDBs automatically.

  Correct Answer: CF

  C and F are correct.

  Tested in lab with exact same setting like in the output shown.

  A. -> incorrect - The CONTAINERS clause can be used.

  B. -> incorrect - It can be also a range based.

  C. -> CORRECT - https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html#GUID-AAF93A02-7C70-4024-8758-E351C213543E

  D. -> incorrect - Regular table

  E. -> incorrect - shown in the output CONTAINER_MAP = YES

  F. -> CORRECT - because CONTAINERS_DEFAULT is not enabled for the revenue table.

• Question 220:

  You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.

  Examine this command and its outcome:

  

  Which two are true? (Choose two.)

  A. oracle will be an owner of the Oracle Inventory.

  B. oracle must be the owner of every Oracle Database installation.

  C. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

  D. oracle will be granted the SYSASM privilege when installing the Oracle Database software.

  E. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

  Correct Answer: AE

  The SYSASM Privilege for Administering Oracle ASM SYSASM is a system privilege that enables the separation of the SYSDBA database administration privilege from the Oracle ASM storage administration privilege. Access to the SYSASM privilege is granted by membership in an operating system group that is designated as the OSASM group. This is similar to SYSDBA and SYSOPER privileges, which are system privileges granted through membership in the groups designated as the OSDBA and OSOPER operating system groups. You can designate one group for all of these system privileges, or you can designate separate groups for each operating system privilege.