Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 81:

  Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

  A. cloning a remote container database in interactive mode
  B. cloning a remote pluggable database in silent mode
  C. relocating a remote pluggable database in interactive mode
  D. relocating a remote container database in silent mode
  E. cloning a remote container database in silent mode
  F. relocating a remote pluggable database in silent mode
  G. relocating a remote container database in interactive mode
  B. cloning a remote pluggable database in silent mode
  E. cloning a remote container database in silent mode
  F. relocating a remote pluggable database in silent mode

  ---

  Explanation/Reference:

  $ORACLE_HOME/bin/dbca -silent \

  -createDuplicateDB -gdbName CDB1 -sid CDB1B \

  -createAsStandby -dbUniqueName CDB1B -sysPassword oracle \

  -primaryDBConnectionString $(hostname):1521/CDB1A \

  -datafileDestination /u01/oradata -useOMF true -storageType FS \

  -recoveryAreaDestination /u01/fast_recovery_area \

  -recoveryAreaSize 10240 -enableArchive true \

  -createListener LISTENER1B:1522

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silent-mode/index.html?learningpath=trueandappuser=nobodyandappsession=170971049395andcontentid=26693andactivityname=Clone%20PDBs%

  20using%20DBCA%20in%20Silent%20Modeandeventid=6352

• Question 82:

  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.
  B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
  E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

  ---

  Explanation/Reference:

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

  You execute the following piece of code with appropriate privileges:

  

  User SCOTT has been granted the CREATE SESSION privilege and the MGR role.

  Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

  A. DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.
  B. DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.
  C. Data is never redacted for the EMP_VW.SAL column.
  D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
  E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct
  A. DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.
  C. Data is never redacted for the EMP_VW.SAL column.

  ---

  Explanation/Reference:

  Note:

  *

  DBMS_REDACT.FULL completely redacts the column data.

  *

  DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported.

  *

  The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.

  *

  If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.

• Question 84:

  You are managing this configuration:

  1.

  CDB1 is a container database.

  2.

  PDB1 and PDB2 are two pluggable databases in CDB1.

  3.

  USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2. CDB1 user SYS executes these commands after connecting successfully to PDB2:

  

  Which two are true? (Choose two.)

  A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
  B. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
  C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
  D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
  E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
  F. The insert on USER2.DEPT is uncommitted.
  G. The inserts on USER1.EMP were committed when the session connected to PDB2.
  A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
  C. The insert on USER2.DEPT fails because of the active transaction in the parent container.

  ---

  Explanation/Reference:

  other session to check any transaction

  Version 19.5.0.0.0

  SQL>

  SQL> alter session set container=ELC20MIG;

  Session altered.

  SQL> select * from user1.emp;

  no rows selected

• Question 85:

  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.
  A. ADDM can run in a nonroot container.
  B. AWR snapshots can be created in CDB$ROOT.
  E. AWR snapshots can be created in a PDB.

  ---

  Explanation/Reference:

  The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root. The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB.

  Starting with Oracle Database 12c, ADDM is enabled by default in the root container of a multitenant container database (CDB). Starting with Oracle Database 19c, you can also use ADDM in a pluggable database (PDB).

• Question 86:

  Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup? (Choose two).

  A. Backups can be taken only if a fast recovery area is configured.
  B. Backups can be written only to disk.
  C. Backups can be taken only for data files.
  D. Binary compression cannot be applied to the backup.
  E. Backups can be written only if checksums are stored for each block.
  F. Backups can be written only to media.
  B. Backups can be written only to disk.
  D. Binary compression cannot be applied to the backup.

• Question 87:

  Which three true about recovering tables using RMAN? (Choose three.)

  A. RMAN can recover tables in the SYSAUX tablespace.
  B. RMAN can recover tables owned by the SYS user.
  C. RMAN can recover tables in the SYSTEM tablespace.
  D. RMAN always uses an auxiliary instance.
  E. RMAN can recover tables in a standby database.
  F. RMAN can recover a table after a DDL operation has altered the table structure.
  G. RMAN can recover tables owed by the SYSTEM user.
  D. RMAN always uses an auxiliary instance.
  F. RMAN can recover a table after a DDL operation has altered the table structure.
  G. RMAN can recover tables owed by the SYSTEM user.

  ---

  Explanation/Reference:

  A. RMAN can recover tables in the SYSAUX tablespace. - WRONG

  B. RMAN can recover tables owned by the SYS user. - WRONG

  C. RMAN can recover tables in the SYSTEM tablespace.- WRONG

  D. RMAN always uses an auxiliary instance.

  E. RMAN can recover tables in a standby database.- WRONG

  F. RMAN can recover a table after a DDL operation has altered the table structure.

  G. RMAN can recover tables owed by the SYSTEM user.

  22.1.4 Backup Guide

• Question 88:

  Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant? (Choose three).

  A. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
  B. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.
  C. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
  D. The new extended data type capability must be enabled by running the utlrp.sql script
  E. The Oracle Application Express configuration should be updated after upgrading Oracle Database.
  A. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
  B. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.
  E. The Oracle Application Express configuration should be updated after upgrading Oracle Database.

  ---

  Explanation/Reference:

• Question 89:

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

  A. It is an Oracle Database service.
  B. It can be used to deploy Oracle Database homes.
  C. It cannot be used to provision applications.
  D. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
  E. It cannot be used to provision middleware.
  F. It is an Oracle Grid Infrastructure service.
  B. It can be used to deploy Oracle Database homes.
  D. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.
  F. It is an Oracle Grid Infrastructure service.

  ---

  Explanation/Reference:

  Reference: https://blogs.oracle.com/db_maintenance/rapid-home-provisioning-server-minimun-requirement

• Question 90:

  Which two statements are true when row-archival management is enabled? (Choose two).

  A. The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.
  B. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
  D. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.
  E. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.
  B. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
  C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.