1Z0-053 | The Secret of Oracle 1Z0-053 braindumps
Q81. Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)
A. Undo retention guarantee for the database must be configured.
B. Supplemental log must be enabled for the primary key.
C. Supplemental log must be enabled.
D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
Answer: BCD
Q82. By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?
A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above
Answer: C
Q83. Which of the following is not a valid calendaring syntax element?
A. FREQ
B. BYHOUR
C. RUNDATE
D. INTERVAL
E. BYMINUTE
Answer: C
Q84. You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
Answer: D
Q85. Which two statements about workload capture and replay operations are true? (Choose two.)
A. The clients must be created manually on the test machines to perform more realistic testing.
B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
Answer: CD
Q86. What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)
A. RECOVERY_CATALOG_OWNER
B. DBA
C. RESOURCE
D. SELECT ANY DICTIONARY
E. CONNECT
Answer: AC
Q87. A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?
A. Initiate an incomplete recovery operation using RMAN.
B. Copy the table from a development database.
C. Advise the user to rekey the data.
D. Perform a Flashback Drop operation.
E. Perform a Flashback Recovery operation.
Answer: D
Q88. Every resource plan must contain an allocation to which consumer group?
A. LOW_GROUP
B. SYS_GROUP
C. DEFAULT_GROUP
D. BASE_GROUP
E. OTHER_GROUPS
Answer: E
Q89. You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.
Which statement about performing user-managed backups in a 24x7 environment is true?
A. You must have change tracking enabled in your database
B. Your database must be running in NOARCHIVELOG mode
C. To back up a tablespace, it must be in backup mode
D. To back up a tablespace, it must first be taken offline
Answer: C
Q90. You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?
1. Take the datafiles that were lost offline.
2. startup mount the database
3. Issue the alter database open command.
4. Restore the datafiles that were lost
5. Recover the datafiles with the recover datafile command.
6. Bring the datafiles back online.
7. Recover the database with the recover database command.
A. 2, 1, 3, 4, 5, 6
B. 2, 4, 5, 3
C. 4, 7, 3
D. 2, 4, 7, 3
E. 2, 7, 3
Answer: B