7/24 online customer service will be available anytime and anywhere you need. All of us provide track service for one year if you buy our Oracle 1z0-034 exam dumps. Youll enjoy the actual free updated Oracle 1z0-034 examination questions and answers inside of this period. If there is something changed from the latest Oracle Oracle exam syllabus, we will deliver the upgraded Oracle exam demos to you personally soon.

2016 Nov 1z0-034 rapidshare

Q61. 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 the TOOLS tablespace was taken on November 3, 2007. 

-The TOOLS tablespace is read-only since November 4, 2007. 

On November 23, 2007, you issue the RMAN command to back up the database to disk. Which 

statement is true regarding the backup of the TOOLS tablespace? 

A. The RMAN backup fails because the TOOLS tablespace is read-only 

B. The RMAN skips the backup of the tablespace because backup optimization is enabled 

C. The RMAN makes backup because optimization can be enabled only for backups to disk 

D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window 

Answer:


Q62. Which two statements are correct about database transportation? (Choose two.) 

A. The source and target platforms must be the same 

B. Redo logs, control files and temp files are also transported 

C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed 

D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported 

E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format 

Answer: D,E 


Q63. 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 environment variable setting affect the installation? 

A. The installation terminates with an error. 

B. The installation proceeds with the default value without warnings and errors. 

C. The installation proceeds with the default value but it would not be an OFA-compliant database. 

D. The installation proceeds with the default value but a message would be generated in the alert log file. 

Answer:


Q64. In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators. 

In addition, reports are generated using complex joins with non-equality operators. 

What table organization is the best for this workload? 

A. heap table 

B. object table 

C. external table 

D. sorted hash clustered table 

E. global temporary table 

F. hash clustered table 

Answer:


Q65. You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates. 

Which tablespace will be the default permanent tablespace for non-system users, excluding DBSNMP and OUTLN? 

A. USERS 

B. SYSTEM 

C. SYSAUX 

D. EXAMPLE 

E. SAMPLE 

Answer:

USERS This tablespace is used to store permanent user objects and data. Like the TEMP tablespace, every database should have a tablespace for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM tablespace, which is not good practice. In the preconfigured database, USERS is assigned the default tablespace, and space for all objects created by non-system users comes from this tablespace. For system users, the default permanent tablespace remains SYSTEM. REF.: Oracle(r) 10g 2 Days DBA, 6-7 


Refresh 1z0-034 exam cram:

Q66. Identify three key features of Oracle Data Pump (Choose three.) 

A. Data Pump can stop a running job and resume it later 

B. Data Pump can perform import using database link 

C. Data Pump uses absolute path instead of relative path 

D. Data Pump uses relative path instead of absolute path 

E. Data Pump can perform incremental and cumulative exports 

Answer: A,B,D 


Q67. You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. 

What must you set using the RMAN CONFIGURE command to achieve this? 

A. MAXSETSIZE TO 2; 

B. DEVICE TYPE DISK PARALLELISM 2; 

C. RETENTION POLICY TO REDUNDANCY 2; 

D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; 

Answer:

Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link) 


Q68. What two are the prerequisites for enabling Flashback Database? 

A. The database must be in ARCHIVELOG mode 

B. The database must be in MOUNT EXCLUSIVE mode 

C. The database must be opened in RESTRICTED mode 

D. The database instance must be started in the NOMOUNT state 

E. The database instance must have the keep buffer pool defined 

Answer: A,B 


Q69. 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 Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem. 

What would you suggest to analyze this performance problem for the user? 

A. SQL Tuning Advisor 

B. SQL Performance Analyzer 

C. Active Session History report 

D. AWR Compare Periods report 

Answer:


Q70. memory_target big integer 808M 

pga_aggregate_target big integer 0 

sga_target big integer 0 

SQL> SHOW PARAMETER SGA_MAX_SIZE 

NAME TYPE VALUE 

sga_max_size big integer 808M 

Which statement is correct about the database? 

A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set. 

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and 

C. SGA_TARGET are set. 

D. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set. 

E. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup. 

Answer: