Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 71:

  In which two situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose two).

  A. when free space in a locally managed tablespace falls below a specified percentage

  B. when the number of logons per second exceeds a specific value

  C. when a database instance has been running for a period greater than a threshold value

  D. when the total number of locked user account exceeds a specific value

  E. when a database instance has been running for a period greater than a threshold value

  Correct Answer: AB

• Question 72:

  Examine the RMAN command:

  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which prerequisite must be met before accomplishing the backup?

  A. The password for the encryption must be set up.

  B. Oracle wallet for the encryption must be set up.

  C. All the table spaces in the database must be encrypted

  D. Oracle Database Vault must be enabled.

  Correct Answer: B

• Question 73:

  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.

  Correct Answer: CD

• Question 74:

  choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.

  You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;

  What is the outcome?

  A. All historical data older than two years, if any, is purged from the flashback archive FDA1.

  B. An error is returned because the retention period cannot be reduced.

  C. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years

  D. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

  Correct Answer: A

• Question 75:

  Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? (Choose three).

  A. The control file is backed up whenever a new tablespace is created.

  B. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

  C. The control file is backed up whenever a new table is created.

  D. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

  E. It requires the use of fast recovery area (FRA).

  F. The control file is backed up automatically each time the SPFILE is backed up manually.

  Correct Answer: ABD

• Question 76:

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

  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

  Correct Answer: BEG

• Question 77:

  Which three RMAN persistent settings can be set for a database?

  A. backup retention policy

  B. default backup device type

  C. default section size for backups

  D. default destinations for backups

  E. multiple backup device types for a single backup

  Correct Answer: ABD

• Question 78:

  Which three statements are true about Flashback Database?

  A. Flashback logs are written sequentially, and are archived.

  B. Flashback Database uses a restored control file to recover a database.

  C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

  D. Flashback Database can recover a database to the state that it was in before a reset logs operation.

  E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

  F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

  Correct Answer: CDF

• Question 79:

  SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.

  Which action could help in the performance management of these regressed SQL statements?

  A. Create SQL plan directives for each of the regressed statements.

  B. Use The SQL Tuning Advisor for each of the regressed statements.

  C. Create an adaptive execution plan for each of the regressed statements

  D. Use the SQL Access Advisor for each of the regressed statements.

  Correct Answer: B

• Question 80:

  Which three statements are true about Flashback Data Archive?

  A. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

  B. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database

  C. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

  D. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

  E. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

  Correct Answer: CDE