1Z0-053 Online Practice Questions and Answers

What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?

A. 100KB default, 10TB maximum

B. 256KB default, 1024MB maximum

C. 10MB default, 126PB maximum

D. 64KB default, 1EB maximum

E. 1MB default, 64MB maximum

Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?

A. PLSQL_BLOCK

B. JAVA_STORED_PROCEDURE

C. STORED_PROCEDURE

D. EXECUTABLE

E. None of the above are invalid settings.

Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?

A. Username, instance number, session ID

B. Instance number, username, session ID

C. Instance number, session ID, username

D. Username, session ID, instance number

E. None of the above

In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?

A. Setting a nonzero value for SGA_TARGET

B. Configuring Automatic Shared Memory Management

C. Configuring Automatic Memory Management

D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

E. None of the above

What view might you use to try to determine how long a particular backup will take?

A. V$SESSION_EVENT

B. V$SESSION

C. V$WAITS

D. V$WAITSTAT

E. V$SESSION_LONGOPS

Which method would you use to undo the changes made by a particular transaction without affecting the made by other transactions?

A. Point-in-time recovery

B. Execute the ROLLBACK command with transaction number

C. Flashback the database to before the transaction was committed

D. Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?

A. A different procedure is required to restore a database from compressed backups

B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

C. Using this command to create backups minimizes the bandwidth consumed

D. Using this command to create backups improves the performance of the backup process

You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

A. Data Pump Export and Import

B. conventional export and import

C. the CONVERT command of RMAN

D. the BACKUP AS COPY command of RMAN

Which two statements are true about an image copy backup? (Choose two.)

A. It may only be taken to disk.

B. It will contain only the used blocks.

C. It will contain all used and unused blocks.

D. It can be performed on disk as well as on tape.

You want to make sure that your database backup does not exceed 10 hours in length.

What command would you issue that would meet this condition?

A. backup database plus archivelog;

B. backup database plus archivelog until time 10:00;

C. backup database plus archivelog timeout 10:00;

D. backup database plus archivelog duration 10:00;

E. backup database plus archivelog timeout 10:00;