Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 221:

  Examine this configuration:

  

  While CDB1 is open, `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted. To recover from this critical failure, you execute these commands:

  

  What will be the outcome?

  A. It will create `$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

  B. It will create `/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

  C. It will re-create `/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

  D. It will create `/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.

  E. It will fail because there is no autobackup of the controlfiles.

  Correct Answer: C

  RMAN> restore controlfile from '/opt/oracle/oradata/XE/control01.ctl';

  Starting restore at 15-FEB-21 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=38 device type=DISK

  channel ORA_DISK_1: copied control file copy output file name=/opt/oracle/oradata/XE/control01.ctl output file name=/opt/oracle/oradata/XE/control02.ctl Finished restore at 15-FEB-21

  RMAN> alter database mount;

  released channel: ORA_DISK_1 Statement processed

  RMAN> alter database open;

  Statement processed

• Question 222:

  Examine these actions:

  1.

  Create a new database for a recovery catalog.

  2.

  Create a tablespace with sufficient space in the catalog database for the recovery catalog.

  3.

  Configure ARCHIVELOG mode for the catalog database.

  4.

  Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.

  5.

  Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.

  6.

  Grant the SYSBACKUP privilege to the recovery catalog schema owner.

  Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

  A. 2, 4, 5, 6

  B. 1, 2, 3, 4, 5, 6

  C. 1, 2, 4, 5

  D. 2, 4, 5

  E. 1, 3, 4, 5

  Correct Answer: D

  Example 2-70 Creating a Recovery Catalog and Registering a Database

  Assume that you start SQL*Plus and connect to the recovery catalog catdb with administrator privileges. You execute the CREATE USER statement as follows, replacing password with a user-specified password (see Oracle Database Security Guide for information on creating secure passwords). The SQL statement creates a user rco in database catdb and grant the rco user the RECOVERY_CATALOG_OWNER role.

  SQL> CREATE USER rco IDENTIFIED BY password 2 DEFAULT TABLESPACE cattbs 3 QUOTA UNLIMITED ON cattbs; SQL> GRANT recovery_catalog_owner TO rco; SQL> EXIT

  https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE-CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC

• Question 223:

  Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

  A. It recompiles all stored PL/SQL code by using utlrp.sql.

  B. It empties the RECYCLE BIN.

  C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

  D. It sets all user tablespaces to "read-only" before starting the upgrade.

  E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

  F. It increases tablespace size, if required, to meet upgrade requirements.

  Correct Answer: BCD

• Question 224:

  Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

  A. SBT tape compression can be used even if no RMAN compression is configured.

  B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

  C. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

  D. SBT tape compression and RMAN backup compression should be used in parallel.

  E. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

  Correct Answer: AE

  A. SBT tape compression can be used even if no RMAN compression is configured.

  B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

  C. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

  D. SBT tape compression and RMAN backup compression should be used in parallel.

  E. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

  A - sbt tape compression independently can be used on the TAPE side. Oracle recommends You should not use both tape compression provided by the media manager _and_ binary compression provided by RMAN. If the media manager compression is efficient, then it is usually the better choice. Using RMAN-compressed backup sets can be an effective alternative to reduce bandwidth used to move uncompressed backup sets over a network to the media manager, if the CPU overhead required to compress the data in RMAN is acceptable.

• Question 225:

  Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

  A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

  B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

  C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

  D. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

  E. CDB$ROOT and PDB$SEED are automatically duplicated.

  Correct Answer: AE

  You can duplicate a single PDB, a set of PDBs, or a set of tablespaces within a PDB by using the DUPLICATE command.

  To duplicate PDBs, you must log in to the root of the CDB as a user with the SYSDBA or SYSBACKUP privilege. When duplicating a PDB to a new CDB, you must create the auxiliary instance as a CDB. To do so, start the auxiliary instance

  with the declaration enable_pluggable_database=TRUE in the initialization parameter file.

  When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the CDB seed (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the CDB seed, and the duplicated PDBs.

  Reference: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV430

• Question 226:

  Which three are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose three.)

  A. It is an Oracle Database service

  B. It cannot be used to upgrade Oracle Database homes.

  C. It can be used to provision applications.

  D. It can be used to patch Grid Infrastructure homes containing Oracle Restart.

  E. It can be used to provision middleware.

  F. It is an Oracle Grid Infrastructure service.

  Correct Answer: BDF

• Question 227:

  Examine this configuration:

  1.

  CDB1 is a container database.

  2.

  COMMON_USER_PREFIX is C##.

  3.

  PDB1 is a pluggable database contained in CDB1.

  4.

  APP1_ROOT is an application container contained in CDB1.

  5.

  APP1_PDB1 is an application PDB contained in APP1_ROOT.

  You execute these commands successfully:

  

  Which two are true? (Choose two.)

  A. APP1_USER1 can be created in PDB1.

  B. APP1_USER1 can be created in CDB1.

  C. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

  D. C##_APP_USER1 can be created in CDB1.

  E. P1_USER1 can be created in CDB1.

  F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

  Correct Answer: AD

• Question 228:

  Which three are true about managing memory components in an Oracle database instance? (Choose three.)

  A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

  B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

  C. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

  D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.

  E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

  F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

  Correct Answer: ABF

  in AMM the instance exchanges memory between the SGA and the instance PGA as needed (B is correct)

  In ASMM the instance automatically distributes this memory among the various SGA components (JUST SGA) (A is correct, E incorrect)

  After a restart the instance return to the SGA values before the shutdown (not the initial values) (C incorrect)

  https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-8F54391B-D42A-4FDA-9D12-E1F81FD113EA

  F is also correct:

  For OLTP systems, the PGA memory typically makes up a small fraction of the available memory, leaving most of the remaining memory for the SGA.

  For DSS systems running large, memory-intensive queries, PGA memory can typically use up to 70% of the available memory.

  Reference:

  https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm

  https://docs.oracle.com/database/121/TGDBA/tune_pga.htm#TGDBA472

• Question 229:

  Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

  A. defining primary keys for all tables to speed up all queries

  B. using check constraints to speed up updates

  C. defining foreign keys for all tables to speed up joins

  D. the physical data model

  E. the configuration of storage arrays

  Correct Answer: DE

  A. defining primary keys for all tables to speed up all queries

  B. using check constraints to speed up updates

  C. defining foreign keys for all tables to speed up joins

  D. the physical data model

  E. the configuration of storage arrays

  D - is to do with design the tablespace, partitions etc..

  E - is to do with storage layout, that RAID levels e.g. 5 to keep data with high read IO. 1+0 for better write.

• Question 230:

  Which three are true about Database Point-in-Time Recovery? (Choose three.)

  A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

  B. The database must be in MOUNT state when performing Database Point-in-Time Recovery.

  C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

  D. The Database must be in ARCHIVELOG mode.

  E. The target point for the recovery must be specified as a stime or System Change Number (SCN).

  F. The database must be open RESETLOGS after Database Point-in-Time Recovery.

  Correct Answer: BDF

  Archivelog mode and mount state are needed (B, and D)

  After the restore you need to open with reset logs (F)

  E is discarted because sequence number also is valid

  https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20target%20time.