1z0-034 - Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameterto a nonzero va ...

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY MM D

Which two statements are true regarding the functionality of the remap command in ASMCMD.

What happens when you run the SQL Tuning Advisor with limited scope.

Which options would you consider while configuring a flash recovery area (fast recovery area in 11gRelease 2) for ...

Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUSARCHIVEL ...

Examine these Data Pump commands to import objects to non existent users hr1 and oe1.S expdp system/managerSchem ...

The database is configured in ARCHIEVELOG mode and regular complete database backups are taken.The loss of which ...

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must yo ...

The DB_BLOCK_CHECKING parameter is set to FULL.What checks occur each time the DBWnprocess(es) writes.

You are managing a 24*7 database. The backup strategy for the database is to perform usermanagedbackups.Identify ...

You need to configure fine grained access control to external network resources from within your database.You cr ...

View the Exhibit and examine the RMAN commands. Which statement describes the effect of a backup retention pol ...

Which four resources can directives be specified by using the Oracle Resource Manager.

You are using the control file to maintain information about the database backups that are being performed by Re ...

View the Exhibit to observe the error. You receive this error regularly and have to shutdown the database inst ...

Which are the two prerequisites before setting up Flashback Data Archive. (Choose two.)

Given below are RMAN commands to enable backup optimization and set the retention policy: RMAN> CONFIGURE DEF ...

View the Exhibit. You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four file ...

Which option must you configure while performing an automated Tablespace Point in Time Recovery (TSPITR) by us ...

Which three statements are true about windows.

Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn> ...

View the Exhibit and examine the parameter settings in your server side parameter file (SPFILE). When you tried ...

Which two statements are true regarding an Automatic Storage Management (ASM) instance. (Choose two.)

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in you ...

Which two commands never trigger an implicit rebalancing within the disk group. . (Choose two.)

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT ...

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

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter.

Your database initialization parameter file has the following entry: SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3 Which state ...

You observed the following output for a user session: What do you infer from the preceding output.

In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries ...

Examine the following scenario: Database is running in ARCHIVELOG mode. Complete consistent backup is taken ever ...

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name e ...

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package. (Choose all that apply.)

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN): RMAN> CO ...

Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the co ...

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database. Which two statemen ...

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager.

There was media failure and you decide to check the data files for block corruption. Which would you use to crea ...

You are in the middle of a transaction updating a very important table. The machine on which a database was runn ...

You executed the following command In Recovery Manager {RMAN): RMAN>REPORTNEEDBACKUPdays 3; What is the outpu ...

Examine the parameter settings in your database. Which statement is correct about the database.

memory_target big integer 808M pga_aggregate_target big integer 0 sga_target big integer 0 SQL> SHOW PARAMETE ...

The DB_BLOCK_CHECKING parameter is set to FALS

As part of archiving the historical data, you want to transfer data from one database to another database, which ...