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...
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...
QUESTION 1 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...
QUESTION 1 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...
QUESTION 1 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...
QUESTION 1 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 Answer: BCE
QUESTION 1 When querying the v$sysstat, v$sesstat or v$mystat views, you notice the statistic “workarea executions – onepass”. What is the meaning of this statistic? A. It is the cumulative count of work areas running in more than one pass. B. It is the total amount of PGA memory dedicated to the work areas using...
QUESTION 1 Which two statements are true about the use of direct path loads when selecting from external tables in a database on a Database Machine? A. INSERT INTO . . . SELECT FROM statements, executed serially, which select from external tables, require the APPEND hint to use direct path loading. B. CREATE TABLE ....
QUESTION 1 View the Exhibit and examine the structure of the EMP table. Which stages are performed when the above block is executed? (Choose all that apply) A. Bind B. Parse C. Fetch D. Execute Answer: BCD
QUESTION 1 View the Exhibit and examine the structure of the ORDERS table. You have to display ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed after the last order placed by the customer whose CUSTOMER_ID is 101. Which query would give you the desired output? A. SELECT order_id, order_date FROM orders...
QUESTION 1 You have assigned rights profiles directly to the uses frank and now you want to add another profile. Which command enables you to list profiles directly assigned to frank? A. userattr profiles frank B. profiles – p frank C. useratter -p frank D. profiles frank Answer: B Explanation: http://docs.oracle.com/cd/E26502_01/html/E36219/rights-1.html (see the example 9-1)
QUESTION 1 What determines which bits in an IP address represent the subnet, and which represent the host? A. Subnet B. unicast C. netmask D. multicast E. broadcast Answer: C
QUESTION 1 What can you do with the DBMS_LOB package? A. Use the DBMS_LOB.WRITE procedure to write data to a BFILE. B. Use the DBMS_LOB.BFILENAME function to locate an external BFILE. C. Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE. D. Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed. Answer:...