单选题You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）A On the Oracle server. B Locally in each form module. C In an attached PL/SQL library D On your file network server.

第1题：

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.

第2题：

You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）

• A、On the Oracle server. 
• B、Locally in each form module. 
• C、In an attached PL/SQL library 
• D、On your file network server.

第3题：

You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）

• A、A trigger in each form. 
• B、A subprogram in each form. 
• C、A stored subprogram in the database. 
• D、A subprogram in a library that is attached to each form.

第4题：

You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases.  What should you include in your naming convention（）？ 

• A、For each mailbox database， provide a database name that is unique within the organization.
• B、For each mailbox database， provide a database name that is unique within the Mailbox server.
• C、For each mailbox database file， provide a file name that is unique within the organization.
• D、For each mailbox database file， provide a file name that is unique within the Mailbox server.

第5题：

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）

• A、DBCC DBREINDEX
• B、SELECT * FROM sys.dm_db_index_physical_stats
• C、DBCC INDEXDEFRAG
• D、SELECT * FROM sys.indexes

第6题：

You are the network administrator for . Your network consists of a single Active Directory domain named . All network servers run Windows Server 2003, and all client computers run Windows XP Professional. You install a new file and print server named File1. You configure standard company policies and other local options. You use third-party software to create and save an image of the server. Then you join File1 to the domain. Six weeks later, you reapply the saved image to File1 and restart the server. You try to log on to the domain by using domain credentials. However, you are unsuccessful. You need to log on to File1 and re-establish its domain membership. Your solution must require the minimum amount of administrative effort. Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two)

• A、Reset the computer account for File1 in Active Directory Users and Computers.
• B、Reset the password for Administrator account by logging on locally to File1 as a member of the local Power Users group.
• C、Reinstall and reconfigure File1.
• D、Join File1 to the domain.
• E、Remove File1 from the domain.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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 constructs, and move them into an object group. 
• B、Write server-side subprograms, and call the subprograms from the form application. 
• C、Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.

第14题：

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）

• A、Parallel compilation of only the stored PL/SQL code
• B、Sequential recompilation of only the stored PL/SQL code
• C、Parallel recompilation of any stored PL/SQL code
• D、Sequential recompilation of any stored PL/SQL code
• E、Parallel recompilation of Java code
• F、Sequential recompilation of Java code

第15题：

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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

• A、You should use local Service account
• B、You should use network Service account
• C、You should use domain account
• D、You should use local System account

第16题：

You have an Exchange Server 2010 organization that contains 20 Mailbox servers. You plan to create 10 mailbox databases on each Mailbox server.You need to create a naming convention for all mailbox databases. What should you include in your naming convention？（）

• A、For each mailbox database， provide a database name that is unique within the organization.
• B、For each mailbox database， provide a database name that is unique within the Mailbox server.
• C、For each mailbox database file， provide a file name that is unique within the organization.
• D、For each mailbox database file， provide a file name that is unique within the Mailbox server.

第17题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least.  Which action should you perform？（）

• A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
• B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.
• C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.
• D、You should place a unique index on the PartNum column.

第18题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases.  Which action should be performed to achieve the goal？（）

• A、To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.
• B、To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.
• C、To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.
• D、To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.

第19题：

第20题：

第21题：

第22题：

第23题：