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

NEW QUESTION 1

What will be the end result of this set of RMAN commands?
shutdown abort startup mount
restore datafile 4 until time '09/30/2008:15:00:00'; recover datafile 4 until time '09/29/2008:15:00:00'; alter database open resetlogs;

• A. Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
• B. The restore command will fail.
• C. The recover command will fail.
• D. The alter database open resetlogs command will fail.
• E. All these commands will fail because they must be in the confines of a run block.

Answer: D

Explanation:
Pay attention on the difference between two timestamps.

NEW QUESTION 2

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? (Choose two.)

• A. An entry is created in the alert log file and the database instance continues to function normally
• B. The log switch hangs occur for transactions until free space is available in the flash recovery area
• C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
• D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Answer: BC

NEW QUESTION 3

Consider the following scenario for your database:
✑ Backup optimization is enabled in RMAN.
✑ The recovery window is set to 7 days in RMAN.
✑ The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
✑ The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?

• A. The RMAN backup fails because the TOOLS tablespace is read-only
• B. The RMAN skips the backup of the tablespace because backup optimization is enabled
• C. The RMAN makes backup because optimization can be enabled only for backups to disk
• D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Answer: D

NEW QUESTION 4

View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE; What is the outcome of this command?
Exhibit:

• A. The Flashback Archive is created on the same tablespace where the tables are stored.
• B. The Flashback Archive is created on the SYSAUX tablespace.
• C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.
• D. The table uses the default Flashback Archive.

Answer: C

NEW QUESTION 5

While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008.
Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?

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

Answer: C

NEW QUESTION 6

The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.
Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)
Exhibit:

• A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
• B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
• C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
• D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

Answer: AD

Explanation:
Using Oracle Flashback Transaction Query with Oracle Flashback Version Query (link) The query uses Oracle Flashback Version Query pseudocolumns:
SELECT versions_xid XID, versions_startscn START_SCN, versions_endscn END_SCN, versions_operation OPERATION, empname, salary
FROM emp
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
WHERE empno = 111; Results are similar to:

C:\Users\albo\Desktop\1-1.jpg 3 rows selected.
The results table rows are in descending chronological order.
✑ The third row corresponds to the version of the row in the table emp that was inserted in the table when the table was created.
✑ The second row corresponds to the row in emp that the erroneous transaction
deleted.
✑ The first row corresponds to the version of the row in emp that was reinserted with a new employee name.

NEW QUESTION 7

View the Exhibit to examine the metrics with a threshold.
Which statement is true regarding the Number of Transactions (per second) metric?
Exhibit:

• A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.
• B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.
• C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.
• D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

Answer: A

NEW QUESTION 8

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.
What must you do accomplish this task?

• A. Enable supplemental logging for the database.
• B. Specify undo retention guarantee for the database
• C. Create Flashback Data Archive in the tablespace where the tables are stored.
• D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

Answer: D

NEW QUESTION 9

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

• A. You are backing up to tape and your tape device performs its own compression.
• B. You are making image copies, and you have not enabled tablespace compression.
• C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
• D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
• E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

Answer: CDE

NEW QUESTION 10

When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

• A. SET_JOB_ARGUMENT_VALUE
• B. SET_JOB_VALUE_ANYDATA
• C. SET_JOB_ANYDATA_VALUE
• D. SET_SPECIAL_JOB_VALUE
• E. SET_JOB_ANYTYPE_VALUE

Answer: C

NEW QUESTION 11

If two windows overlap, which window attribute will determine whether one should be chosen over the other?

• A. WINDOW_PRIORITY
• B. PRIORITY
• C. PRIORITY_LEVEL
• D. WINDOW_PRIORITY_LEVEL
• E. OVERLAP_RULE

Answer: A

NEW 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. 2, 4, and 5
• B. All the steps
• C. 2, 3, 4 and 5
• D. 1, 2, 4, 5 and 6

Answer: D

