1Z0-034 Online Practice Questions and Answers

Before a Flashback Table operation, you execute the following command:

ALTER TABLE employees ENABLE ROW MOVEMENT;

Why would you need this to be executed?

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback opertion

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. Online and archived redo files are required to accomplish instance recovery

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Your database initialization parameter file has the following entry:

SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3

Which statement is true regarding this setting?

A. It drops the connection after the specified number of login attempts fail for any user.

B. It is enforced only if the password profile is enabled for the user.

C. It locks the user account after the specified number of attempts.

D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBAprivilege.

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The

PROD1,PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog.

The databaseuser who owns the base recovery catalog is CATOWNER. CATOWNER executes the

following command to grantprivileges to a new user VPC1 using Oracle Database 11g RMAN executables:

RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;

Then you issue the following commands:

RMAN> CONNECT CATALOG vpc1/oracle@catdb;

RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"

What is the outcome of the above commands?

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packagedprocedure.

You executed the following commands:

SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE

DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');

SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the

above session?

A. The statistics are stored in the pending statistics table in the data dictionary.

B. The statistics are treated as the current statistics by the optimizer for all sessions.

C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.

What action must you take to achieve this?

A. Run Segment Advisor.

B. Run the SQL Tuning Advisor (STA).

C. Run the Automatic Workload Repository (AWR) report.

D. Run the SQL Access Advisor with a hypothetical workload.

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:

Which statement is true about the outcome?

A. Only one channel is allocated and the backup is created in the flash recovery area

B. Only one channel is allocated and the backup is created in the destination specified for channel

C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario?

A. You must shut down the database instance to perform the backups.

B. You must configure the flash recovery area (fast recovery area) for the database.

C. You can perform complete database backups without closing the database.

D. All the previous closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode.

Identify two correct statements about the Active Session History (ASH) data.

A. A part of SGA memory is used to store ASH data as rolling buffer.

B. The ASH data can be analyzed between any two small time intervals.

C. All ASH data in memory are flushed to disk by MMON in every 3 seconds.

D. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.

Which condition must be met before you create the VPC?

A. A base catalog exists

B. The recovery catalog is empty

C. The base recovery catalog must be dropped

D. A target database is registered in the recovery catalog