最新的Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z0-034免費考試真題
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?
What would you suggest to analyze this performance problem for the user?
正確答案: A
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)
正確答案: C,D
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?
In addition, reports are generated using complex joins with non-equality operators.
What table organization is the best for this workload?
正確答案: D
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?
Which method must you use to recover the lost data?
正確答案: D
Which steps are mandatory to enable Direct NFS?
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11.so_stub with libodm11.so.
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11.so_stub with libodm11.so.
正確答案: D
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.
How would you achieve this?
How would you achieve this?
正確答案: A
Note the following parameter settings: Which setting is NOT allowed?
正確答案: D
View the following SQL statements: Transaction T1
SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT;
Transaction T2
SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT;
Transaction T3
SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?
SQL> INSERT INTO hr.regions 2 VALUES (5,'Pole'); 3 COMMIT;
Transaction T2
SQL> UPDATE hr.regions 2 SET region_name='Poles' 3 WHERE region_id = 5; 4 COMMIT;
Transaction T3
SQL> UPDATE hr.regions 2 SET region_name='North and South Poles' 3 WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?
正確答案: B
說明：（僅 Fast2test 成員可見）