1Z0-053 | The Secret of Oracle 1Z0-053 exam


Q321. Which of these represent the main components of Database Resource Manager? (Choose all that apply.)

A. Resource consumer groups

B. Resource plans

C. Resource-plan groups

D. Resource-plan directives

E. All of the above

Answer: ABD

Q322. What is the name of the file that identifies the set of available locale definitions?

A. locale.def

B. lxdef.ora

C. lx1boot.nlb

D. lx1boot.ora

E. lang.def

Answer: C

Q323. Examine the following scenario:

- Database is running in ARCHIVELOG mode.

- Complete consistent backup is taken every Sunday.

- On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted

- The disk having active online redo log files is also corrupted.

- The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?

A. Restore the latest whole backup, perform complete recovery, and open the database normally

B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.

C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.

D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.

Answer: D

Q324. You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. What is the correct solution? 

A. Restore the SYSTEM tablespace from the last backup set and then recover the database.

B. Restore the SYSTEM tablespace image copy using the restore command and then restore the database.

C. Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open the database.

D. The database is not recoverable in this situation with image copies.

E. Manually copy the datafile image copy to the correct location and then manually restore the database from SQL*Plus.

Answer: C

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

Q326. You issue the following RMAN command to set a retention policy on a database:

RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

What will be the outcome of issuing this command?

A. After two days, a backup will be marked obsolete

B. After two days, a backup will be deleted from the media

C. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

Answer: D

Q327. The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

A. The optimizer adds the new plan to the plan history.

B. The optimizer selects the new plan for the execution of the SQL statement.

C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.

D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

Answer: AE

Q328. If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?

A. TS_OBJECTS_TO_BE_DROPPED

B. TS_PTTR_OBJECT_DROPPED

C. TS_PITR_OBJECTS_TO_BE_DROPPED

D. TS_OBJECTS_DROPPED

E. TS_DROPPED_OBJECTS

Answer: C

Q329. What does it mean if a backup is expired?

A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.

B. The backup set has one or more invalid blocks in it and is not usable for recovery.

C. The backup set contains one or more tablespaces no longer in the database.

D. The backup set contains one or more missing backup set pieces.

E. The backup set is from a previous version of RMAN and was not upgraded.

Answer: D

Q330. You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value. Which of these actions is appropriate?

A. Abort the session, fix the space problem, then resubmit the transaction.

B. Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend the time-out for the session while you fix the problem.

C. Do nothing, let the transaction fail, then fix the problem.

D. Use Segment Shrink to clean up the table.

E. Use the DBMS_RESUMABLE.SET_TIMEOUT procedure to extend the time-out for the session while you fix the problem.

Answer: B