Oracle Database 11g: Administration II that is 1z0-053 has the latest real questions and braindumps out .
here is some description of 1z0-053:
Exam Number/Code: 1Z0-053

Exam Name: Oracle Database 11g: Administration II

Questions and Answers: 313Q&As
passcert provides PDF&SOFTWARE version to download
below are some real questions and free demos of the test :
1. You work as a Database Administrator for Federal Inc. The company uses an Oracle database.
You create backups and copies by using the operating system commands. Now, you want to use
Recovery Manager (RMAN) for backup and recovery operations. Moreover, you want to use a recovery
catalog as the RMAN repository. Which of the following steps will you take to accomplish this?
Each correct answer represents a part of the solution. Choose all that apply.
A: Execute the CATALOG command.
B: Reset the recovery catalog.
C: Register the database with the recovery catalog.
D: Create a recovery catalog.
Answer: ACD
Explanation: Answer options D, C, and A are correct.
RMAN uses a central information repository called recovery catalog in order to store metadata about
backup and recovery operations. However, if a recovery catalog is not created, Recovery Manager uses
the target database's (the database that RMAN is backing up or restoring) control file as the RMAN
repository for storing the information necessary for backup and recovery operations. In this scenario, after
creating the recovery catalog, you will be required to register the target database with the recovery
catalog. The database must be registered with the recovery catalog before the recovery catalog can store
the metadata about backup and recovery operations performed in the database. After registering the
database, you will also be required to execute the CATALOG command. The CATALOG command adds
the information about the pre-existing backups and copies to the recovery catalog. Answer option B is
incorrect. A recovery catalog needs to be reset in order to work with a database that has been opened
using the RESETLOGS option. However, in this scenario, you do not need to reset the recovery catalog.
2. Which of the following dynamic performance views will you query to view the valid values for
NLS parameters NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY and NLS_CHARACTERSET?
A: NLS_INSTANCE_PARAMETERS
B: V$NLS_PARAMETERS
C: NLS_SESSION_PARAMETERS
D: V$NLS_VALID_VALUES
Answer: D
Explanation: Answer option D is correct.
The V$NLS_VALID_VALUES dynamic performance view lists valid values for the following:
NLS parameters: NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, NLS_CHARACTERSET.
Answer option B is incorrect. Answer option C is incorrect. NLS_SESSION_PARAMETERS shows the
NLS parameters and their values for the session that is querying the view. It does not show information
about the character set.Answer option A is incorrect. NLS_INSTANCE_PARAMETERS shows the current
NLS instance parameters that have been explicitly set and the values of the NLS instance parameters.
3. Brenda works as a Database Administrator for uCertify Inc. The company uses an Oracle
database. Brenda wants to specify a number of locations to which the redo logs should be archived
before an error occurs. Which of the following initialization parameters will she use to accomplish this?
A: LOG_ARCHIVE_DEST_STATE_n
B: LOG_ARCHIVE_DEST_n
C: LOG_ARCHIVE_MIN_SUCCEED_DEST
D: LOG_ARCHIVE_DUPLEX_DEST
Answer: C
Explanation: Answer option C is correct.
The LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter is used along with the
LOG_ARCHIVE_DUPLEX_DEST and LOG_ARCHIVE_DEST_n parameters. This parameter specifies
the number of archive destinations to which the redo logs must be written before an error occurs.
Answer option A is incorrect. The LOG_ARCHIVE_DEST_STATE_n parameter specifies whether or not
the archive destination accepts writing of redo logs. This parameter takes on three values,
ENABLE, DEFER, and ALTERNATE. The value ENABLE indicates that redo logs can be written to the
archive destination. The value DEFER indicates that the archive destination is temporarily
disabled. The value ALTERNATE indicates that the archive destination is an alternative that can accept
writing of redo logs to the archive destination only when its parent destination fails. This parameter is used
along with the LOG_ARCHIVE_DEST_n parameter.
Answer option D is incorrect. The LOG_ARCHIVE_DUPLEX_DEST parameter specifies that the redo
logs be written to both the archive destinations.
Answer option B is incorrect. The LOG_ARCHIVE_DEST_n parameter specifies multiple archive destinations.
more real questions you can visit passcert