Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 131:

  Which three are true about performing an Oracle Database install on Linux? (Choose three.)

  A. The runfixup.sh script can install missing RPMs.
  B. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
  C. It allows you to select the languages supported by the Oracle database server.
  D. It can be done before installing Grid Infrastructure for a Standalone Server.
  E. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
  F. It can be done after installing Grid Infrastructure for a Standalone Server.
  G. The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.
  D. It can be done before installing Grid Infrastructure for a Standalone Server.
  E. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
  F. It can be done after installing Grid Infrastructure for a Standalone Server.

  ---

  Explanation/Reference:

  It's DEF. Linux is an Open Source OS and is very dynamic with Oracle, but access to the root a/c or it's password will always remain limited to Oracle.

• Question 132:

  You issued this command:

  RMAN> BACKUP RECOVERY AREA FORCE;

  Which three are true? (Choose three.)

  A. All files in the current FRA that have been backed up already, are backed up.
  B. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
  C. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
  D. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
  E. All files in any previous FRA that have not yet been backed up, are backed up.
  F. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
  G. All files in any previous FRA that have been backed up already, are backed up.
  B. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
  C. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
  D. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.

  ---

  Explanation/Reference:

• Question 133:

  Which three are true about Data Pump in an Oracle multitenant environment? (Choose three).

  A. It can be used to transport data from a non-CDB to a PDB.
  B. It can be used to clone a CDB.
  C. It can be used to transport data between PDBs.
  D. It can be used to transport data from a PDB to a non-CDB.
  E. It can be used to create a new PDB.
  A. It can be used to transport data from a non-CDB to a PDB.
  C. It can be used to transport data between PDBs.
  D. It can be used to transport data from a PDB to a non-CDB.

• Question 134:

  Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)

  A. It can be used only on nodes with Oracle Grid Infrastructure installed.
  B. It can be used to patch existing Oracle software installations.
  C. It can be used to create templates of Oracle homes as gold images of only Oracle databases.
  D. It can be used to deploy new homes without disrupting active databases.
  E. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.
  F. It can be used to upgrade only single-instance databases running on Oracle Restart.
  B. It can be used to patch existing Oracle software installations.
  D. It can be used to deploy new homes without disrupting active databases.
  E. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.

  ---

  Explanation/Reference:

  Rapid Home Provisioning can provision Oracle Database homes for Oracle Database 11.2 and later. Once the software is provisioned, a single RHP command will create a database with choices including

  1.

  Oracle Real Application Clusters (Oracle RAC)

  2.

  Oracle Real Application Clusters One Node (Oracle RAC One Node)

  3.

  single instance (with or without Grid Infrastructure or Oracle Restart on the target)

  4.

  using templates

  5.

  creating Oracle Multitenant Container Databases (CDBs)

  6.

  creating an Admin- or Policy-managed database https://www.oracle.com/assets/rapid-home-provisioning-2405191.pdf

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sprhp/what-can-i-do-rapid-home-provisioning.html

• Question 135:

  Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

  A. It is used to change failure priority only for HIGH or LOW priorities.
  B. It is used to execute the advised repair script.
  C. It is used to change failure priority only for the CRITICAL priority.
  D. It is used to explicitly close the open failures.
  E. It is used to inform the database about the repair after the repair script executes.
  A. It is used to change failure priority only for HIGH or LOW priorities.
  D. It is used to explicitly close the open failures.

• Question 136:

  Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.

  No changes have been made to the standard PDB$SEED.

  How many default temporary tablespaces can be assigned in the CDB?

  A. three
  B. eight
  C. seven
  D. six
  E. five
  D. six

  ---

  Explanation/Reference:

  We can verify that, by default, neither PDB$SEED nor APP SEED create temporary tablespace (at least that's how it seems to work in 19.3.0)

  SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED

  2 PDB$SEED READ ONLY NO 3 TOYS_ROOT READ WRITE NO 4 TOYS_ROOT$SEED READ WRITE NO 5 PDB1 READ WRITE NO 6 HR_ROOT READ WRITE NO 7 OPERATIONS READ WRITE NO 8 RESEARCH READ WRITE NO

  SQL> select name from v$pdbs where con_id not in (select con_id from cdb_temp_files); NAME

  PDB$SEED TOYS_ROOT$SEED

  CDB$ROOT + pdb1 + pdb2 + app_root + app_pdb1 + app_pdb2 = 6

• Question 137:

  Examine this configuration:

  1.

  CDB1 is an Oracle Database 12c Release 2 container database (CDB).

  2.

  PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.

  After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:

  

  What is the outcome?

  A. It fails because PDB$SEED is in MIGRATE state.
  B. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
  C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
  D. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
  E. Only CDB$ROOT and PDB$SEED are upgraded.
  F. It fails because PDB2 is not in UPGRADE state.
  C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.

  ---

  Explanation/Reference:

  C. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.

  CDB$ROOT - In Upgrade MOde PDB$SEED - in Upgrade Mode PDB1 - In Upgrade Mode (Alter .. Open Upgrade) PDB2 - Excluded

  A - Incorrect When a PDB is in open migrate mode, you can run database upgrade scripts on the PDB

  F-Incorrect -it's excluded.

• Question 138:

  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.
  B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
  E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

  ---

  Explanation/Reference:

  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 139:

  Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

  A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
  B. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
  C. The Oracle Grid Infrastructure installation must be owned by the grid user.
  D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
  E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
  F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
  B. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
  D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.

  ---

  Explanation/Reference:

  A - false - Members of this group are granted the SYSASM system privilege to administer Oracle ASM.SYSASM system privileges do not grant access privileges on an Oracle Database instance. B- Correct C - false Only if you wish to define role separation but is not a must D - correct E- false OSOPER is optional is not a must F - the same OSDBA could be used but is not a must ( usually SYSDBA and SYSASM are used for separation us duties )

  Reference: https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99-4C6D-85D6-868CBA6F5DAE

• Question 140:

  Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

  A. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
  B. A connection to an auxiliary instance is always required.
  C. A subset of the target database can be duplicated.
  D. A new DBID is always created for the duplicated database.
  E. A connection to the recovery catalog instance is always required.
  F. A backup of the target database is always required.
  G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
  H. A connection to the target database instance is always required.
  A. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
  B. A connection to an auxiliary instance is always required.
  C. A subset of the target database can be duplicated.
  G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.

  ---

  Explanation/Reference: