Master the 1Z0-053 Oracle Database 11g: Administration II content and be ready for exam day success quickly with this Testking 1Z0-053 free practice questions. We guarantee it!We make it a reality and give you real 1Z0-053 questions in our Oracle 1Z0-053 braindumps.Latest 100% VALID Oracle 1Z0-053 Exam Questions Dumps at below page. You can use our Oracle 1Z0-053 braindumps and pass your exam.
♥♥ 2018 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
Q191. During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?
A. The installation terminates with an error.
B. The installation proceeds with the default value without warnings and errors.
C. The installation proceeds with the default value but it would not be an OFA-compliant database.
D. The installation proceeds with the default value but a message would be generated in the alert log file.
Q192. Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)
A. until time
B. until change
C. until sequence
D. until SCN
E. until commit
Q193. While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?
A. RECOVER FILE=1201 BLOCK=1968;
B. RECOVER CORRUPTION LIST;
C. RECOVER DATAFILE 1201 BLOCK 1968;
D. RECOVER BLOCK CORRUPTION LIST;
E. None of the above
Q194. Evaluate the following command and its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
--------------------------- -------------------------- --------------------------- -------------------
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)
A. FREE_SPACE indicates only the space that is currently unallocated.
B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
Q195. You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
A. to minimize plan regression due to the use of a new optimizer version
B. to completely avoid the use of new plans generated by a new optimizer version
C. to prevent plan capturing when the SQL statement is executed after the database upgrade
D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
Q196. What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?
A. 100KB default, 10TB maximum
B. 256KB default, 1024MB maximum
C. 10MB default, 126PB maximum
D. 64KB default, 1EB maximum
E. 1MB default, 64MB maximum
Q197. View the Exhibits: Exhibit 1 and Exhibit 2.
Both processes use an existing job template PROG_1. The time taken by the Jobs is recorded in the TEST_LOG table.
It was observed that the job creation process in Exhibit 1 takes less time than In Exhibit2.
What is the reason for this?
A. It creates less metadata for jobs.
B. It creates Jobs temporarily in memory only.
C. It writes the Job metadata to disk in compressed format.
D. It updates tables In the SYSTEM tablespace instead of creating new tables.
Q198. Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)
A. Schedule objects
B. Program arguments
C. Job classes
D. Job arguments
E. All of the above
Q199. Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
A. It can be used to back up all data on ASM disks.
B. It can be used to recover the damaged ASM disk group along with the data.
C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
D. It can be used to re-create the ASM disk group with its attributes.
Q200. You want to migrate your database to ASM, so you've done a clean shutdown, made a closed backup of the entire database, noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?
1. STARTUP NOMOUNT
2. ALTER DATABASE OPEN RESETLOGS
3. SQL "ALTER DATABASE RENAME `logfile1 path' TO `+dgrp4 `" # plus all other logfiles
4. SWITCH DATABASE TO COPY
5. BACKUP AS COPY DATABASE FORMAT `+dgrp4'
6. ALTER DATABASE MOUNT
7. RESTORE CONTROLFILE FROM `controlfile_location'
A. 2, 5, 3, 1, 7, 6, 4
B. 1, 7, 6, 5, 4, 3, 2
C. 5, 1, 2, 7, 4, 6, 3
D. 7, 3, 1, 5, 6, 2, 4