You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?（）A、PhaseB、StatusC、Source TypeD、Rule FunctionE、Customization Level

第1题：

You need to deliver the three reports that detail the previous days transaction activity. What should you do?（）

• A、Create a new report that has three embedded subreports. Create one standard subscription.
• B、Create three new reports based on the same dataset. Create one data-driven subscription.
• C、Create three data-driven subscriptions on a single shared schedule. Ensure that the e-mail recipient list is identical across all three subscriptions.
• D、Create three standard subscriptions on a single shared schedule. Ensure that the mail recipient list and subject are identical across all three subscriptions.

第2题：

Which command do you use to display the status of an antivirus database update?（）

• A、show security utm anti-virus status
• B、show security anti-virus database status
• C、show security utm anti-virus database
• D、show security utm anti-virus update

第3题：

You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

• A、a table name which has 100s of records
• B、a table name which has 10s of records
• C、a table name which has empty records
• D、a table name which has 1000s of records
• E、never use a table name

第4题：

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

• A、Shared pool 
• B、Control file 
• C、SGA 
• D、PGA

第5题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data.

第6题：

You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

• A、SYSTEM 
• B、OUTLN 
• C、INTERNAL 
• D、SYS

第7题：

Your network contains an Active Directory domain named contoso.com. You have a management  computer named Computer1 that runs Windows 7.     You need to forward the logon events of all the domain controllers in contoso.com to Computer1.     All new domain controllers must be dynamically added to the subscription.   What should you do（）

• A、From Computer1， configure source-initiated event subscriptions. From a Group Policy object （GPO） linked to the Do
• B、From Computer1， configure collector-initiated event subscriptions. From a Group Policy object （GPO） linked to the D
• C、From Computer1， configure source-initiated event subscriptions. Install a server authentication certificate on Compu
• D、From Computer1， configure collector-initiated event subscriptions. Install a server authentication certificate on Com

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are working on a debug build of an application.You need to find the line of code that caused an exception to be thrown. Which property of the Exception class should you use to achieve this goal？（）

• A、Data
• B、Message
• C、Stack Trace
• D、Source

第14题：

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

• A、 SQL Tuning Advisor
• B、 Undo Advisor
• C、 ADDM
• D、 Memory Advisor

第15题：

The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）

• A、REF cursor. 
• B、Instead Of trigger. 
• C、Stored procedure that returns object values. 
• D、The underlying view cannot be modified because DML on a view is not supported.

第16题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第17题：

You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 

• A、V$DATABASE 
• B、DBA_TABLES 
• C、SYSAUD$ 
• D、EMP

第18题：

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application contains a ListBox control named lbxItems that is data-bound to a collection of objects. Each object has a DisplayValue property. You add a Button control to the application. You need to ensure that the Content property of the Button control is data-bound to the DisplayValue property of the selected item of lbxItems. Which binding expression should you use?（）

• A、 { Binding ElementName=lbxItems, Source=SelectedItem, Path=DisplayValue }
• B、 { Binding Source=lbxItems, ElementName=SelectedItem, Path=DisplayValue }
• C、 { Binding ElementName=lbxItems, Path=SelectedItem.DisplayValue }
• D、 { Binding Source=lbxItems, Path=SelectedItem.DisplayValue }

第19题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

• A、You should configure the database for Read Committed Snapshot isolation. 
• B、You should modify the stored procedure to use the Snapshot isolation level 
• C、You should configure the database for Auto Update Statistics asynchronously 
• D、You should modify the stored procedure to use the Repeatable Read isolation level

第20题：

第21题：

第22题：

第23题：