Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 161:

  In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)

  A. poorly written SQL
  B. the number of tablespaces containing tables updated by a transaction
  C. poorly trained users who do not commit transactions
  D. the number of data files containing extents belonging to tables updated by a transaction
  E. issuing multiple savepoints during a transaction
  A. poorly written SQL
  C. poorly trained users who do not commit transactions

  ---

  Explanation/Reference:

• Question 162:

  Which three are true about cloning databases into an existing CDB with RMAN? (Choose three).

  A. A non-CDB can be cloned into a PDB.
  B. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.
  C. Only one PDB can be cloned at a time.
  D. Two or more PDBs can be cloned with the same command.
  E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.
  F. The target and auxiliary instance passwords must be the same.
  B. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.
  C. Only one PDB can be cloned at a time.
  F. The target and auxiliary instance passwords must be the same.

  ---

  Explanation/Reference:

• Question 163:

  Which two are true about Oracle instance recovery? (Choose two.)

  A. Recovery begins from the beginning of the CURRENT redo log group.
  B. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
  C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
  D. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
  E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
  F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
  E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
  F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

  ---

  Explanation/Reference:

• Question 164:

  In one of your databases, unified auditing is enabled and an SH.SALES table exists.

  You successfully execute these commands:

  SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;

  SQL> AUDIT POLICY sales_pol;

  Which statement is true about SALES_POL?

  A. It is enabled for all users having SELECT privilege on SH.SALES.
  B. Only successful queries of SH.SALES are written to the audit trail.
  C. It is only enabled for user SH.
  D. Audit records are always stored in an external audit file.
  A. It is enabled for all users having SELECT privilege on SH.SALES.

  ---

  Explanation/Reference:

• Question 165:

  Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TCddb PLUGGABLE DATABASE pdbl,pdb5; Which two statements are true about the DUPLICATE command? (Choose two)

  A. The root and the seed database in the container database (CDB) are also duplicated.
  B. A backup of PDB1 and PDB5 must exist before executing the command.
  C. The SPFILE is copied along with the data files of the pluggable databases (PDBs).
  D. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
  E. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.
  A. The root and the seed database in the container database (CDB) are also duplicated.
  D. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

  ---

  Explanation/Reference:

  Do backups of the source database exist? The principal advantage of active database duplication is that it does not require source database backups. Active duplication copies mounted or online database files over a network to the auxiliary instance. One disadvantage of this technique is the negative performance effect on the network. Another disadvantage is that the source database is running processes required to transfer the files to the auxiliary host, thereby affecting the source database and production workload. If the source database backups exist, and if the effect on the network is unacceptable, then backup-based duplication may be a better option. You can copy backups to temporary storage and transfer them manually to the destination host. If duplication is made with a connection to the target or the recovery catalog, then the backup files on the destination host must have the same file specification as they had on the source host. Otherwise, this is not a requirement.

• Question 166:

  Which two are prerequisites for performing Flashback Transaction?

  A. Flashback Database must be enabled.
  B. Undo retention guarantee for the database must be configured.
  C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
  D. Supplemental logging must be enabled.
  E. Recycle bin must be enabled for the database.
  F. Block change tracking must be enabled tor the database.
  C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
  D. Supplemental logging must be enabled.

• Question 167:

  Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)

  A. They can view data from any data dictionary view or dynamic performance view.
  B. They cannot create restore points.
  C. They cannot drop tablespaces.
  D. They can create any table.
  E. They can drop any tablespace.
  F. They can view data from any user-defined tables.
  A. They can view data from any data dictionary view or dynamic performance view.
  D. They can create any table.
  E. They can drop any tablespace.

  ---

  Explanation/Reference:

  https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-privilege-and-role-authorization.html#GUID-BF12E37F-4606-42BB-B8B6-4CDC5A870EE7

• Question 168:

  Which two are true about RMAN image copies? (Choose two)

  A. They can only be written to disk.
  B. They can be encrypted using Transparent Data Encryption (TDE).
  C. They can be used as a level 0 incremental backup.
  D. They can be used as a level 1 incremental backup.
  E. They are the only backup option available for databases in NOARCHIVELOG mode.
  A. They can only be written to disk.
  C. They can be used as a level 0 incremental backup.

• Question 169:

  Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

  A. FLASHBACK LOGS are archived after a log switch.
  B. A database can be flashed back using SQL*PLUS.
  C. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
  D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
  E. It always generates REDO and UNDO.
  F. It requires that the target database be in ARCHIVELOG mode.
  B. A database can be flashed back using SQL*PLUS.
  D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
  F. It requires that the target database be in ARCHIVELOG mode.

  ---

  Explanation/Reference:

• Question 170:

  You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

  A. All the triggers associated with the table are flashed back but are disabled.
  B. Materialized views that use the CUSTOMERS table are flashed back.
  C. LOB segments associated with the CUSTOMERS table are flashed back.
  D. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
  E. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
  C. LOB segments associated with the CUSTOMERS table are flashed back.
  D. All the constraints defined on the table, except the referential integrity constraints, are flashed back.