The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）A、Write client-side subprograms containing the PL/SQL8 cons

第1题：

You create a Microsoft ASP.NET AJAX application by using the Microsoft .NET Frameworkversion 3.5.  You attach Microsoft Visual Studio 2008 debugger to the Microsoft Internet Explorer instance to debug the JavaScript code in the AJAX application.  You need to ensure that the application displays the details of the client-side object on the debugger console.  What should you do？（）

• A、Use the Sys.Debug.fail method. 
• B、Use the Sys.Debug.trace method. 
• C、Use the Sys.Debug.assert method. 
• D、Use the Sys.Debug.traceDump method.

第2题：

When compressing data with the DeflateStream class， how do you specify a stream into which to write compressed data？（）

• A、 Set the BaseStream property with the destination stream， and set the CompressionMode property to Compression.
• B、 Specify the stream to write into the DeflateStream object is created （for example， in the constructor）.
• C、 Use the Write method of the DeflateStream class.
• D、 Register for the BaseSream event of the DeflateStream class.

第3题：

The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit,respectively. How do you accomplish this?（）

• A、Add the appropriate PL/SQL code for each key. 
• B、Map the logical keys to the physical keys, then add the appropriate PL/SQL code for each key.
• C、Create an object library to define the key triggers, then reference the object library in the form. 
• D、This cannot be accomplished because other function keys provide this functionality by default.

第4题：

You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）

• A、Use a flashback query to retrieve the rows that were deleted
• B、Useconventialincremental export and then import the affected object
• C、Shutdown the database inNORMALmode and restart the database instance
• D、Use DBMS_META package to reconstruct the object using undo segments
• E、UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
• F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

第5题：

Which two PL/SQL8 features are supported in Oracle Forms?（）

• A、methods 
• B、object tables 
• C、object columns 
• D、collection types 
• E、object as stored procedure parameters

第6题：

You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）

• A、functions
• B、packages
• C、procedures
• D、database triggers
• E、anonymous PL/SQL block

第7题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You want to make sure that the application is operative to any type of database.   What should you do？（）

• A、 Set the database driver name in the connection string of the application， and then the connection object as follows： DbConnection connection = new OdbcConnection（connectionString）；
• B、 Create the connection object as follows： DbProviderFactory factoryDbProviderFactories.GetFactory（databaseProviderName）； DbConnection connection =factory.CreateConnection（）；
• C、 Create the connection object as follows： DbProviderFactory factory = DbProviderFactories.GetFactory（"System.Data.Odbc"）； DbConnection connection = factory.CreateConnection（）；
• D、 Set the database driver name in the connection string of the application， and then the connection object as follows：DbConnection connection = new OleDbConnection（connectionString）；

第8题：

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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） 

• A、You should use SQLServer:Buffer Manager
• B、You should use SQLServer:Memory Manager 
• C、You should use SQLServer:Databases 
• D、You should use SQLServer:Access Methods

第9题：

第10题：

第11题：

第12题：

第13题：

You create a Microsoft ASP.NET AJAX application by using the Microsoft .NET Framework version 3.5.  You attach Microsoft Visual Studio 2008 debugger to the Microsoft Internet Explorer instance to debug the JavaScript code in the AJAX application.  You need to ensure that the application displays the details of the client-side object on the debugger console.  What should you do？（）

• A、Use the Sys.Debug.fail method.
• B、Use the Sys.Debug.trace method.
• C、Use the Sys.Debug.assert method.
• D、Use the Sys.Debug.traceDump method.

第14题：

The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）

• A、Programme units. 
• B、PL/SQL libraries. 
• C、Database object. 
• D、Built in packages.

第15题：

You created a custom menu for the Order Entry application. The shipping administrator has requested an additional submenu containing four items to invoke various reports. Which command type must you use to identify the parent menu item as a submenu? （）

• A、Menu 
• B、Plus 
• C、Macro
• D、PL/SQL

第16题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

• A、 functions
• B、 package
• C、 procedure
• D、 database trigger
• E、 anonymous PL/SQL block

第17题：

You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）

• A、An object type is a user-defined composite data type. 
• B、The attributes of an object type can be those of other object types. 
• C、A PL/SQL table of records is an example of a nested object type. 
• D、An object type must be declared as a type before the actual object itself can be declared.

第18题：

You are planning to upgrade Internet Explorer.   You have the following requirements：   Create a report that identifies which computers are successfully upgraded. Do not install additional software on the client computers.   You need to design a deployment method that meets the requirements.   What should you do？（）

• A、Use Internet Explorer Administration Kit （IEAK） and Group Policy.
• B、Use Microsoft System Center Configuration Manager.
• C、Use Windows Server Update Services （WSUS）.
• D、Use Microsoft System Center Essentials.

第19题：

You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The database on the Microsoft SQL Server 2005 database has two tables that are displayed by using two SqlConnection objects in two different GridView controls. You want the tables to be displayed at the same time with the use a single SqlConnection object.   What should you do？（）

• A、 Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
• B、 Enable Multiple Active Result Sets （MARS） in the connection string of the application. 
• C、 Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
• D、 Run the two SqlDataReader objects by using a single SqlCommand object.

第20题：

第21题：

第22题：

第23题：