Act now and download your Oracle 1Z0-053 test today! Do not waste time for the worthless Oracle 1Z0-053 tutorials. Download Down to date Oracle Oracle Database 11g: Administration II exam with real questions and answers and begin to learn Oracle 1Z0-053 with a classic professional.


♥♥ 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

Q271. Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.

Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)

A. redo logs

B. control file

C. temporary files of temporary tablespace

D. the latest backup of only the damaged data file

E. the latest backup of all the data files In the USERS tablespace

Answer: ABD


Q272. You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.

Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)

A. The ASM-preferred mirror read feature is enabled.

B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.

D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

Answer: AB


Q273. Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)

A. DBA_SCHEDULER_JOB_RUN_DETAILS

B. DBA_SCHEDULER_RUNNING_JOBS

C. DBA_SCHEDULER_CURRENT_JOBS

D. DBA_SCHEDULER_JOBS

E. DBA_SCHEDULER_EXECUTING_JOBS

Answer: BD


Q274. Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?

A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode.

B. Datafiles are not written to during hot backups.

C. Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

D. The datafile headers are not updated during the backup.

E. The way data is written to the online redo logs is unchanged during the backup.

Answer: D


Q275. What components are present in an ASM instance? (Choose three.)

A. SGA

B. Database processes

C. Database datafiles

D. Control files

E. Database parameter file or spfile

Answer: ABE


Q276. Which of the following is true about job chains?

A. They consist of one or more Scheduler programs.

B. They are used to implement dependency scheduling.

C. They are used to implement time-based scheduling.

D. They are used to implement event-based scheduling.

E. None of the above.

Answer: B


Q277. Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)

A. Limiting the input/output (I/O) bandwidth consumption

B. Specifying the size of backup sets and backup pieces

C. Specifying vendor-specific information for a media manager

D. Specifying the parallelism for backup and restore operations

Answer: AC


Q278. You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?

A. The Automatic Memory Manager (AMM)

B. The SQL Tuning Advisor

C. The Segment Advisor

D. The SQL Access Advisor

Answer: D


Q279. Choose the correct order to package and upload data for an incident to Oracle Support.

A. Schedule, create new package, view manifest, view contents

B. Create new package, view manifest, view contents, schedule

C. Schedule, create new package, view contents, view manifest

D. Create new package, view contents, view manifest, schedule

E. None of the above.

Answer: D


Q280. You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)

A. SYSTEM

B. SYSAUX

C. UNDO

D. USERS

E. TEMP

F. This restore is not possible.

Answer: ABCDE