Which is the correct description of the significance of the ORACLE_HOME environmental variable?
A. It specifies the directory containing the Oracle software.
B. It specifies the directory containing the Oracle-Managed Files.
C. It specifies the directory for database files, if not specified explicitly.
D. It specifies the base directory of Optimal Flexible Architecture (OFA).
The Oracle Application Server is installed on your machine. In Forms Builder, you open the HResource form and connect to the HR database. You also edit your Forms Builder run-time preferences and click Set Default. To test the HResource form module, you click Run Form and receive the error message FRM-10142 (The HTTP listener is not running). What action should you take?
A. Start an OC4J instance.
B. Start the Oracle HTTP Server.
C. Run the batch file STOPINST.BAT.
D. Start the browser before clicking Run Form.
E. Generate the form and move the .fmx file to the Oracle Application Server deployment directory.
You instance has these parameter settings:
Which three statements are true about these settings if no hints are used in a SQL statement?
A. A statement estimated for more than 10 seconds always has its degree of parallelism computed automatically.
B. A statement with a computed degree of parallelism greater than 8 will be queued for a maximum of 10 seconds.
C. A statement that executes for more than 10 seconds always has its degree of parallelism computed automatically.
D. A statement with a computed degree of parallelism greater than 8 will raise an error.
E. A statement with any computed degree of parallelism will be queued if the number of busy parallel execution processes exceeds 64.
F. A statement with a computed degree of parallelism of 20 will be queued if the number of available parallel execution processes is less 5.
Requirement demands that an incoming request from a portfolio manager has to have a higher priority compared to other users of the application. As an administrator, which one of the following approaches would you adopt?
A. Use Work Manager with the execute thread model to set up rules to associate a priority to the user.
B. Use Work Manager fair-share-request-class to associate a priority to the user.
C. Use Work Manager response-time-request-class to associate a priority to the user.
D. Use Work Manager context-request-class to associate a priority to the user.
Which two statements are true about java EE shared libraries?
A. A shared library cannot bedeployed to a cluster.
B. An application that is targeted to server1 can use a shared library that is targeted to server 2.
C. Multiple versions of the same shared library can be deployed and be active at the same time
D. A shared library is referenced through an application’s deployment descriptor.
Which two statements are true concerning the installation and configuration of the bootloader by the Anaconda installer, which is then used to boot Oracle Linux?
A. The Linux Loader (LILO) bootloader may be chosen for installation.
B. The bootloader must be password protected and Anaconda prompts for a password in all cases.
C. The Grand Unified Bootloader (GRUB) is the only bootloader used by Oracle Linux.
D. If previously installed operating systems are found on disk partitions that were not overwritten, then an attempt is made to configure the bootloader to be able to boot them.
E. The bootloader is installed by default in the first partition of the disk.
Which statements are true regarding configuring multiple buffer pools in the Database Buffer Cache that is using only the standard block size? (Choose all that apply.)
A. Both the KEEP and RECYCLE pools must be configured.
B. The RECYCLE pool needs to be configured before dropping an object.
C. The DEFAULT pool needs to be removed if multiple buffer pools are being configured.
D. Either the KEEP pool or the RECYCLE pool can be configured along with the DEFAULT pool.
Users in your development database complain that they are getting the following error while trying to execute a query on the SALES_HISTORY table:
ERROR at line 1:
ORA-00942: table or view does not exist
While investigating the reason, you find that a hardware failure occured, resulting in the loss of one of the available disk drives used by the database. While waitinig for a replacement drive, the DBA removed the un-needed data from the database and during the removl the SALES_HISTORY table was dropped accidentally.
Within few minutes a second hardware failure corrupted another disk drive, resulting in the loss of the current online redo log files and the logical back ups of the database. The redo log files were not multiplexed and the current redo log file is not yet archived. Which recovery method would you follow to recover the SALES_HISTORY table?
A. Open Database complete recovery
B. Cancel-Based incomplete recovery
C. Change-Based incomplete recovery
D. Closed Database complete recovery
E. recovery using the backup control file
Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
DECLARE report clob;
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
Which statement describes the effect of the execution of the above PL/SQL block?
A. The plan baselines are verified with the SQL profiles.
B. All fixed plan baselines are converted into nonfixed plan baselines.
C. All the nonaccepted SQL profiles are accepted into the plan baseline.
D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output. Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)
A. Running SQL Access Advisor
B. Adding them to SQL Plan Baseline
C. Submitting them to SQL Tuning Advisor
D. Running Automatic Database Diagnostic Monitor (ADDM)
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.
A. 2, 4, and 5
B. All the steps
C. 2, 3, 4 and 5
D. 1, 2, 4, 5 and 6
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.
In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services?
A. to transfer redo log information to one or more destinations
B. to apply redo log records sent from the primary database to a standby database at the receiving location
C. to synchronize changes to the control files on all standby databases with changes on the primary database when a log switch occurs
D. to batch archived log files on the primary database until a defined number of checkpoints have been processed and then to distribute the archives to each standby database
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct? (Choose two.)
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
Identify three components of an Oracle instance for which you can change the size dynamically. (Choose three.)
A. Java Pool
B. Large Pool
C. Shared Pool
D. Redo Log Buffer
E. Database Buffer Cache