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

NEW QUESTION 1

Examine the following commands and their output:
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL
----- ---- JAMES 1050
SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES'; 1 row updated.
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL
----- ---- JAMES 2310
View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.
What could be the possible cause for the query not displaying any row? Exhibit:

• A. Flashback logging is not enabled for the database.
• B. The changes made to the table are not committed.
• C. Supplemental logging is not enabled for the database.
• D. The database is not configured in ARCHIVELOG mode.

Answer: B

NEW QUESTION 2

You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.
Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)

• A. SYSTEM
• B. SYSAUX
• C. UNDO
• D. USERS
• E. TEMP
• F. This restore is not possible.

Answer: ABCD

NEW QUESTION 3

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

• A. You can add or remove the trace files to the package.
• B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
• C. You can add SQL test cases to the incident package.
• D. You cannot create an incremental incident package when the physical files are purged from the ADR.

Answer: ABC

Explanation:
Refer to here
About Quick Packaging and Custom Packaging
The Enterprise Manager Support Workbench provides two methods for creating and uploading an incident package: the quick packaging method and the custom packaging method.
Quick Packaging—This is the more automated method with a minimum of steps, organized in a guided workflow (a wizard). You select a single problem, provide a package name and description, and then schedule upload of the package contents, either immediately or at a specified date and time. The Support Workbench automatically places diagnostic data related to the problem into the package, finalizes the package, creates the zip file, and then uploads the file. With this method, you do not have the opportunity to add, edit, or remove package files or add other diagnostic data such as SQL test cases. However, it is the simplest and quickest way to get first-failure diagnostic data to Oracle Support. Quick packaging is the method used in the workflow described in "Investigating, Reporting, and Resolving a Problem".
Note that when quick packaging is complete, the package that was created by the wizard remains. You can then modify the package with custom packaging operations at a later time and manually reupload.
Custom Packaging—This is the more manual method, with more steps. It is intended for expert Support Workbench users who want more control over the packaging process. With custom packaging, you can create a new package with one or more problems, or you can add one or more problems to an existing package. You can then perform a variety of operations on the new or updated package, including:
✑ Adding or removing problems or incidents
✑ Adding, editing, or removing trace files in the package
✑ Adding or removing external files of any type
✑ Adding other diagnostic data such as SQL test cases
✑ Manually finalizing the package and then viewing package contents to determine if you must edit or remove sensitive data or remove files to reduce package size.
You might conduct these operations over a number of days, before deciding that you have enough diagnostic information to send to Oracle Support.
With custom packaging, you create the zip file and request upload to Oracle Support as two separate steps. Each of these steps can be performed immediately or scheduled for a future date and time.
Select the Full or Incremental option to generate a full package zip file or an incremental package zip file.
For a full package zip file, all the contents of the package (original contents and all correlated data) are always added to the zip file.
For an incremental package zip file, only the diagnostic information that is new or modified since the last time that you created a zip file for the same package is added to the zip file. For example, if trace information was appended to a trace file since that file was last included in the generated physical file for a package, the trace file is added to the
incremental package zip file. Conversely, if no changes were made to a trace file since it was last uploaded for a package, that trace file is not included in the incremental package zip file.

NEW QUESTION 4

You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

• A. Create and populate a SQL Tuning Set from the AWR on every Monday.
• B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
• C. Create a repeating baseline template.
• D. Insert a finding directive for future ADDM tasks.

Answer: C

NEW QUESTION 5

What RMAN command is used to execute a tablespace point-in-time recovery?

• A. recover
• B. duplicate
• C. restore
• D. copy
• E. None of the above

Answer: A

NEW QUESTION 6

If a backup is expired, which of the following is true?

• A. It can never be used for a restore/recover operation.
• B. Oracle will remove the backup set pieces from the flash recovery area.
• C. The backup has been used at least once to restore and recover the database.
• D. The backup is no longer valid because of a resetlogs operation.
• E. The physical backup set pieces are missing from the media.

Answer: E

NEW QUESTION 7

The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal FROM emp
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)

• A. ARCHIVELOG mode must be enabled
• B. Row Movement must be enabled for the table
• C. FLASHBACK must be set to ON for the database
• D. The UNDO_MANAGEMENT parameter must be set to AUTO
• E. The UNDO_RETENTION parameter must be set appropriately

Answer: DE

NEW QUESTION 8

The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

• A. owner
• B. touser
• C. attach
• D. remap_schema

Answer: D

NEW QUESTION 9

When you create a backup control file, where is the resulting file written to?

• A. The database user dump destination directory
• B. The database diagnostic destination directory
• C. To $ORACLE_HOME/rdbms
• D. To $ORACLE_HOME/admin
• E. To the directory and filename you specify in the command

Answer: E

NEW QUESTION 10

Which type of database file is spread across all disks in a disk group?

• A. All types of files are spread across all disks in the disk group.
• B. Datafiles
• C. Redo log files
• D. Archived redo log files
• E. Control files

Answer: A

NEW QUESTION 11

Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

• A. SET_ATTRIBUTE_NULL
• B. ALTER_JOB
• C. ALTER_JOB_PARAMETERS
• D. ALTER
• E. SET_ATTRIBUTE

Answer: AE

