NEW QUESTION 1

AUM (Automatic UNDO Management) has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo.
What is the problem? (Choose the best answer.)

• A. You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.
• B. You need to increase the size of the undo tablespace.
• C. The undo tablespace is not set to auto-extend.
• D. You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.

Answer: C

NEW QUESTION 2

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?

• A. A base catalog exists
• B. The recovery catalog is empty
• C. The base recovery catalog must be dropped
• D. A target database is registered in the recovery catalog

Answer: A

NEW QUESTION 3

Which command is used to configure RMAN to perform a compressed backup for every backup executed?

• A. BACKUP AS COMPRESSED BACKUPSET DATABASE
• B. BACKUP AS COMPRESSED COPY OF DATABASE
• C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
• D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
• E. BACKUP DATABASE COMPRESS

Answer: C

NEW QUESTION 4

You run the following commands:
RMAN> list expired backup; RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?

• A. They will be renamed.
• B. Nothing will happen to the
• C. The backup set pieces do not exist.
• D. They will be deleted immediately since they are not in the flash recovery area.
• E. You will need to manually remove the physical files listed in the output of the commands.
• F. They will become hidden files and removed 10 days later.

Answer: B

NEW QUESTION 5

Which two statements regarding a SQL profile are true? (Choose two.)

• A. It is built by Automatic Tuning Optimizer.
• B. It cannot be stored persistently in the data dictionary.
• C. It can be used by the query optimizer automatically.
• D. It can be created manually by using the CREATE PROFILE command.

Answer: AC

NEW QUESTION 6

Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)

• A. ASCII
• B. ANSI
• C. BINARY
• D. MONOLINGUAL
• E. MULTILINGUAL

Answer: BC

Explanation:

C:\Users\albo\Desktop\1-1.jpg
NLS_COMP specifies the collation behavior of the database session. Values:
BINARY
Normally, comparisons in the WHERE clause and in PL/SQL blocks is binary unless you specify the NLSSORT function.
LINGUISTIC
Comparisons for all SQL operations in the WHERE clause and in PL/SQL blocks should use the linguistic sort specified in the NLS_SORT parameter. To improve the performance, you can also define a linguistic index on the column for which you want linguistic comparisons.
ANSI
A setting of ANSI is for backwards compatibility; in general, you should set NLS_COMP to LINGUISTIC

NEW QUESTION 7

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?

• A. Perform Export before TSPITR and Import after TSPITR
• B. Move objects to another schema that has the same tablespace assigned
• C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

Answer: A

NEW QUESTION 8

Which mode of database shutdown requires an instance recovery at the time of the next database startup?

• A. ABORT
• B. NORMAL
• C. IMMEDIATE
• D. TRANSACTIONAL

Answer: A

NEW QUESTION 9

Which statement about using RMAN stored scripts is true?

• A. To create and execute an RMAN stored script, you must use a recovery catalog.
• B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
• C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
• D. When you execute a stored script, it always executes using the persistent channelsettings previously set with the CONFIGURE command.

Answer: A

Explanation:
About Stored Scripts
You can use a stored script as an alternative to a command file for managing frequently used sequences of RMAN commands. The script is stored in the recovery catalog rather than on the file system.
Stored scripts can be local or global. A local script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to that target database. A global stored script can be run against any database registered in the recovery catalog, if the RMAN client is connected to the recovery catalog and a target database.
The commands allowable within the brackets of the CREATE SCRIPT command are the same commands supported within a RUN block. Any command that is legal within a RUN command is permitted in the stored script. The following commands are not legal within stored scripts: RUN, @, and @@.
When specifying a script name, RMAN permits but generally does not require that you use quotes around the name of a stored script. If the name begins with a digit or is an RMAN reserved word, however, then you must put quotes around the name to use it as a stored script name. Consider avoiding stored script names that begin with nonalphabetic characters or that are the same as RMAN reserved words.

NEW QUESTION 10

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file.
Which option must you consider for this task?

• A. using only the RMAN SWITCH command to set the new location for the data file
• B. placing the database in the MOUNT state for the restore and recovery operations.
• C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
• D. configuring two channels: one for the restore operation and the other for the recovery operation

Answer: C

NEW QUESTION 11

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

• A. Its entries are specific to a single database.
• B. It contains file systems that have been mounted by Direct NFS.
• C. It is globally available to all Oracle 11g databases on the machine.
• D. It contains file systems that have been mounted by the kernel NFS system.

Answer: CD

