1z0-034 | A Review Of Best Quality 1z0-034 braindumps
Q61. 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?
A. Implement a profile for the users.
B. Implement external roles for the users.
C. Set the threshold for the undo tablespace.
D. Implement a Database Resource Manager plan.
Answer: B
Q62. 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: C
Q63. 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: B
Q64. 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: D
Q65. 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 command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?
A. You should perform a log switch
B. You should make a backup of the database
C. You should switch the database to the NOARCHIVELOG mode
D. You should shut down the database instance and perform a complete database recovery
Answer: B
Q66. 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 occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb;
}
Which statement is true about the duplicate database in this scenario?
A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database
Answer: D
Q67. Which three statements are true about windows?
A. Only one window can be open at any given time
B. Consumer groups are associated with windows
C. Windows work with job classes to control resource allocation
D. The database service name must be provided during windows creation
E. Windows can automatically start job or change resource allocation among jobs for various time periods.
Answer: A,C,E
Q68. There was media failure and you decide to check the data files for block corruption. Which would you use to create a report on any corruptions found?
A. the DBNEWID utility
B. the DBVERIFY utility
C. the ANALYZE command
D. the RMAN REPORT command
E. the RMAN CROSSCHECK command
F. the CHECK_OBJECT procedure of the DBMS_REPAIR package
Answer: B
Q69. 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: D
Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link)
Q70. The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?
A. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
B. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.
D. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.
E. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.
Answer: A