NEW QUESTION 1
Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?

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

Answer: C

NEW QUESTION 2
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

• A. SQL Repair Advisor
• B. SQL Optimizer
• C. SQL Access Advisor
• D. SQL Tuning Advisor

Answer: D

NEW QUESTION 3
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

• A. Make backups faster
• B. Store RMAN metadata
• C. Store RMAN scripts
• D. Provide the ability to do centralized backup reporting.
• E. Make recovery faster

Answer: BCD

Explanation: A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. Typically, you store the catalog in a dedicated database. A recovery catalog provides the following benefits:
✑ A recovery catalog creates redundancy for the RMAN repository stored in the
control file of each target database. The recovery catalog serves as a secondary metadata repository. If the target control file and all backups are lost, then the RMAN metadata still exists in the recovery catalog.
✑ A recovery catalog centralizes metadata for all your target databases. Storing the
metadata in a single place makes reporting and administration tasks easier to perform.
✑ A recovery catalog can store metadata history much longer than the control file.
This capability is useful if you must do a recovery that goes further back in time than the history in the control file. The added complexity of managing a recovery catalog database can be offset by the convenience of having the extended backup history available.
Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.
A recovery catalog is required when you use RMAN in a Data Guard environment. By storing backup metadata for all primary and standby databases, the catalog enables you to offload backup tasks to one standby database while enabling you to restore backups on other databases in the environment.

NEW QUESTION 4
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.
Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?

• A. Restore the backup control file and open the database with RESETLOGS option.
• B. Perform point-in-time recovery because flashback cannot be performed again on this table
• C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
• D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

Answer: D

NEW QUESTION 5
Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)

• A. a job
• B. a program
• C. a schedule
• D. a PL/SQL procedure

Answer: ABC

Explanation: The Scheduler objects include:
✑ Programs
✑ Schedules
✑ Jobs
✑ Destinations
✑ Chains
✑ File Watchers
✑ Credentials
✑ Job Classes
✑ Windows
✑ Groups

NEW QUESTION 6
When performing an online backup, what is the proper order of the following steps?
a: Issue the ALTER DATABASE END BACKUP command. b: Back up the archived redo logs.
c: Issue the ALTER DATABASE BEGIN BACKUP command.
d: Back up the database files.
e: Determine the beginning log sequence number. f: Determine the ending log sequence number.
g: Force a log switch with the ALTER SYSTEM SWITCH LOGFILE command.

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

Answer: D

Explanation: There are two big steps to complete the online database backup:
1. Enclose with BEGIN BACKUP and END BACKUP options to use O/S file copy command to backup data files;
Which is e, c, d, a
2. Use SWITCH LOGFILE command to archive all the online redo log. backup all the archived redo log file. Which is g, f, b
According to Oracle document, after online backup done, you must archive the online redo log, otherwise you will have no chance to recover the database with consistence.

NEW QUESTION 7
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client program?

• A. User process
• B. Server process
• C. System Monitor (SMON)
• D. Process Monitor (PMON)
• E. Checkpoint process (CKPT)

Answer: B

NEW QUESTION 8
A database is running In ARCHIVELOG mode. It has two online redo log groups and each group has one member.
A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.
1) Restore the corrupted redo log group.
2) Restore from a whole database backup.
3) Perform incomplete recovery.
4) Relocate by renaming the member of the damaged online redo log group to a new location.
5) Open the database with the RESETLOGS option.
6) Restart the database instance.
7) Issue a checkpoint and clear the log.
Identify the option with the correct sequential steps to accomplish the task efficiently.

• A. 1, 3, 4, and 5
• B. 7, 3, 4. and 5
• C. 2, 3, 4, and 5
• D. 7, 4, 3. and 5
• E. Only 6 is required

Answer: C

Explanation: Recovering After Losing All Members of an Online Redo Log Group
If a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure
and the archiving mode of the database.
If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not. Table 30-4 outlines the various recovery scenarios.

C:UsersalboDesktop1-1.jpg

NEW QUESTION 9
What components are present in an ASM instance? (Choose three.)

• A. SGA
• B. Database processes
• C. Database datafiles
• D. Control files
• E. Database parameter file or SPFILE

Answer: ABE

NEW QUESTION 10
Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

• A. only encryption and compression settings for all SecureFile LOBs
• B. only encryption and deduplication settings for only SecureFile CLOBs
• C. deduplication, encryption, and compression settings for all SecureFile LOBs
• D. deduplication, encryption, and compression settings only for SecureFile CLOBs

Answer: C

Explanation: Refer to here.
DBMS_LOB.SETOPTIONS()
This procedure sets compression, deduplication and encryption features. It enables the features to be set on a per-LOB basis, overriding the default LOB settings. This call incurs a round trip to the server to make the changes persistent.

NEW QUESTION 11
The writes the Flashback Database logs in the flash recovery area.

