1Z0-053 Online Practice Questions and Answers

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

A. It can be used to allow the access privilege settings for users but not roles.

B. It can be used to allow the access privilege settings for users as well as roles.

C. It can be used to control the time interval for which the access privilege is available to a user.

D. It can be used to selectively restrict the access for each user in a database to different host computers.

E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

Which of the following advisors is run in every maintenance window by the auto-task system?

A. The Memory Advisor

B. The SQL Tuning Advisor

C. The Undo Advisor

D. The SQL Access Advisor

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

A. Automatic PGA Memory Management

B. Automatic SGA Memory Management

C. Automatic Shared Memory Management

D. Automatic Memory Management

E. Manual SGA Memory Management

F. None of the above

View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident? Exhibit:

A. The incident has been newly created and is in the process of collecting diagnostic information.

B. The incident is now in the Done state and the ADR can select the incident to be purged.

C. The DBA is working on the incident and prefers that the incident be kept in the ADR.

D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.

Which of the following is NOT an advantage of block media recovery (BMR)?

A. Reduced MTTR.

B. Datafiles remain offline while corrupt blocks are repaired.

C. Datafiles remain online while corrupt blocks are repaired.

D. A and C

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).

Which two are the prerequisites to perform this operation? (Choose two)

A. You must configure block change tracking file

B. You must have first level 1 backups for RMAN to restore blocks

C. You must ensure that the SALES database is mounted or open

D. You must have full or level 0 backups for RMAN to restore blocks

E. You must take the tools01.dbf data file offline before you start a block media recovery

When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)

A. Tablespace name

B. Storage quota

C. Retention

D. Table name

E. Create a default archive

You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?

a.

restore controlfile until time '09/30/2008:18:00:00';

b.

restore database until time '09/30/2008:18:00:00';

c.

restore spfile until time '09/30/2008:18:00:00';

d.

recover database until time '09/30/2008:18:00:00';

e.

alter database open resetlogs;

f.

alter database open;

A.

b, d, e

B.

b, d, f

C.

c, a, b, d, e

D.

c, a, b, d, f

E.

a, b, d, e

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:

RESTORE CONTROLFILE FROM AUTOBACKUP;

Which of the following statements is true? (Choose all that apply.)

A. The command restores only the missing control file.

B. The command restores all the control files.

C. The command fails because the database is running.

D. This is the correct way to address this problem.

E. This is not the correct way to address this problem.

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece