we provide Refined Oracle 1Z0-053 exam engine which are the best for clearing 1Z0-053 test, and to get certified by Oracle Oracle Database 11g: Administration II. The 1Z0-053 Questions & Answers covers all the knowledge points of the real 1Z0-053 exam. Crack your Oracle 1Z0-053 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-053 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-053 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-053-exam-dumps.html
Q161. Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.
(Choose two.)
A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots
Answer: AC
Q162. When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE
Answer: E
Q163. Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)
A. You can add or remove the trace files to the package.
B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
C. You can add SQL test cases to the incident package.
D. You cannot create an incremental incident package when the physical files are purged rom the ADR.
Answer: ABC
Q164. Consider the following command:
Backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
Control-file a NN uto backups were enabled.
NN The size of backup sets was not restricted.
NN One channel was allocated.
A. 1
B. 2
C. 3
D. 4
E. 5
Answer: D
Q165. Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback opertion
Answer: A
Q166. You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?
A. Create and populate a SQL Tuning Set from the AWR on every Monday.
B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
C. Create a repeating baseline template.
D. Insert a finding directive for future ADDM tasks.
Answer: C
Q167. What is the proper procedure to recover a lost tempfile?
A. Restore the backup copy of the tempfile from the backup media.
B. Re-create the tempfile with the create tempfile command.
C. Copy an existing tempfile from another database.
D. Re-create the tempfile with the create tablespace command.
E. Re-create the tempfile with the alter tablespace command.
Answer: E
Q168. If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?
A. The command fails unless you specify the FORCE option.
B. The command fails unless you specify the REUSE option.
C. The command must be reissued with a more specific discovery string.
D. The other disks, already part of the disk group, are ignored.
Answer: D
Q169. You issue the following command:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?
A. An incremental backup strategy will be used automatically.
B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
C. RMAN will configure itself for maximum performance at the cost of CPU.
D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
E. RMAN will automatically compress backups.
Answer: B
Q170. Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)
A. View long-running SQL workloads
B. View problem details
C. Gather additional diagnostic information
D. Create a Service Request
E. Clean up incident data after upload to Oracle Support
Answer: AE