We provide real 1Z0-053 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-053 Exam quickly & easily. The 1Z0-053 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-053 dumps pdf and vce product and material, you can easily pass the 1Z0-053 exam.


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

Q151. Evaluate the following function code:

CREATE FUNCTION get_dept_avg(dept_id NUMBER)

RETURN NUMBER

RESULT_CACHE RELIES_ON (EMPLOYEES)

IS

avgsal NUMBER(6);

BEGIN

SELECT AVG(SALARY)INTO avgsal

FROM EMPLOYEES

WHERE DEPARTMENT_ID = dept_id;

RETURN avgsal;

END get_dept_avg;

Which statement is true regarding the above function?

A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.

C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.

D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.

Answer: A


Q152. The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?

A. Languages for server messages

B. Day and month names and abbreviations

C. Symbols to represent a.m., p.m., AD, and BC

D. Affirmative and negative response strings (YES, NO)

E. None of the above

F. All of the above

Answer: F


Q153. 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


Q154. If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

A. The alter database archivelog command will fail.

B. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.

C. The alter database archivelog command will succeed.

D. The alter database archivelog command will ask if you want to make the database consistent first.

E. There is no alter database archivelog command. The correct command is alter database 

alterlogging.

Answer: A


Q155. You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two).

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database

Answer: AD


Q156. 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: ABC


Q157. Why would you run the delete obsolete command? (Choose all that apply.)

A. To remove missing backup set pieces physically from disk

B. To remove metadata related to backup set pieces in the control file and the recovery catalog 

C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets

D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria

E. To remove old versions of RMAN backups

Answer: CD


Q158. You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup.

You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)

A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.

B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.

C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.

D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

Answer: BCD


Q159. Which of these formats represents the correct hierarchy for the ADR?

A. <diagnostic_dest>/rdbms/diag/<dbname>/<instname>

B. <diagnostic_dest>/diag/rdbms/<instname>/<dbname>

C. <diagnostic_dest>/diag/rdbms/<dbname>/<instname>

D. None of the above

Answer: C


Q160. Which command is used to begin a tablespace point-in-time recovery?

A. Restore tablespace

B. Recover tablespace

C. Tablespace recover

D. Recover to time

E. recover datafile

Answer: B