1Z0-034 Exam Questions

Which two statements are true regarding hot patching? (Choose two.)

In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your dat...

Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for th...

Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to corre...

Note the following parameter settings: Which setting is NOT allowed?

You created a tablespace with the following statement: CREATE BIGFILE TABLESPACE adtbs DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G; There is now a requirement to increase the size o...

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS ---------------- SQL> ALTER TABLE altb SHRINK SPACE COMPACT; Table altered. SQL> SELECT blocks FROM user_seg...

You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with t...

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?

Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

What can you achieve by implementing reverse key index?

In which situation would you use static database registration for a listener?

In which two aspects does hot patching differ from conventional patching? (Choose two.)

You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tabl...

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN session: RMAN> BACKUP DATABASE FILESPERSET 2; The database has se...

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following co...

While designing a database, you created the EMPLOYEES table as an index-organized table (IOT). You must create a bitmap index on the EMPLOYEES .JOB_ID column. Which must you do to...

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue?

Given below is a list of scenarios: 1) A user terminates his session abnormally. 2) The connection between the server and the client application terminates because of a network fai...

Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline. Why is the rebalancing not pe...

Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

UNDO__RETENTION is set to 1000 and retention is not guaranteed. You configure the database with a fixed size undo tablespace. Which is true about undo retention in this configurati...

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (...

You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GR...

Which three file types are managed by Data Pump jobs?

During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this envi...

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You...

Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?

You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so...

Which two statements are true about a job chain? (Choose two.)

You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.

Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replic...

You executed the following query: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; Considering that all the redo logs are available, what informati...

To accomplish user-managed backup for the USERS tabespace, you issued the following command to put the tablespace in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While co...

Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have oc...

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Aut...

In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?

The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN';...

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

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 11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Ch...

Examine the following RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which perquisite must be met before accomplishing the backup?

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1. S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table $ impdp system/manag...