NEW QUESTION 12

Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?

• A. alter tablespace DAVE_TBS backup mode;
• B. alter tablespace DAVE_TBS start backup;
• C. alter tablespace DAVE_TBS begin backup;
• D. alter tablespace DAVE_TBS backup begin;
• E. alter tablespace DAVE_TBS backup;

Answer: C

NEW QUESTION 13

Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all
that apply.)

• A. A single SQL statement provided by a user
• B. An existing SQL Tuning Set (STS)
• C. A preprocessed Database Replay workload
• D. A schema name
• E. SQL statement identified in EM as using excessive resources

Answer: CD

NEW QUESTION 14

View the Exhibit for the object interdependency diagram.
✑ The PRODUCTS table is used to create the PRODCAT_VW view.
✑ PRODCAT_VW is used in the GET_DATA procedure.
✑ GET_DATA is called in the CHECK_DATA function.
✑ A new column PROD_QTY is added to the PRODUCTS table.
How does this impact the status of the dependent objects? Exhibit:

• A. All dependent objects remain valid.
• B. Only the procedure and function become invalid and must be recompiled.
• C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
• D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.

Answer: A

NEW QUESTION 15

View the Exhibit.
Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe',
'(country_id, cust_state_province)') FROM dual;
Which statement describes the significance of this command? Exhibit:

• A. It collects statistics into the pending area in the data dictionary.
• B. It creates a virtual hidden column in the CUSTOMERS_OBE table.
• C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
• D. It creates a histogram to hold skewed information about the data in the columns.

Answer: B

Explanation:
DBMS_STATS.CREATE_EXTENDED_STATS Function
Creates a virtual column for a user specified column group or an expression in a table This function creates a column statistics entry in the system for a user specified column
group or an expression in a table. Statistics for this extension will be gathered when user or auto statistics gathering job gathers statistics for the table. We call statistics for such an extension, "extended statistics". This function returns the name of this newly created entry for the extension.

NEW QUESTION 16

Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable the block change tracking, after the incremental level 0 backup you issued the following command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/
rman_change_track.f';
To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which two statements are true in the above situation? (Choose two.)

• A. The block change tracking data will be used only from the next incremental 0 backup.
• B. The incremental backup will use change tracking data for accomplishing the backup.
• C. The incremental backup will not use change tracking data for accomplishing the backup.
• D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

Answer: AC

NEW QUESTION 17

Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?
a: Issue a checkpoint.
b: Shut down the database.
c: Issue an alter database open command to open the database. d: Startup mount the database.
e: Issue an alter database clear logfile command. f: Recover all database datafiles.

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

Answer: C

NEW QUESTION 18

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?

• A. Create two custom ADDM tasks.
• B. Modify the AWR snapshot time interval to two hours.
• C. Create a new scheduler window for a time period of two hours.
• D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

Answer: B

NEW QUESTION 19

When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?

• A. log_file_name_convert
• B. convert_log_file_name
• C. file_name_convert_log
• D. redo_log_file_name_convert
• E. logfile_convert_directory

Answer: A

NEW QUESTION 20

You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:
1. Set the retention target:
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
2. Enable Flashback Database:
SQL> ALTER DATABASE FLASHBACK ON;
3. Mount the database:
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance:
SQL> SHUTDOWN IMMEDIATE
5. Open the database:
SQL> ALTER DATABASE OPEN;
Choose the correct sequence.

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

Answer: B

NEW QUESTION 21

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available.
What would the optimizer do in this situation?

• A. It updates the existing SQL profiles with current statistics.
• B. It makes the statistics information available to GATHER_STATS_JOB.
• C. It initiates the statistics collection process by running GATHER_STATS_JOB.
• D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

Answer: B

NEW QUESTION 22

In what view are you likely to see the following output?

• A. V$SESSION_EVENT
• B. V$SESSION
• C. V$WAITS
• D. V$WAITSTAT
• E. V$SYSSTAT

Answer: B

NEW QUESTION 23

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the
encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

• A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
• B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace.
• C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
• D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
• E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.

Answer: ABC

NEW QUESTION 24

Which of the following statements is true regarding implementing a Flashback Table recovery?

• A. An SCN is never used to perform a Flashback Table recovery.
• B. If a significant number of changes have been made to the table, row movement must be enabled.
• C. The tablespace must be offline before performing a Flashback Table recovery.
• D. Flashback Table recovery is completely dependent on the availability of undo data in theundo tablespace.

Answer: D

NEW QUESTION 25
......