NEW QUESTION 1

The environmental variable ORACLE_BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). View the Exhibit and note the various parameters set in your database.
What will be the location of the ADR base? Exhibit:

• A. It is set to ORACLE_BASE.
• B. It is set to ORACLE_HOME/log.
• C. It is set to /u01/app/oracle/admin/orcl/adump.
• D. It is set to /u01/app/oracle/flash_recovery_area.

Answer: A

Explanation:
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
✑ If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
✑ If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

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

Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

• A. Implement RMAN multiplexing
• B. Set the DEBUG ON in the RMAN script
• C. Specify the command ID in the RMAN script
• D. Use a tag with the RMAN BACKUP command

Answer: C

NEW QUESTION 4

Which package provides API's for the SQL Tuning Advisor?

• A. DBMS_MONITOR
• B. DBMS_STATS
• C. DBMS_SQLTUNE
• D. DBMS_ADVISOR

Answer: C

Explanation:
View the Exhibit 1.
In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US."
View the Exhibit exhibit2 to examine the commands and query plans. The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table.
What can you do to make the optimizer detect the actual selectivity? desc-customers_obe (exhibit):

C:\Users\albo\Desktop\1-1.jpg
sql-select-customers_obe (exhibit):

C:\Users\albo\Desktop\1-1.jpg
A. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
B. Set the STATISTICS_LEVEL parameter to TYPICAL.
C. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERS_OBE columns.
D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE. Answer: C
Real example refer to here. Determining Single Column Statistics
A good example of correlated or related columns are the country_id and cust_state_province columns in the CUSTOMERS_OBE table. When the value of cust_state_province is 'CA' , the value of country_id is 'US'. There is a skew in the data in these two columns, which means the majority of rows in the table have the values 'CA' and 'US'. Both the relationship between the columns and the skew in the data make it difficult for the optimizer to calculate the selectivity or cardinality of these columns correctly when they are used together in a query. Extended statistics should help in this situation.

NEW QUESTION 5

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile.
Which statement is true when you accept the suggested SQL profile?

• A. The tuned plan is not added to the SQL plan baseline.
• B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
• C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
• D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

Answer: C

Explanation:
15.4 Using Fixed SQL Plan Baselines (Refer to here)
When you tune a SQL statement with a fixed SQL plan baseline using SQL Tuning Advisor, a SQL profile recommendation has special meaning. When the SQL profile is accepted, the database adds the tuned plan to the fixed SQL plan baseline as a non-fixed plan. However, as described above, the optimizer does not use the tuned plan when a reproducible fixed plan is present. Therefore, the benefit of SQL tuning may not be realized. To enable the use of the tuned plan, manually alter the tuned plan to a fixed plan by setting its FIXED attribute to YES.

NEW QUESTION 6

Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';
What is the impact of this setting on the usage of SecureFiles?

• A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.
• B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB.
• C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB.
• D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile.

Answer: A

Explanation:
Parameter type String
Syntax DB_SECUREFILE = { NEVER | PERMITTED | ALWAYS | IGNORE }
Default value PERMITTED
Modifiable ALTER SESSION, ALTER SYSTEM
Basic No
DB_SECUREFILE specifies whether or not to treat LOB files as SecureFiles. Values:
NEVER
Any LOBs that are specified as SecureFiles are created as BasicFile LOBs. All SecureFile- specific storage options and features (for example, compress, encrypt, deduplicate) will cause an exception. The BasicFile LOB defaults will be used for storage options not specified.
PERMITTED
LOBs are allowed to be created as SecureFiles. ALWAYS
Attempts to create all LOBs as SecureFile LOBs but creates any LOBs not in an Automatic Segment Space Managed tablespace as BasicFile LOBs, unless SECUREFILE is explicitly specified. Any BasicFile LOB storage options that are specified will be ignored and the SecureFile defaults will be used for all storage options not specified.
IGNORE
The SECUREFILE keyword and all SecureFile options are ignored.
If the COMPATIBLE initialization parameter is not set to 11.1.0 or higher, then LOBs are not treated as SecureFiles.

NEW QUESTION 7

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.
Which two statements are true regarding the outcome of this action? (Choose two)

• A. All the related indexes and views are automatically dropped
• B. The flashback drop feature can recover only the table structure
• C. Only the related indexes are dropped whereas views are invalidated
• D. The flashback drop feature can recover both the table structure and its data

