QUESTION 1 View the Exhibit. The EMPLOYEES table contains 100 records. You are developing a Human Resources form that has an Employees block with properties as shown in the exhibit. When you run the form and execute a query in the Employees block, approximately how many network round trips will be made to the server […]
Category: Check Point Dumps
QUESTION 1 Which three actions would be helpful in determining the cause of a node reboot? A. determining the time of the node reboot by using the update command and subtracting the up time from the current system time B. looking for messages such as “Oracle CSSD failure. Rebooting for cluster integrity /var/log/messages C. using […]
QUESTION 1 Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.) A. Cursor cache B. Stored outline C. SQL Tuning Set D. Automatic Workload Repository (AWR) snapshots Answer: AC
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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. […]
QUESTION 1 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 […]
QUESTION 1 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 […]
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 […]