Explanation:
SET_ATTRIBUTE_NULL Procedure, Changes an attribute of an object to NULL SET_ATTRIBUTE Procedure, Changes an attribute of a job, schedule, or other Scheduler object
There is NO such "ALTER_JOB", "ALTER_JOB_PARAMETERS" and "ALTER" procedure available.

NEW QUESTION 12

You installed Oracle Database 11g at fresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

• A. The audit trail is stored in an operating system file.
• B. Auditing is disabled for all privileges.
• C. The audit trail is stored in the database.
• D. Auditing is enabled for all privileges.
• E. Auditing is enabled for certain privileges related to database security.

Answer: CE

NEW QUESTION 13

What type of backup is stored in a proprietary RMAN format?

• A. Backup set
• B. Image copy
• C. Backup section
• D. Backup group

Answer: A

Explanation:
A backup set is an RMAN-specific proprietary format, whereas an image copy is a bit-for-bit copy of a file. By default, RMAN creates backup sets.
Refer to here

NEW QUESTION 14

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?

• A. backup database all
• B. backup compressed database
• C. backup as compressed backupset database;
• D. backup as compressed backup database plus archivelog all;
• E. backup as compressed backupset database plus compress archivelog all;

Answer: A

Explanation:

C:\Users\albo\Desktop\1-1.jpg
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/23/2014 11:46:01
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode RMAN>

NEW QUESTION 15

You can back up the RMAN recovery catalog with RMAN.

• A. True
• B. False

Answer: A

Explanation:
When backing up the recovery catalog database, you can use RMAN to make the backups. Refer to here.

NEW QUESTION 16

You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.
Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?

• A. Create a manual incremental online database backup.
• B. Back up all the archived redo logs generated since the 8 a.
• C. backup.
• D. Create a brand-new backup after all the changes have been applied.
• E. There is no way to make the changes recoverable based on the 8 a.
• F. backup.
• G. Perform an online backup of the tablespace(s) that contained changed data.

Answer: B

NEW QUESTION 17

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

Answer: CD

Explanation:
Prerequisites for Block Media Recovery (link)
The following prerequisites apply to the RECOVER ... BLOCK command:
✑ The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
✑ If the target database is a standby database, then it must be in a consistent state, recovery cannot be in session, and the backup must be older than the corrupted file.
✑ The backups of the data files containing the corrupt blocks must be full or level 0 backups and not proxy copies.
If only proxy copy backups exist, then you can restore them to a nondefault location on disk, in which case RMAN considers them data file copies and searches them for blocks during block media recovery.
✑ RMAN can use only archived redo logs for the recovery.
RMAN cannot use level 1 incremental backups. Block media recovery cannot survive a missing or inaccessible archived redo log, although it can sometimes survive missing redo records.
✑ Flashback Database must be enabled on the target database for RMAN to search
the flashback logs for good copies of corrupt blocks.
If flashback logging is enabled and contains older, uncorrupted versions of the corrupt blocks, then RMAN can use these blocks, possibly speeding up the recovery.
✑ The target database must be associated with a real-time query physical standby
database for RMAN to search the database for good copies of corrupt blocks.

NEW QUESTION 18

Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?

• A. NLS_LANG
• B. NLS_COMP
• C. NLS_SORT
• D. None of the above

Answer: D

Explanation:
Neither NLS_SORT nor NLS_COMP cannot change sorting from BINARY to LINGUISTIC. Because the NLS_SORT depends on NLS_COMP, if they are different, the sorting method will always be BINARY.
(Refer to NLS_SORT) The exact operators and query clauses that obey the NLS_SORT parameter depend on the value of the NLS_COMP parameter. If an operator or clause does not obey the NLS_SORT value, as determined by NLS_COMP, the collation used is BINARY.
The BINARY comparison is faster and uses less resources than any linguistic comparison but for text in a natural language, it does not provide ordering expected by users.
The value of NLS_SORT affects execution plans of queries. Because a standard index cannot be used as a source of values sorted in a linguistic order, an explicit sort operation must usually be performed instead of an index range scan. A functional index on the NLSSORT function may be defined to provide values sorted in a linguistic order and reintroduce the index range scan to the execution plan.
NLS_COMP specifies the collation behavior of the database session.

NEW QUESTION 19

Which command would correctly start a TSPITR of the USERS tablespace?

• A. Option A
• B. Option B
• C. Option C
• D. Option D
• E. Option E

Answer: E

NEW QUESTION 20

When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?

• A. Export the tablespaces using data pump.
• B. Determine if the transportable set is self-contained.
• C. Convert the datafiles using RMAN.
• D. Copy the datafiles from source to destination.

Answer: B

NEW QUESTION 21

In your production database, you:
✑ Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals
✑ Set the control file autobackup to "on"
✑ Are maintaining image copies of the database files
You have lost the server parameter file (SPFILE) and the control file.
Which option must you consider before restoring the SPFILE and the control file by using the control file autobackup?

• A. Setting DBID for the database
• B. Using the RMAN SWITCH command
• C. Using the RMAN SET NEWNAME command
• D. Starting up the database instance in the NOMOUNT state

Answer: D

NEW QUESTION 22

Compressed backups work with which of the following commands?

• A. copy as backup
• B. backup as copy
• C. backup
• D. copy

Answer: C

Explanation:
The backup compression only works with backup set, NONE of image copies can work with compression.

NEW QUESTION 23
......