Answer: CD

NEW QUESTION 8

You issued the following commands to configure setting in RMAN;
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of the above command?

• A. The backup will terminate because the FORMAT clause was not configured for the channel
• B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
• C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
• D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

Answer: D

NEW QUESTION 9

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 10

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

• A. Only a single partitioning key column can be specified.
• B. All DML statements must use partition-extended syntax.
• C. The same physical attributes must be specified for each partition.
• D. Unique local indexes cannot be created on a system-partitioned table.
• E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Answer: DE

NEW QUESTION 11

Which two statements are true about a job chain? (Choose two.)

• A. A job chain can contain a nested chain of jobs.
• B. The jobs in a job chain cannot have more than one dependency.
• C. A job of the CHAIN type can be run using event-based or time-based schedules.
• D. The jobs in a job chain can be executed only by using the events generated by the Scheduler

Answer: AC

Explanation:
Defining Chain Steps
After creating a chain object, you define one or more chain steps. Each step can point to one of the following:
✑ A Scheduler program object (program)
✑ Another chain (a nested chain)
✑ An event schedule, inline event, or file watcher
You define a step that points to a program or nested chain by using the DEFINE_CHAIN_STEP procedure. An example is the following, which adds two steps tomy_chain1:

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 12

To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;
What is the significance of this setting?

• A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
• B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.
• C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.
• D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.

Answer: B

NEW QUESTION 13

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations.
While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?

• A. Open the database in NORMAL mode
• B. Open the database in read-only mode
• C. Open the database in RESTRICTED mode
• D. Open the database with the RESETLOGS option

Answer: D

Explanation:
Recovering the Database After a Disaster
The procedure for disaster recovery is similar to the procedure for recovering the database with a backup control file in NOCATALOG mode. If you are restoring the database to a new host, then you should also review the considerations described in "Restoring a Database on a New Host".
This scenario assumes that the Linux server on which your database was running has been damaged beyond repair. Fortunately, you backed up the database to Oracle Secure Backup and have the tapes available. The scenario assumes the following:
✑ Oracle Database is already installed on the new host.
✑ You are restoring the database to a new Linux host with the same directory structure as the old host.
✑ You have one tape drive containing backups of all the data files and archived redo logs through log 1124, and autobackups of the control file and server parameter file.
✑ You do not use a recovery catalog with the database.
To recover the database on the new host:
1. If possible, restore or re-create all relevant network files such as tnsnames.ora and listener.ora and a password file.
2. Start RMAN and connect to the target database instance.
At this stage, no initialization parameter file exists. If you have set ORACLE_SID and ORACLE_HOME, then you can use operating system authentication to connect as SYSDBA. For example, start RMAN as follows:
% rman
RMAN> CONNECT TARGET
/
3. Specify the DBID for the target database with the SET DBID command, as described in "Restoring the Server Parameter File".
For example, enter the following command: SET DBID 676549873;
4. Run the STARTUP NOMOUNT command.
When the server parameter file is not available, RMAN attempts to start the instance with a dummy server parameter file.
5. Allocate a channel to the media manager and then restore the server parameter file from autobackup. For example, enter the following command to restore the server parameter file from Oracle Secure Backup:
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt; RESTORE SPFILE FROM AUTOBACKUP;
}
6. Restart the instance with the restored server parameter file. STARTUP FORCE NOMOUNT;
7. Write a command file to perform the restore and recovery operation, and then execute the command file.
The command file should do the following:
a. Allocate a channel to the media manager.
b. Restore a control file autobackup (see "Performing Recovery with a Backup Control File and No Recovery Catalog").
c. Mount the restored control file.
d. Catalog any backups not recorded in the repository with the CATALOG command.
e. Restore the data files to their original locations. If volume names have changed, then run SET
NEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the data files, as shown in the following example.
f. Recover the data files. RMAN stops recovery when it reaches the log sequence number specified.
RMAN> RUN
{
# Manually allocate a channel to the media manager ALLOCATE CHANNEL t1 DEVICE TYPE sbt;
# Restore autobackup of the control file. This example assumes that you have
# accepted the default format for the autobackup name. RESTORE CONTROLFILE FROM AUTOBACKUP;
# The set until command is used in case the database
# structure has changed in the most recent backups, and you want to
# recover to that point in time. In this way RMAN restores the database
# to the same structure that the database had at the specified time. ALTER DATABASE MOUNT;
SET UNTIL SEQUENCE 1124 THREAD 1; RESTORE DATABASE;
RECOVER DATABASE;
}
The following example of the RUN command shows the same scenario except with new file names for the restored data files:
RMAN> RUN
{
# If you must restore the files to new locations,
# use SET NEWNAME commands:
SET NEWNAME FOR DATAFILE 1 TO '/dev/vgd_1_0/rlvt5_500M_1'; SET NEWNAME FOR DATAFILE 2 TO '/dev/vgd_1_0/rlvt5_500M_2'; SET NEWNAME FOR DATAFILE 3 TO '/dev/vgd_1_0/rlvt5_500M_3'; ALLOCATE CHANNEL t1 DEVICE TYPE sbt;
RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT;
SET UNTIL SEQUENCE 124 THREAD 1; RESTORE DATABASE;
SWITCH DATAFILE ALL; # Update control file with new location of data files. RECOVER DATABASE;
}
8. If recovery was successful, then open the database and reset the online logs: ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 14

Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

