单选题For an inventory report, you created a work_in_progress that contains two columns, ID_number and quantity. The parent group of the work_in_progress is in_inventory which contains one column, dept_no. You added a filter of fist fifteen to total_inventor

第1题：

You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）

• A、 .SQL 
• B、 .PLL 
• C、 .PLD
• D、 .PRT

第2题：

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

第3题：

Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）

• A、Specify the break order on the gemp group Property palette. 
• B、Specify a break order on the dept_name and job columns property palettes. 
• C、Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
• D、Change the position of the dept_name and the job columns within the gemp group.

第4题：

Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors：   ORA-00313： open failed for members of log group 1 of thread 1   ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue？（）

• A、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；
• B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；
• C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；
• D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；

第5题：

You have an Exchange Server 2010 organization.  You plan to delegate administration of the organization.  You have a group named Technicians that contains all the level-two technicians in the organization. You need to ensure that the Technicians group can manage the properties of all the mailbox databases. The solution must minimize the number of permissions assigned to the Technicians group.  Which management role should you assign to the Technicians group？（）

• A、Help Desk
• B、Organization Management
• C、Recipient Management
• D、Server Management

第6题：

You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)01 dtOrders = dsOrders.Tables[“Orders”]; 02 dtOrderDetails = dsOrders.Tables[“OrderDetail”]; 03 colParent = dtOrders.Columns[“OrderID”]; 04 colChild = dtOrderDetails.Columns[“ParentOrderID”]; 05 dsOrders.Relations.Add(“Rell”, colParent, colChild, false); You need to find the cause of the exception being raised in line 05. What should you do? （）

• A、Ensure that the child column and the parent column have the same names.
• B、Ensure that the child table and the parent table have the same names.
• C、Ensure that the child column and the parent column have the same data types.
• D、Ensure that each row in the child table has a corresponding row in the parent table.
• E、Ensure that the tables have an explicit relationship defined by a foreign key constraint in the database.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which two are true about aggregate functions? （）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第14题：

Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

• A、 ALTER DATABASE DROP LOGFILE GROUP 1
• B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
• C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
• D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

第15题：

You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）

• A、After the query. 
• B、Enter the report and change the column's position in the field tab. 
• C、Alter the column's position in the object navigator. 
• D、Enter the report wizard and change the column's position in the data tab. 
• E、Alter the column's position within its group and change the layout. 

第16题：

You are designing a Windows Azure application that will include two web roles.  The web roles will communicate with on-premise development computers and on-premise databases.  Web Role 1 must connect to development computers and databases.  Web Role 2 must connect to only databases.  What should you recommend？（）

• A、 Create one endpoint group that contains the development computers and one endpoint group that contains the databases. Connect Web Role 1 to both endpoint groups. Connect Web Role 2 to only the database endpoint group.
• B、 Create one endpoint group that contains the development computers and databases. Connect Web Role 1 and Web Role 2 to the endpoint group.
• C、 Create one endpoint group that contains the development computers and one endpoint group that contains the databases. Connect the endpoint groups. Connect Web Role 1 and Web Role 2 to the development computer group.
• D、 Create one endpoint group that contains the development computers and databases， and connectit to Web Role 1.  Create one endpoint group that contains only the databases， and connect it to Web Role 2.

第17题：

Your network contains a Windows Server Update Services (WSUS) server.You have an organizational unit (OU) named Sales. The Sales OU contains all of the computer objects for the sales department. You enable client-side targeting for the Sales OU and set the target group name to Sales-Computers.You restart a sales computer.You discover that the computer is not added to the Sales-Computer computer group in WSUS.You need to ensure that all sales computers are added to the Sales-Computers group. Which options should you configure?（）

• A、Automatic Approvals
• B、Computers
• C、Personalization
• D、Products and Classifications

第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 a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）

• A、A primary XML index should be created on the XML column.
• B、Statistics should be created on the nvarchar columns.
• C、A view should be created， and only the four columns that the query utilizes are contained by a view.
• D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：