Explanation:
Refer to here. Generate a Transportable Tablespace Set read_only--expdp--4-import-read_wrtie
1, 2, 4, 5, 6 (optional)
If both platforms have the same endianness, no conversion is necessary. Otherwise you must do a conversion of the tablespace set either at the source or destination database. Transport the dump file to the directory pointed to by the DATA_PUMP_DIR directory object, or to any other directory of your choosing.
Run the following query to determine the location of DATA_PUMP_DIR: SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = 'DATA_PUMP_DIR';

C:\Users\albo\Desktop\1-1.jpg
Transport the data files to the location of the existing data files of the destination database. On the UNIX and Linux platforms, this location is typically /u01/app/oracle/oradata/SID/ or
+DISKGROUP/SID/ datafile/.

NEW QUESTION 13

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

Answer: C

NEW QUESTION 14

Which is not a valid locale definition file type?

• A. Language
• B. Linguistic sort
• C. Calendar
• D. Territory
• E. Character set

Answer: C

NEW QUESTION 15

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.
What could be a solution to make tape streaming happen during the backup?

• A. Configure backup optimization
• B. Configure the channel to increase MAXOPENFILES
• C. Configure the channel to increase the capacity with the RATE parameter
• D. Configure the channel to adjust the tape buffer size with the BLKSIZE option

Answer: C

NEW QUESTION 16

Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)

• A. ENABLE
• B. ENABLE_PROGRAM
• C. VALIDATE_PROGRAM
• D. SET_ATTRIBUTE
• E. SET_ENABLED

Answer: AD

Explanation:
Refer to here.
ENABLE Procedure, Enables a program, job, chain, window, or window group SET_ATTRIBUTE Procedure, Changes an attribute of a job, schedule, or other Scheduler object

NEW QUESTION 17

If a backup set is expired, what can you do to correct the problem?

• A. Change the retention criteria.
• B. Make the lost backup set pieces available to RMAN again.
• C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.
• D. Nothin
• E. The backup set piece is lost forever.
• F. Call Oracle support, their assistance is required.

Answer: B

NEW QUESTION 18

You are performing incomplete recovery using RMAN. You execute the following RUN block:
RUN
{
SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE;
}
Which statement is true about the result?

• A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
• B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
• C. RMAN restores all datafiles and control files from the most recent backup
• D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

Answer: B

NEW QUESTION 19

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. identify the segments that you should shrink
• B. modify the storage parameters for the tablespace
• C. automatically shrink the segments with unused space
• D. check the alerts generated for the tablespace that is running low on space

Answer: A

NEW QUESTION 20

Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.
The steps to recover the damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?

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

Answer: D

NEW QUESTION 21

The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?

• A. The Oracle database will perform block checking for the index blocks only
• B. The Oracle database will not perform block checking for any of the data blocks
• C. The Oracle database will perform block checking for the default permanent tablespace only
• D. The Oracle database will perform block checking for the data blocks in all user tablespaces
• E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

Answer: E

NEW QUESTION 22

Evaluate the following statements:
CREATE TABLE purchase_orders ( po_id NUMBER(4),
po_date TIMESTAMP, supplier_id NUMBER(6), po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date) (
PARTITION Q1 VALUES LESS THAN (TO_DATE('1-apr-2007','d-mon-yyyy'), PARTITION Q2 VALUES LESS THAN (TO_DATE('1-jul-2007','d-mon-yyyy'), PARTITION Q3 VALUES LESS THAN (TO_DATE('1-oct-2007','d-mon-yyyy'), PARTITION Q4 VALUES LESS THAN (TO_DATE('1-jan-2008','d-mon-yyyy'));
CREATE TABLE purchase_order_items ( po_id NUMBER(4) NOT NULL,
product_id NUMBER(6) NOT NULL, unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)

• A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
• B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
• C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
• D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
• E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

Answer: BC

NEW QUESTION 23
......