Master the 1Z0-053 Oracle Database 11g: Administration II content and be ready for exam day success quickly with this Actualtests 1Z0-053 exam fees. 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.


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

Q381. Which command is used to configure RMAN to perform a compressed backup for every backup executed?

A. BACKUP AS COMPRESSED BACKUPSET DATABASE

B. BACKUP AS COMPRESSED COPY OF DATABASE

C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET

D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS

E. BACKUP DATABASE COMPRESS

Answer: C


Q382. What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

A. An upper limit on how far you can flash back the database, depending on the information in the redo logs

B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space

Answer: C


Q383. You executed the following PL/SQL block successfully:

VARIABLE tname VARCHAR2(20)

BEGIN

dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage', FINDING_NAME=>'CPU Usage',

MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90);

:tname := 'database ADDM task4'

dbms_addm.analyze_db(:tname, 150, 162);

END;

/

Then you executed the following command:

SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;

The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

A. with the CPU Usage finding if it is less than 90

B. without the CPU Usage finding if it is less than 90

C. with the CPU Usage finding for snapshots below 90

D. with the CPU Usage finding for snapshots not between 150 and 162 

Answer: B


Q384. Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover

B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

Answer: CD


Q385. How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already 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: A


Q386. Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)

A. It bypasses the OS file system cache.

B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.

C. It uses the operating system kernel NFS layer for user tasks and network communication modules.

D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.

E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.

Answer: AE


Q387. In a Database Replay workload capture, what client request information is gathered? (Choose all that apply.)

A. SQL text

B. Shared server requests (Oracle MTS)

C. Bind variable values

D. Information about transactions

E. Remote DESCRIBE and COMMIT operations

Answer: ACD


Q388. The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)

select d.platform_name "Source", t.platform_name

"Compatible Targets", endian_format

from v$transportable_platform t, v$database d

where t.endian_format = (select endian_format

from v$transportable_platform t,

v$database d

where d.platform_name =

A. platform_name);

B. The list of target platforms having the same endian format as the source database

C. The list of target platforms requiring endian conversion

D. The list of target platforms that will not require endian conversion

E. The list of all target platforms that can receive transportable tablespaces from the source database

F. None of the above

Answer: AC


Q389. What will be the result of the following configuration?

Log_archive_dest_1='location=c:\oracle\arch\mydb'

Log_archive_dest_2='location=z:\oracle\arch\mydb'

A. An error will occur during database startup because the second parameter is not valid.

B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.

C. Archived redo logs will be created in two different locations by the ARCH process.

D. Archived redo logs will be created in two different locations by the LGWR process.

E. Neither parameter setting is valid, so the database will not start up.

Answer: C


Q390. While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the orruption?

A. restore database until time

'06-SEP-2008 06:30:00');

recover database until time

'06-SEP-2008 06:30:00');

alter database open;

B. restore database until time

'06-SEP-2008 06:30:00');

recover database until time

'06-SEP-2008 06:30:00');

alter database open resetlogs;

C. restore database until time

'06-SEP-2008 18:29:55');

recover database until time

'06-SEP-2008 18:29:55');

alter database open resetlogs;

D. restore database until time '06-SEP-2008 18:29:55');

alter database open resetlogs;

E. restore database until time '06-SEP-2008 18:29:55');

recover database;

alter database open resetlogs;

Answer: C