Exam Code: 1Z0-053 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Administration II
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 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

Q221. How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?

A. Issue the ALTER DISKGROUP ... ADD DISK command.

B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.

C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

D. Retrieve the disk from the Recycle Bin after the operation completes.

Answer: B


Q222. You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.

SQL> startup

ORACLE instance started.

Total System Global Area 167395328 bytes

Fixed Size 1298612 bytes

Variable Size 142610252 bytes

Database Buffers 20971520 bytes

Redo Buffers 2514944 bytes

Database mounted.

ORA-00313: open failed for members of log group 2 of thread 1

ORA-00312: online log 2 thread 1: `/oracle01/oradata/orcl/redo02a.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

ORA-00312: online log 2 thread 1: `/oracle01/oradata/orcl/redo02.log'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

SQL> alter database clear logfile group 2;

alter database clear logfile group 2

*

ERROR at line 1:

ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)

ORA-00312: online log 2 thread 1: `/oracle01/oradata/orcl/redo02.log'

ORA-00312: online log 2 thread 1: `/oracle01/oradata/orcl/redo02a.log'

What steps must you take to resolve the error?

a. Issue the recover database redo logs command.

b. Issue the Startup Mount command to mount the database.

c. Restore the last full database backup.

d. Perform a point-in-time recovery, applying all archived redo logs that are available.

e. Restore all archived redo logs generated during and after the last full database backup.

f. Open the database using the alter database open resetlogs command.

g. Issue the alter database open command.

A. b, a, f

B. e, b, a, f

C. e, b, a, g

D. b, a, g

E. c, e, b, d, f

Answer: E


Q223. What is an obsolete backup set?

A. A backup set that is missing one or more backup set pieces

B. A backup that has exceeded the retention criteria and is no longer needed

C. A backup set that does not include archived redo logs

D. A backup set that can not be recovered due to corruption

E. A backup set superceded by a datafile copy

Answer: B


Q224. Which of the following NLS_SORT parameter values would result in case-insensitive and accent- insensitive binary sorts?

A. NLS_SORT = BINARY

B. NLS_SORT = BINARY_AI

C. NLS_SORT = BINARY_CI

D. NLS_SORT = BINARY_AI_CI

E. Binary sorts are case insensitive and accent insensitive by default.

Answer: B


Q225. View the following SQL statements:

Transaction T1

INSERT INTO hr.regions VALUES (5,'Pole');

COMMIT;

Transaction T2

UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5;

COMMIT;

Transaction T3

UPDATE hr.regions SET region_name='North and South Poles' WHERE

region_id = 5;

You want to back out transaction T2. Which option would you use? 

A. It is possible, but transaction T3 also backs out.

B. It is possible with the NOCASCADE_FORCE option.

C. It is possible with the NONCONFLICT_ONLY option.

D. It is not possible because it has conflicts with transaction T3.

Answer: B


Q226. An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:

SQL>CREATE INDEX ord_custname_ix ON orders(custname);

The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.

You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.

Which is the most efficient method of performing this task? 

A. disabling the index

B. making the index invisible

C. making the index unusable

D. using the MONITORING USAGE clause for the index

Answer: B


Q227. Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?

A. ASMB

B. PMON

C. RBAL

D. SMON

Answer: A


Q228. Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do?

A. Restore the 19th's backup, restore all archived redo logs, recover the database to the 20th, and open the database.

B. Tell them that their request cannot be met with the current backup strategy.

C. Restore the 19th's backup, apply the online redo logs, and open the database.

D. Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.

E. Use the recover database command to roll back the database from today to the 19th of the month.

Answer: B


Q229. Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.

B. The incident files and dumps are not retained in the ADR for the manually created incidents.

C. The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR

D. The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month.

Answer: D


Q230. Which two statements are true regarding hot patching? (Choose two.)

A. It requires relinking of the Oracle binary.

B. It does not require database instance shutdown.

C. It can detect conflicts between two online patches.

D. It is available for installing all patches on all platforms.

E. It works only in a single database instance environment.

Answer: BC