Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 121:

  A schema owner truncated a table in error and must recover the data.

  Which Oracle Flashback feature could be used to recover the data?

  A. FLASHBACK TRANSACTION
  B. FLASHBACK VERSION QUERY
  C. FLASHBACK DATA ARCHIVE
  D. FLASHBACK TABLE
  E. FLASHBACK DATABASE
  C. FLASHBACK DATA ARCHIVE

  ---

  Explanation/Reference:

• Question 122:

  Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

  A. After the change, only a common user with the required privilege can create an undo tablespace in CDBandROOT.
  B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
  C. After the change, only one undo tablespace can exist in CDB$ROOT.
  D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
  E. Undo tablespaces existing in PDBs must be dropped before the change.
  F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
  A. After the change, only a common user with the required privilege can create an undo tablespace in CDBandROOT.
  B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

  ---

  Explanation/Reference:

• Question 123:

  Which two are true about unplugging an application container from a container database and plugging it into a different container database?

  A. It requires local undo mode in both container databases.
  B. It requires only local undo mode in the database where the application container will be unplugged.
  C. Plugging the application root into a different CDB plugs In all its application PDBs.
  D. Application PDBs In the application container must be unplugged before the application root Is unplugged.
  E. Unplugging the application root from a CDB unplugs all its application PDBs.
  F. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
  D. Application PDBs In the application container must be unplugged before the application root Is unplugged.
  E. Unplugging the application root from a CDB unplugs all its application PDBs.

• Question 124:

  Which three RMAN persistent settings can be set explicitly? (Choose three)

  A. SPFILE backup duplexing
  B. control file auto backup formats
  C. archive log deletion policy
  D. image copy duplexing
  E. redo log backup duplexing
  F. archive log backup duplexing
  B. control file auto backup formats
  C. archive log deletion policy
  F. archive log backup duplexing

• Question 125:

  Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

  A. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
  B. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
  C. creating a new empty PDB in the local database from PDB$SEED
  D. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
  E. automatically dropping the database link to the remote database if it already exists
  F. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
  G. opening the cloned PDB
  B. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
  E. automatically dropping the database link to the remote database if it already exists
  G. opening the cloned PDB

  ---

  Explanation/Reference:

  https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-13FF2CE2-532C-4816-8E88-7A5A6E16A279

  About Cloning a Remote PDB

  When the source is a PDB is in a remote CDB, you must use a database link to clone the PDB into the local CDB.

  The database link must exist in the local CDB (not the remote CDB). When you issue the CREATE PLUGGABLE DATABASE statement from the root of the local CDB, you must specify a database link to the remote CDB that contains the

  PDB being cloned in the FROM clause. The database link connects from the local CDB to either to the root of the remote CDB or to the remote source PDB.

  The following figure illustrates how this technique creates a new PDB when the source PDB is remote.

  https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-32AE49B1-13A7-4A4D-AB43-BA781ECA99D6

• Question 126:

  Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

  A. A PDB snapshot can be a sparse copy of a source PDB.
  B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
  C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
  D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
  E. A PDB snapshot can be a full copy of a source PDB.
  F. A snapshot copy PDB can be a full copy of a source PDB.
  G. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
  A. A PDB snapshot can be a sparse copy of a source PDB.
  D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
  E. A PDB snapshot can be a full copy of a source PDB.

• Question 127:

  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.
  A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
  E. Oracle DBCA templates can be used to create new databases and duplicate existing databases.

  ---

  Explanation/Reference:

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

• Question 128:

  You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night.

  Which DBCA option must you choose to create the database?

  A. a General Purpose database template with default memory allocation
  B. a Data Warehouse database template, with t he dedicated server mode option and AMM enabled
  C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
  D. a default database configuration
  C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

• Question 129:

  Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)? (Choose two).

  A. A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.
  B. A PDB Lockdown profile can be created in an application root.
  C. A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.
  D. A PDB Lockdown profile can be created in a regular PDB.
  E. A PDB Lockdown profile can be created in CDB$ROOT .
  B. A PDB Lockdown profile can be created in an application root.
  E. A PDB Lockdown profile can be created in CDB$ROOT .

• Question 130:

  Examine the statements that use flashback technologies:

  1.

  FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);

  2.

  SELECT * FROM customers AS OF SCN 123456;

  3.

  FLASHBACK TABLE customers TO BEFORE DROP;

  4.

  FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);

  5.

  SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;

  6.

  ALTER TABLE customer FLASHBACK ARCHIVE;

  Which set of statements depends on the availability of relevant undo data in the undo tablespace?

  A. 1,3,6
  B. 1,2,5
  C. 3,4,5
  D. 2,3,5,6
  B. 1,2,5