Want to know Ucertify 1Z0-053 Exam practice test features? Want to lear more about Oracle Oracle Database 11g: Administration II certification experience? Study Refined Oracle 1Z0-053 answers to Up to the minute 1Z0-053 questions at Ucertify. Gat a success with an absolute guarantee to pass Oracle 1Z0-053 (Oracle Database 11g: Administration II) test on your first attempt.


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

Q31. Which statement about Automatic Memory Management with Oracle 11g is true? 

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

Answer: B


Q32. USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

A. Use Data Pump to transfer the existing data to a new encrypted tablespace.

B. Use ALTER TABLE. MOVE to transfer the existing data to a new encrypted tablespace.

C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.

D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.

E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.

Answer: ABC


Q33. What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?

A. Channel failover

B. Restartable backups

C. Rescheduable backups

D. Automatic backup recovery

E. Channel recovery

Answer: A


Q34. You executed the following command:

RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'

Which statement regarding the above command is correct? 

A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.

B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.

C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.

D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.

Answer: C


Q35. What is the end result of the following commands?

recover tablespace users

until time `10/06/2008:22:42:00'

auxiliary destination `c:\\oracle\\auxiliary'

sql 'alter tablespace users online'

recover tablespace users

until time `10/06/2008:20:40:00'

auxiliary destination `c:\\oracle\\auxiliary'

sql 'alter tablespace users online'

A. The commands will be successful. The USERS tablespace will be recovered until 10/06/2008 at 20:40.

B. The first recover tablespace command will fail because the syntax is incorrect.

C. The first alter tablespace users online command will fail because the tablespace will already be online after the recover command.

D. The second recover tablespace command will fail because it will be unable to complete the recovery.

E. The second alter tablespace users online command will fail because you cannot perform two TSPITRs in a row without backing up the database between the first and the last recovery.

Answer: D


Q36. A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?

A. Initiate an incomplete recovery operation using RMAN.

B. Copy the table from a development database.

C. Advise the user to rekey the data.

D. Perform a Flashback Drop operation.

E. Perform a Flashback Recovery operation.

Answer: D


Q37. Which of the following statements best describes Flashback Versions Query?

A. Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

B. Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.

C. Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

D. Flashback Versions Query is used to view all version changes on rows that existed between two points in time.

Answer: D


Q38. Evaluate the following command:

SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'

What is the impact of this setting on the usage of SecureFiles?

A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.

B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB.

C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB.

D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile.

Answer: A


Q39. You run the following commands:

RMAN> list expired backup;

RMAN> delete expired backup;

What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?

A. They will be renamed.

B. Nothing will happen to them. The backup set pieces do not exist.

C. They will be deleted immediately since they are not in the flash recovery area.

D. You will need to manually remove the physical files listed in the output of the commands.

E. They will become hidden files and removed 10 days later.

Answer: B


Q40. You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:

RMAN> CONNECT CATALOG rco11/password@catdb

RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;

Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

A. They import all metadata from the RCAT10 catalog.

B. They unregister the database from the RCAT10 catalog.

C. They do not register the databases registered in the RCAT10 catalog.

D. They register all databases registered in the RCAT10 catalog.

Answer: AD