• A. ALTER DISKGROUP misc MOUNT;
• B. ALTER DISKGROUP misc DROP DISK misc2;
• C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;
• D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
• E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

Answer: AC

Explanation:
Altering Disk Groups
You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single ALTER DISKGROUP statement are recommended. Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations.
Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query the V$ASM_OPERATION view to monitor the status of this operation.
add_disk_clause
Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group as part of this operation.
drop_disk_clause
Use this clause to drop one or more disks from the disk group.
DROP DISK
The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.

NEW QUESTION 15

You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.
Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

• A. The au_size disk group attribute determines the size of allocation units in the disk group.
• B. The allocation unit size may vary but the extent size is fixed.
• C. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
• D. Extent management is completely automated.

Answer: AD

NEW QUESTION 16

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)

• A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
• B. A resumable statement is suspended only if an out of space error occurs.
• C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
• D. A resumable statement can only be suspended and resumed once during the execution of the statement.
• E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

Answer: ACE

NEW QUESTION 17

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 18

Given the script
create script db_backup_datafile_script
{backup datafile and 1, and2 plus archivelog delete input;}
What is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}

• A. The script will fail since you instructed RMAN to back up only one datafile rather than two.
• B. The script will successfully back up datafile 3 without error.
• C. The script will fail since it uses a substitution variable which is not supported.
• D. The execute script command will prompt for the value of and2 since it's not included in the command.
• E. The script will fail because you cannot use the plus archivelog command when backing up database datafiles.

Answer: D

NEW QUESTION 19

The SQL Tuning Advisor configuration has default settings in your database instance.
Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?

• A. statistics recommendations
• B. SQL Profile recommendations
• C. Index-related recommendations
• D. restructuring of SQL recommendations

Answer: B

NEW QUESTION 20

You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Which statement is true?

• A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
• B. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
• C. Backup optimization is permanently disabled
• D. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

Answer: B

NEW QUESTION 21

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 22

Your company wants to upgrade the production database to a Real Application Clusters (RAC) environment.
You set up the best RAC database and want to replay a recorded workload captured from the production database on the test machine.
The following steps may be used to replay the database workload:
1) Preprocess the captured workload
2) Restart the database in RESTRICTED mode.
3) Set up Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Which is the correct sequence of the required steps?

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

Answer: B

Explanation:
11.1 Steps for Replaying a Database Workload
Proper planning of the workload replay and preparation of the replay system ensures that the replay will be accurate. Before replaying a database workload, review and complete the
following steps as appropriate:
✑ Setting Up the Replay Directory
✑ Restoring the Database
✑ Resolving References to External Systems
✑ Remapping Connections
✑ User Remapping
✑ Specifying Replay Options
✑ Using Filters with Workload Replay
✑ Setting Up Replay Clients

NEW QUESTION 23

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

• A. Database must be running in archivelog mode.
• B. Automatic undo management must be enabled.
• C. Undo retention guarantee must be enabled.
• D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

Answer: BD

NEW QUESTION 24

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

• A. TEST_TBS is a small file tablespace.
• B. TEST_TBS is a bigfile tablespace (BFT).
• C. TEST_TBS is the default temporary tablespace.
• D. TEST_TBS is a dictionary-managed tablespace.

Answer: D

NEW QUESTION 25
......