• A. FLSH
• B. FLDB
• C. RVWR
• D. RVRW
• E. FBDA

Answer: C

Explanation: RVWR (Recovery Writer Process), Writes flashback data to the flashback logs in the fast recovery area RVWR writes flashback data from the flashback buffer in the SGA to the flashback logs. RVWR also creates flashback logs and performs some tasks for flashback log automatic management. Existed in Database instance, Flashback Database
FBDA (Flashback Data Archiver Process), Archives historical rows for tracked tables into flashback data archives and manages archive space, organization, and retention
When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the rows in the archive. FDBA maintains metadata on the current rows and tracks how much data has been archived.
FBDA is also responsible for automatically managing the flashback data archive for space, organization (partitioning tablespaces), and retention. FBDA also keeps track of how far the archiving of tracked transactions has progressed.
See Also: Oracle Database Advanced Application Developer's Guide Existed in Database and ASM instances

NEW QUESTION 12
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

• A. The plan baselines can be evolved over time to produce better performance.
• B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
• C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
• D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

Answer: AC

Explanation: Purpose of SQL Plan Baselines
Common scenarios where SQL plan management can improve or preserve SQL performance include:
A database upgrade that installs a new optimizer version usually results in plan changes for a small percentage of SQL statements. Most of these plan changes result in either no performance change or improvement. However, some plan changes may cause performance regressions. SQL plan baselines significantly minimize potential regressions resulting from an upgrade.
Ongoing system and data changes can impact plans for some SQL statements, potentially causing performance regressions. SQL plan baselines help minimize performance regressions and stabilize SQL performance.
Deployment of new application modules means introducing new SQL statements into the database. The application software may use appropriate SQL execution plans developed in a standard test configuration for the new statements. If the system configuration is significantly different from the test configuration, then the database can evolve SQL plan baselines over time to produce better performance.

NEW QUESTION 13
Which of the following objects can be directly referenced by a window object? (Choose all that apply.)

• A. Schedule object
• B. Program object
• C. Job object
• D. Resource plan
• E. Resource consumer group

Answer: AD

NEW QUESTION 14
You issued the following RMAN command to back up the database:
RMAN> RUN{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE
TAG quarterly KEEP FOREVER
RESTORE POINT FY06Q4;
}
Which two statements are true regarding the backup performed? (Choose two.)

• A. Archived redo log files are backed up along with data files.
• B. Only data files are backed up and a restore point named FY06Q4 is created.
• C. Archived log files are backed up along with data files, and the archived log files are deleted.
• D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

Answer: AD

Explanation: Section: Monitoring and Tuning RMAN Explanation
Refer to here. keepOption
Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26.
You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy.
Note: You cannot use KEEP with BACKUP BACKUPSET.
With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery catalog when you specify KEEP FOREVER.
Note: You can use CHANGE to alter the status of a backup generated with KEEP. See Also: keepOption for more information about backups made with the KEEP option Creating a Consistent Database Backup for Archival Purposes
This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only those archived redo log files needed to restore the data file backup to a consistent state. The BACKUP command also creates a restore point to match the SCN at which this backup is consistent. The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.
BACKUP DATABASE
FORMAT '/disk1/archival_backups/db_%U.bck' TAG quarterly
KEEP UNTIL TIME 'SYSDATE + 365' RESTORE POINT Q1FY06;

NEW QUESTION 15
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

• A. Differential incremental backup
• B. Different incremental backup
• C. Cumulative backup
• D. Cumulative incremental backup

Answer: A

NEW QUESTION 16
The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
The RVPC user can do which of the following? (Choose all that apply.)

• A. Register databases if granted the register database privilege
• B. See all databases in the recovery-catalog schema
• C. See all database-related metadata in the recovery catalog if they are granted access to that database
• D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command
• E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

Answer: AC

NEW QUESTION 17
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

• A. The alter database archivelog command will fail.
• B. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
• C. The alter database archivelog command will succeed.
• D. The alter database archivelog command will ask if you want to make the database consistent first.
• E. There is no alter database archivelog comman
• F. The correct command is alter database alterlogging.

Answer: A

Explanation: Before you change database to archivelog mode, you need to have a clean database shutdown.

NEW QUESTION 18
ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

• A. The data is decrypted during SORT and JOIN operations.
• B. The data remains encrypted when it is read into memory.
• C. The data remains encrypted when it is stored in the redo logs.
• D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Answer: C

NEW QUESTION 19
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

• A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
• B. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
• C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
• D. Health Monitor checks are always initiated manually when there is some critical error.

Answer: AB

NEW QUESTION 20
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.
Which statements will be true in this scenario? (Choose all that apply.)

• A. The disk is immediately dropped from the disk group.
• B. The ASM tracks the extents that are modified during the outage.
• C. The ASM migrates the extents from the unavailable disk to the remaining disks.
• D. The disk automatically goes offline.

Answer: BD