Cause all that matters here is passing the Oracle 1z0-034 exam. Cause all that you need is a high score of 1z0-034 Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP exam. The only one thing you need to do is downloading Actualtests 1z0-034 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-034 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q41. 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
Q42. You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.
After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
A. The command produces an error because the retention time cannot be reduced.
B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data older than three years is purged from the flashback archive FLA1.
Q43. You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?
A. The online redo log files and archived redo log files are required to accomplish the recovery
B. The uncommitted transaction will be committed at the next startup of the database instance
C. The uncommitted transaction is rolled back automatically at the next opening of the database
D. The DBA has to perform the recovery on the database to recover the uncommitted transaction
Q44. 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.
Q45. Which three tasks can be performed using a duplicate database? (Choose three.)
A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover
Q46. Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)
A. configuring control file autobackup to be ON
B. backing up data filed only and not the archived redo log files
C. running the recovery catalog database in NOARCHIVELOG mode.
D. setting the retention policy to a REDUNDANCY value greater than 1
E. backing up the recovery catalog to the same disk as that of the target database
Refer to here.
Configuring the Recovery Catalog Database
When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema.
The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog.
Decide which database you will use to install the recovery catalog schema, and also how you will back up this database. Also, decide whether to operate the catalog database in ARCHIVELOG mode, which is recommended.
Note: Do not use the target database to be backed up as the database for the recovery catalog.
The recovery catalog must be protected if the target database is lost.
Q47. 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 performed and the content of the disk group not empty in Exhibit2?
ASM-disk-group-1 (exhibit): ASM-disk-group-2 (exhibit):
A. Because the disk group is created with NORMAL redundancy
B. Because the disk repair time attribute is set to a nonzero value
C. Because the mirrored extents cannot be rebalanced across the other three disks
D. Because the other three disks have 60% free space, the disk rebalancing is delayed
1. The COMPATIBILITY.ASM>=11.1 and COMPATIBILITY.RDBMS>=11.1
2. The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr.
Refer to here.
Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For
more information, refer to "Disk Group Compatibility".
Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought back online. By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.
Q48. Examine the parameter settings in your database.
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 SGA_TARGET are set.
C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET andSGA_TARGET are set.
D. Automatic memory management is enabled and, as per 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
Configuring Automatic PGA Memory When configuring a brand new instance, it is hard to know precisely the appropriate setting for PGA_AGGREGATE_TARGET. You can determine this setting in three stages:
Make a first estimate for PGA_AGGREGATE_TARGET, based on a rule of thumb. By default, Oracle uses 20% of the SGA size. However, this initial setting may be too low for a large DSS system.
Run a representative workload on the instance and monitor performance, using PGA statistics collected by Oracle, to see whether the maximum PGA size is under-configured or over-configured.
Tune PGA_AGGREGATE_TARGET, using Oracle PGA advice statistics.
Q49. Examine the following scenario:
-Database is running in ARCHIVELOG mode.
-Complete consistent backup is taken every Sunday.
-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGSoption.
C. Restore the latest backups control file, perform complete recovery, and open the database with theRESETLOGS option.
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option.
Q50. 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.