QUESTION 1 View the Exhibit. Which two statements are true about the output of the cat /proc/partitions command? (Choose two.)   A.    The hard disk has four partitions. B.    The hard disk has six partitions. C.    The swap partition is not shown in the output. D.    The major column shows the device number with partitions. Read more

QUESTION 1 Identify four uses of the Oracle Scheduler. (Choose four.) A.    Enables you to set idle time limits for a resource plan. B.    Enables you to schedule job execution based on time. C.    Enables you to execute jobs in a clustered environment. D.    Enables you to assign priorities to the consumer groups. E.    Enables Read more

QUESTION 1 A database is running in ARCHIVELOG mode. It has two online redo log groups and each group has one member. A LGWR I/O fails due to permanent media failure that has resulted in the loss of a redo log file and the LGWR terminates causing the instance to crash. Which method should be Read more

QUESTION 1 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 Read more

QUESTION 1 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 Read more

QUESTION 1 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 Read more

QUESTION 1 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 Read more

QUESTION 1 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 Read more

QUESTION 1 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.    Read more

QUESTION 1 Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000 DECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report); END; 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 Read more

QUESTION 1 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 Read more