Braindump2go Free Microsoft Dumps Questions Collection
Latest Real Exam Questions and Answers to help you pass Microsoft and other Hot exam 100%！
4 08 2014
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 […]
4 08 2014
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
4 08 2014
QUESTION 1 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize the access to available listeners? A. FAILOVER B. LOAD_BALANCE C. SOURCE_ROUTE D. TYPE_OF_SERVICE Answer: B
4 08 2014
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. […]
4 08 2014
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 […]
2 08 2014
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 […]
2 08 2014
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 […]
2 08 2014
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 […]
1 08 2014
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 […]
1 08 2014
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 […]
31 07 2014
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 […]
31 07 2014
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 […]
19 07 2014
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 […]
19 07 2014
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 […]
19 07 2014
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 […]
16 07 2014
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 […]
16 07 2014
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 […]
14 07 2014
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
14 07 2014
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 […]
11 07 2014
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 . […]