NEW QUESTION 1
View the Exhibit for some of the parameter settings. You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;
What is the outcome of the above command? Exhibit:

• A. The index is not used by the optimizer but is maintained during DML operations.
• B. The index is not used by the optimizer and is not maintained during DML operations.
• C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
• D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

Answer: A

NEW QUESTION 2
You issued the following command to mount the DATA disk group in restricted mode: ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?

• A. The client RDBMS instance can access the file as a read-only file.
• B. A new disk cannot be added to a disk group.
• C. A disk in a disk group can be taken offline.
• D. The client RDBMS instance cannot access the files in the disk group.

Answer: D

Explanation: MOUNT (link)
Specify MOUNT to mount the disk groups in the local Oracle ASM instance. Specify ALL MOUNT to mount all disk groups specified in the ASM_DISKGROUPS initialization parameter. File operations can only be performed when a disk group is mounted. If Oracle ASM is running in a cluster or a standalone server managed by Oracle Restart, then the MOUNT clause automatically brings the corresponding resource online.
RESTRICTED | NORMAL Use these clauses to determine the manner in which the disk groups are mounted.
In the RESTRICTED mode, the disk group is mounted in single-instance exclusive mode. No other Oracle ASM instance in the same cluster can mount that disk group. In this mode the disk group is not usable by any Oracle ASM client.
In the NORMAL mode, the disk group is mounted in shared mode, so that other Oracle ASM instances and clients can access the disk group. This is the default.

NEW QUESTION 3
A user performs an update on a table. Shortly after committing the transaction, they realize
that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?

• A. Flashback Drop
• B. Flashback Query
• C. Flashback Versions Query
• D. Flashback Transaction Query
• E. Flashback Table

Answer: E

Explanation: FLASHBACK TABLE
Purpose
Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system. Also, Oracle Database cannot restore a table to an earlier state across any DDL operations that change the structure of the table.

NEW QUESTION 4
Which two statements are true about encrypting RMAN backup? (Choose two.)

• A. The transparent encryption of backups uses the encryption wallet
• B. The database uses the same encryption key for every encrypted backup
• C. The password encryption of backups only uses the password while creating and restoring backup

Answer: AC

NEW QUESTION 5
When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.
Which two statements describe the implications of this? (Choose two.)

• A. It produces less accurate results of the comparison analysis.
• B. It automatically calls the SQL Tuning Advisor for recommendations.
• C. It shortens the time of execution and reduces the impact on system resources.
• D. Only the changes in the execution plan, and not performance regression, are detected.

Answer: AC

NEW QUESTION 6
You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?

• A. restore controlfile until time '09/30/2008:18:00:00';
• B. restore database until time '09/30/2008:18:00:00';
• C. restore spfile until time '09/30/2008:18:00:00';
• D. recover database until time '09/30/2008:18:00:00';
• E. alter database open resetlogs;
• F. alter database open;
• G. b, d, e
• H. b, d, f
• I. c, a, b, d, e
• J. c, a, b, d, f
• K. a, b, d, e

Answer: A

NEW QUESTION 7
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

• A. V$VALID_NLS_VALUES
• B. NLS_VALID_VALUES
• C. NLS_VALUE_OPTIONS
• D. V$NLS_VALUE_OPTIONS
• E. V$NLS_VALID_VALUES

Answer: E

NEW QUESTION 8
Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

• A. configuring control file autobackup to be ON
• B. backing up data filed only and not the archived redo log files
• C. running the recovery catalog database in NOARCHIVELOG mode.
• D. setting the retention policy to a REDUNDANCY value greater than 1
• E. backing up the recovery catalog to the same disk as that of the target database

Answer: AD

Explanation: Refer to here.
Configuring the Recovery Catalog Database
When you use a recovery catalog, RMAN requires that you maintain a recovery catalog schema. The recovery catalog is stored in the default tablespace of the schema. The SYS user cannot be the owner of the recovery catalog.
Decide which database you will use to install the recovery catalog schema, and also how you will back up this database. Also, decide whether to operate the catalog database in ARCHIVELOG mode, which is recommended.
Note: Do not use the target database to be backed up as the database for the recovery catalog. The recovery catalog must be protected if the target database is lost.

