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 […]
Category: Oracle Exam
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 […]
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 […]
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 […]
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? […]
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. […]
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. […]
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 […]
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 […]
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 […]
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, […]
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. […]
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 […]