oracle 1z0-083 practice test

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

• A. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
• B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
• C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
• D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
• E. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
• E. FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.
• F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
• F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Which two are prerequisites for performing Flashback Transaction?

• A. CDB1 and CDB2 must be in shared undo mode.
• A. Fast Recovery Area must be enabled for the database
• B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
• B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• C. Undo retention guarantee must be configured for the database.
• D. Cloning HR_ROOT automatically clones HR_PDB1.
• E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
• E. A supplemental log must be enabled for the primary key.

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. The Pre-Upgrade Information Tool script is executed by DBUA.
• A. All historical data older than two years, if any, is purged from the flashback archive FDA1.
• B. DBUA must be launched from the target Oracle Home.
• B. An error is returned because the retention period cannot be reduced.
• C. All pluggable databases are automatically upgraded as part of a container database upgrade.
• C. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
• D. A whole database backup must exist before upgrade
• 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.
• E. The database must be opened in read-only mode.
• F. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.

Which three statements are true about Flashback Data Archive?

• A. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
• A. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
• B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
• B. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database
• C. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
• 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 user with SYSDBA or SYSBKUP must use RMAN logged in to a PDB in order to duplicate it.
• D. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
• E. CDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated.
• E. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Examine the statements that use flashback technologies:
FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMMDD
HH:MI:SS');
SELECT * FROM customers AS OF SCN 123456;
FLASHBACK TABLE customers TO BEFORE DROP;
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD
HH:MI:SS');
SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of
relevant undo data in the undo tablespace?

• A. A PDB snapshot can be a sparse copy of a source PDB.
• A. 1,3,6
• B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
• B. 1,2,5
• C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• C. 3,4,5
• D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• D. 2,3,5,6
• 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.

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. Each of the file sections must be processed serially.
• A. All the triggers associated with the table are flashed back but are disabled.
• B. The four sections can be created serially.
• B. Materialized views that use the CUSTOMERS table are flashed back.
• C. The four sections must be image copies.
• C. LOB segments associated with the CUSTOMERS table are flashed back.
• D. The four sections can be created in parallel.
• D. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
• E. The four sections must be contained in backup sets.
• E. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

Which two are true about common objects? (Choose two.)

• A. when the operating system (OS) needs to be changed as part of the upgrade
• A. They can be created only in CDB$ROOT.
• B. when a character set conversion is required during the upgrade
• B. They can be only metadata-linked in an application container.
• C. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
• C. They can exist in user-defined schemas only in application containers.
• D. when the target and source database are on the same platform
• D. They can exist in CDB$ROOT and an application root.
• E. when the hardware platform needs to be changed as part of the upgrade
• E. They can be extended data-linked in CDB$ROOT. F. They can be created only in an application root.

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

• A. The response file can specify the root or sudo password.
• A. It analyzes a period of time corresponding to the 12 hours of activity.
• B. The installer will prompt for the root or sudo password.
• B. It runs automatically after each AWR snapshot.
• C. Silent install always runs operating scripts automatically.
• C. A DBA can run it manually.
• D. The response file must contain the root or sudo password.
• D. Results are written to the alert log.
• E. The response file can specify the path of the sudo program.
• E. It analyzes a period of time corresponding to the last day of activity.

You notice performance degradation in your production Oracle 12c database. You want to know what
caused this performance difference. Which method or feature should you use?

• A. Increase the size of tape I/O buffers.
• A. Database Replay
• B. Disable FORCE LOGGING for the database.
• B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
• C. Increase the size of the database buffer cache.
• C. Active Session History (ASH) report
• D. Enable asynchronous disk I/O.
• D. SQL Performance Analyzer
• E. Increase the level of RMAN multiplexing.

You notice that the performance of your production 24/7 Oracle 12c database has significantly
degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want
to restart the database instance. How can you detect the cause of the degraded performance?

• A. It can be used for applications and middleware.
• A. Enable Memory Access Mode, which reads performance data from SGA.
• B. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
• B. Use emergency monitoring to fetch data directly from SGA for analysis.
• C. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
• E. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
• E. Run ADDM in diagnostic mode.