1z0-034 | Guaranteed Database 11g 1z0-034 exam dumps
Q31. Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?
A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.
Answer: C
Q32. In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?
A. to change a unique index into a non-unique index
B. to change index storage options
C. to enable index monitoring
D. to move the index to another tablespace
E. to improve performance of an INDEX CLUSTER
Answer: B,D
Q33. 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
Answer: D
http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/memory.htm#47750
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.
Q34. ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
Answer: C
Q35. 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
Answer: C
Q36. You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.
From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?
A. The EVEN parameter was not set.
B. The SQL_TRACE parameter is set to FALSE.
C. Enterprise Manager is not used.
D. The STATISTICS_LEVEL parameter is set to BASIC.
E. The TIMED_STATISTICS parameter is set to FALSE.
Answer: D
Q37. Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*;
RKAN>RUN
{
ALLOCATECHANNELchlDEVICETYPEDISK;
EXECUTESCRIPTfull_backup;
}
Which statement is true when the RMAN run block is executed?
A. The execution of the script fails because multiple channels cannot coexist.
B. The script is executed and both the channels are used for the script execution.
C. The new channel, CH1, is ignored because a channel has been configured already.
D. The persistent configuration parameter DC1 is overridden because a new channel is allocated in the RMAN run block.
Answer: D
Q38. Which two statements are true about encrypting RMAN backups?
A. The transparent encryption of backups uses the encryption wallet.
B. The database uses the same encryption key for every encrypted backup.
C. The password encryption of backups only uses the password while creating and restoring backups.
D. If transparent encryption is configured, you cannot use the set encryption by password command to make password-protected backups.
Answer: A,C
Q39. 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
Answer: A,B,C
Q40. Refer to the exhibit.
Examine the Following commands and their output:
View the Exhibit and examine the Flashback Version Query that was executed after the preceding commands.
What could be the possible cause for the query not displaying any row?
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
Answer: B