Oracle Database 11g: Administration II (1Z0-053) Free Practice Test

Question 1

You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?

A. update catalog

B. resync catalog

C. synch catalog

D. replicate catalog

E. restore catalog

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate abnormally.
Which statement about the DATA1 tablespace is true?

A. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

B. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

C. If you restart the database, the database will not be opened.

D. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.
You can use Segment Advisor to _____.

A. automatically shrink the segments with unused space

B. check the alerts generated for the tablespace that is running low on space

C. modify the storage parameters for the tablespace

D. identify the segments that you should shrink

Correct Answer: D

Question 4

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

A. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

B. It returns space usage of only BasicFile LOB chunks.

C. It returns space usage of only SecureFile LOB chunks.

D. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

A. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

B. It automates the resource allocation for the Automated Maintenance Tasks.

C. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRU

D. It improves the performance of the performance-critical sessions while running.

E. Only one I/O calibration process can run at a time.

Correct Answer: A,C,E

Question 6

Examine the output of the query that you executed to list the objects in the recycle bin:

You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:
SQL> PURGE TABLE sales_tab;
What would be the outcome of this command?

A. All three tables in the recycle bin are purged

B. Only the table with the latest DROPSCN is purged

C. Only the table with the oldest DROPSCN is purged

D. The command returns an error because multiple entries with the same name exist in the recycle bin

Correct Answer: C

Question 7

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

A. Configuring Automatic Shared Memory Management

B. None of the above

C. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

D. Configuring Automatic Memory Management

E. Setting a nonzero value for SGA_TARGET

Correct Answer: A

Question 8

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.
Which statement about the result is true?

A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.

B. The database instance starts, but Automatic Memory Management is disabled.

C. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.

D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.

Correct Answer: C

Question 9

To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)

A. JOB_LOG_RETENTION

B. LOG_NAME

C. WHICH_LOG

D. WINDOW_LOG_RETENTION

E. LOG_HISTORY

Correct Answer: C,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

Which dynamic view displays the status of block-change tracking?

A. V$BLOCK_CHANGE

B. V$BLOCKCHANGE

C. V$BLOCK_TRACKING

D. V$BLOCK_CHANGE_TRACKING

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 11

You are trying to recover your database. During the recovery process, you receive the following error:
ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1
ORA-00289: suggestion: /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /
o1_mf_1_11_%u_.arc
ORA-00280: change 5033391 for thread 1 is in sequence #11
ORA-00278: log file '/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /
o1_mf_1_10_4bj6wnqm_.arc' no longer needed for this recovery Specify log:
{<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/oracle01/flash_recovery_area/ORCL/
archivelog/2008_08_17 /o1_mf_1_11_%u_.arc'
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory
Additional information: 3
How do you respond to this error? (Choose two.)

A. Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available.

B. Restore the archived redo log that is missing and attempt recovery again.

C. Recover the entire database and apply all archived redo logs again.

D. Recovery is not possible because an archived redo log has been lost.

E. Recovery is complete and you can open the database.

Correct Answer: A,B

Question 12

As part of archiving the historical data, you want to transfer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online. The source and target databases use the same compatibility level and character sets. View the Exhibit and examine the features in the source and target database.
Which of the following steps are required to transport a tablespace from the database to the target database:
1.Make the tablespace read-only at the source database.
2.Export metadata from the source database.
3.Convert data filed by using Recovery Manager (RMAN).
4.Transfer the dump file and data filed to the target machine.
5.Import metadata at the target database.
6.Make the tablespace read/write at the target database.
Exhibit:

A. 1, 2, 4, 5 and 6

B. 2, 3, 4 and 5

C. All the steps

D. 2, 4, and 5

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Database 11g: Administration II (1Z0-053) Free Practice Test