NEW QUESTION 9
Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)

• A. Flashback Query
• B. Flashback Drop
• C. Flashback Table
• D. Flashback Database
• E. Transaction Processing
• F. Recycle Bin

Answer: ACE

NEW QUESTION 10
The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)

• A. Date format
• B. Decimal character
• C. Group separator
• D. First day of the month
• E. None of the above
• F. All of the above

Answer: ABC

Explanation: Parameter type String
Syntax NLS_TERRITORY = territory Default value Operating system-dependent Modifiable ALTER SESSION
Range of values Any valid territory name Basic Yes
NLS_TERRITORY specifies the name of the territory whose conventions are to be followed for day and week numbering.
This parameter also establishes the default date format, the default decimal character and group separator, and the default ISO and local currency symbols.
For information on these settings, see "NLS_DATE_FORMAT", "NLS_NUMERIC_CHARACTERS", "NLS_CURRENCY", and "NLS_ISO_CURRENCY".

NEW QUESTION 11
You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?

• A. synch catalog
• B. resync catalog
• C. replicate catalog
• D. update catalog
• E. restore catalog

Answer: B

Explanation: Manually Resynchronizing the Recovery Catalog
Use RESYNC CATALOG to force a full resynchronization of the recovery catalog with a target database control file. You can specify a database unique name with RESYNC FROM DB_UNIQUE_NAME or ALL, depending on whether you want to resynchronize a specific database or all databases in the Data Guard environment.
Typically, you would perform this operation after you have run the CONFIGURE command for a standby database, but have not yet connected to this standby database.
1. Start RMAN and connect to a target database and recovery catalog.
2. Mount or open the target database: RMAN> STARTUP MOUNT;
3. Resynchronize the recovery catalog. RMAN> RESYNC CATALOG;

NEW QUESTION 12
How is block-change tracking enabled?

• A. With alter database enable block change tracking
• B. With alter system enable block change tracking
• C. With an init.ora parameter change
• D. With an spfile parameter change

Answer: A

NEW QUESTION 13
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 14
On the development database rac0, there are six raw devices: /dev/raw/raw1 through
/dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each.
An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and
/dev/raw/raw2.
Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

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

Answer: A

NEW QUESTION 15
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

• A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
• B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.
• C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
• D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

Answer: AD

NEW QUESTION 16
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 17
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.
You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?

• A. The Flashback Archive FLA1 is dropped only if it is empty.
• B. The tablespace having Flashback Archive is dropped.
• C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
• D. The Flashback Data Archive and historical data are dropped.

Answer: D

NEW QUESTION 18
ASM supports all but which of the following file types? (Choose all that apply.)

• A. Database files
• B. SPFILEs
• C. Redo-log files
• D. Archived log files
• E. RMAN backup sets
• F. Password files
• G. init.ora files

Answer: FG

Explanation: What Types of Files Does Oracle ASM Support?

NEW QUESTION 19
Why would you execute the report obsolete command?

• A. To list all backups that were no longer available for restore operations
• B. To list all backups that had aged beyond the RMAN retention criteria
• C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
• D. To list all datafiles that are no longer part of the database and thus do not need to be backed up
• E. To list all archived redo logs that are no longer needed for any database recovery

Answer: B

Explanation: You can report backup sets, backup pieces, and data file copies that are obsolete that is, not needed to meet a specified retention policy by specifying the OBSOLETE keyword.

NEW QUESTION 20
What is the purpose of the list expired backup command?

• A. Lists all backups impacted by a resetlogs command
• B. Lists all backups that are subject to retention criteria
• C. Lists all backups that are missing associated physical backup set pieces
• D. Lists the status of datafile backup failures due to the use of the duration command
• E. Lists backups that cannot be used by the restore command because they have been marked as disabled

Answer: C