1Z0-053 Exam - Oracle Database 11g: Administration II

NEW QUESTION 1

During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.
How would this environment variable setting affect the installation?

• A. The installation terminates with an error.
• B. The installation proceeds with the default value without warnings and errors.
• C. The installation proceeds with the default value but it would not be an OFA-compliant database.
• D. The installation proceeds with the default value but a message would be generated in the alert log file.

Answer: D

NEW QUESTION 2

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment.
At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql
What is the significance of executing this script?

• A. It performs parallel recompilation of only the stored PL/SQL code.
• B. It performs sequential recompilation of only the stored PL/SQL code.
• C. It performs parallel recompilation of any stored PL/SQL as well as Java code.
• D. It performs sequential recompilation of any stored PL/SQL as well as Java code.

Answer: C

Explanation:
Recompile invalid objects with utlrp.sql

NEW QUESTION 3

You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?
1. Take the datafiles that were lost offline.
2. startup mount the database
3. Issue the alter database open command.
4. Restore the datafiles that were lost
5. Recover the datafiles with the recover datafile command.
6. Bring the datafiles back online.
7. Recover the database with the recover database command.

• A. 2, 1, 3, 4, 5, 6
• B. 2, 4, 5, 3
• C. 4, 7, 3
• D. 2, 4, 7, 3
• E. 2, 7, 3

Answer: B

NEW QUESTION 4

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

NEW QUESTION 5

Consider the following command:
backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
✑ Control-file auto backups were enabled.
✑ The size of backup sets was not restricted.
✑ One channel was allocated.

• A. 1
• B. 2
• C. 3
• D. 4
• E. 5

Answer: D

Explanation:
RMAN> show all;
RMAN configuration parameters for database with db_unique_name TESTDB are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #
default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD
TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/u01/app/oracle/product/11.2.0/dbhome_1/ dbs/snapcf_testdb.f'; # default
RMAN> Backup database plus archivelog delete input;
Starting backup at 19-DEC-13 current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=5 STAMP=834597174 input archived log thread=1 sequence=11 RECID=6 STAMP=834597417 channel ORA_DISK_1: starting piece 1 at 19-DEC-13
channel ORA_DISK_1: finished piece 1 at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_annnn_TAG20131219T163657_9c5d1bn3_.bkp tag=TAG20131219T163657 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_10_9c5csl13_.arc RECID=5 STAMP=834597174 archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_11_9c5d19cn_.arc RECID=6 STAMP=834597417 Finished backup at 19-DEC-13
Starting backup at 19-DEC-13 using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/testdb/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/testdb/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/testdb/example01.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/testdb/undotbs01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/testdb/users01.dbf channel ORA_DISK_1: starting piece 1 at 19-DEC-13
channel ORA_DISK_1: finished piece 1 at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_nnndf_TAG20131219T163703_9c5d1j8c_.bkp tag=TAG20131219T163703 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05 Finished backup at 19-DEC-13
Starting backup at 19-DEC-13 current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=7 STAMP=834597550 channel ORA_DISK_1: starting piece 1 at 19-DEC-13
channel ORA_DISK_1: finished piece 1 at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_annnn_TAG20131219T163911_9c5d5hlk_.bkp tag=TAG20131219T163911 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_12_9c5d5g7r_.arc RECID=7 STAMP=834597550
Finished backup at 19-DEC-13
Starting Control File and SPFILE Autobackup at 19-DEC-13
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/autobackup/2013_12_19/ o1_mf_s_834597553_9c5d5lz1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 19-DEC-13 RMAN> list backup;

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 6

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.
Which of these methods would you use to achieve this? (Choose all that apply.)

• A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.
• B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
• C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
• D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

Answer: BCD

Explanation:
Purpose
The md_restore command restores disk groups from a metadata backup file.
Syntax and Description
md_restore backup_file [--silent]
[--full|--nodg|--newdg -o 'old_diskgroup:new_diskgroup [,...]'] [-S sql_script_file] [-G 'diskgroup [,diskgroup...]']
backup_file
Reads the metadata information from backup_file.
--silent
Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.
--full
Specifies to create a disk group and restore metadata.
--nodg
Specifies to restore metadata only.
--newdg -o old_diskgroup:new_diskgroup]
Specifies to create a disk group with a different name when restoring metadata. The -o option is required with
--newdg.
-S sql_script_file
Write SQL commands to the specified SQL script file instead of executing the commands.
-G diskgroup
Select the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.

NEW QUESTION 7

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

• A. Backup retention policy
• B. Default backup device type
• C. Default destinations for backups
• D. Multiple backup device types for single backup
• E. Default section size for backups

Answer: ABC

Explanation:
SECTION SIZE cannot be configured through CONFIGURE command.

NEW QUESTION 8

Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?

• A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR).
• B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
• C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE.
• D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.

Answer: C

NEW QUESTION 9

Every resource plan must contain an allocation to which consumer group?

• A. LOW_GROUP
• B. SYS_GROUP
• C. DEFAULT_GROUP
• D. BASE_GROUP
• E. OTHER_GROUPS

Answer: E

NEW QUESTION 10

The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the
BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.
What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table?

• A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially
• B. Shrink the BOOKINGS table by using the ALTER TABLE... SHRINK SPACE command
• C. Move the BOOKINGS table to a different location by using the ALTER TABLE... MOVE command
• D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE ... DEALLOCATE UNUSED command

Answer: B

NEW QUESTION 11

NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracles order of precedence:
a: Default setting
b: Client environment variable
c: Explicit ALTER SESSION statement d: Inside SQL function
e: Server initialization parameter

• A. b, d, e, a, c
• B. e, a, b, c, d
• C. d, c, b, e, a
• D. a, b, d, c, e
• E. d, c, b, a, e

Answer: C

Explanation:

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 12

If a log file becomes corrupted, it may cause the database to stale. How would you correct such a situation?

• A. Recover the online redo log from backup.
• B. Delete and re-create the log file.
• C. Use the ALTER DATABASE CLEAR LOGFILE command to clear the log file.
• D. Shut down the database and restart it.
• E. Shut down the database and then mount i
• F. Clear the log file with the ALTER DATABASE CLEAR LOGFILE command and then restart the database with ALTER DATABASE OPEN RESETLOGS.

Answer: C

Explanation:
If you don't use the ALTER DATABASE CLEAR LOGFILE command to clear log online, after the database restarted, the log file will be INVALID.
So the simple way is to clear the log file directly.

NEW QUESTION 13

Which two statements are true regarding hot patching? (Choose two.)

• A. It requires relinking of the Oracle binary.
• B. It does not require database instance shutdown.
• C. It can detect conflicts between two online patches.
• D. It is available for installing all patches on all platforms.
• E. It works only in a single database instance environment.

Answer: BC

Explanation:
Online Patching
Regular patches typically contain .o (object) files and/or .a (archive) libraries, and therefore require a relink of the RDBMS binary. Online patches, however, contain .so files, which are dynamic/shared libraries, and do not require a relink of the RDBMS binary. Consequently, since a relink is not needed, you can apply or roll back online patches while the RDBMS instance is running. This simplifies administration, because no downtime is needed, and also results in a much quicker turnaround time for installing or de-installing Online Patches.
A regular RDBMS patch can require many minutes to install, since it requires instance shutdown, a relink, and instance startup. On the other hand, you can install an online patch in just a few seconds.
Online patches are only applicable for Oracle RDBMS and not any other products. Online patches are currently supported on the following Windows and UNIX platforms for version 11.2.0.1.0 and later:
✑ Linux x86
✑ Linux x86_64
✑ HP-UX Itanium
✑ Solaris SPARC 64-bit
✑ Solaris AMD 64-bit
✑ AIX (AIX 6.1 and later)
About Patch Conflicts:
All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch. This is called a conflict situation. OPatch detects such situations and raises an error when it detects a
conflict.

NEW QUESTION 14

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:
SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY
FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2';
What happens when the whole CONTROLLER1 Failure group is damaged?

• A. The transactions that use the disk group will halt.
• B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.
• C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
• D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

Answer: C

NEW QUESTION 15

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 oldest DROPSCN is purged
• C. The command returns an error because multiple entries with the same name exist in the recycle bin
• D. Only the table with the latest DROPSCN is purged

Answer: B

NEW QUESTION 16

Note the following parameter settings: Which setting is NOT allowed?

• A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
• B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
• C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
• D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

Answer: B

NEW QUESTION 17

At the request of a user, you issue the following command to restore a dropped table: SQL> flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop;
Later, the user notifies you that the data in the table seems to be very old and out of date. What might be the problem?

• A. Because a proper range of SCNs was not specified, the wrong data was restored.
• B. A proper range of timestamps was not specified, so the wrong data was restored.
• C. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table being stored in the Recycle Bin.
• D. Either option A or B could be correc
• E. Not enough information was provided to determine which.
• F. None of the above.

Answer: C

NEW QUESTION 18

What are three benefits of using ASM? (Choose three.)

• A. Ease of disk administration and maintenance
• B. Load balancing across physical disks
• C. Software RAID-1 data redundancy with double or triple mirrors
• D. Automatic recovery of failed disks

Answer: ABC

NEW QUESTION 19

Which of the following are prerequisite steps to transport a database? (Choose all that apply.)

• A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
• B. Verify that there are no restrictions or limitations that the source or destination database may encounter.
• C. Verify that the source and destination have the same Oracle version, critical updates, patch-set version, and patch- set exceptions.
• D. Determine if you will perform the conversion on the source or destination platform.
• E. None of the above.

Answer: ABD

NEW QUESTION 20

View the Exhibit to observe the error.
You receive this error regularly and have to shutdown the database instance to overcome the error. Automatic Shared Memory Management is configured for the instance.
What can you do to reduce the chance of this error in the future? Exhibit:

• A. Increase the value of SGA_MAX_SIZE
• B. Enable automatic memory management
• C. Set the PRE_PAGE_SGA parameter to true
• D. Lock the System Global Area (SGA) in memory

Answer: B

Explanation:
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool or Streams pool.
Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE. If the error is issued from an Oracle Streams or XStream process, increase the initialization parameter STREAMS_POOL_SIZE or increase the capture or apply parameter MAX_SGA_SIZE.

NEW QUESTION 21

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

• A. SQL statements that are part of the AWR baseline only
• B. SQL statements based on the AWR top SQL identification
• C. SQL statements that are part of the available SQL Tuning Set (STS) only
• D. SQL statements that are available in the cursor cache and executed by a user other than SYS

Answer: B

NEW QUESTION 22

Which three actions are required to configure the Flashback Database? (Choose three.)

• A. set Flash Recovery Area
• B. enable Flashback logging
• C. create FLASHBACK tablespace
• D. start the database in the ARCHIVELOG mode
• E. start the database in the NOARCHIVELOG mode

Answer: ABD

NEW QUESTION 23
......