多选题Given a web application in which the request parameter product ID contains a product identifier.Which two EL expressions evaluate the value of the product ID？（）A${product ID}B${param.productID}C${params.productID}D${params.productID[1]}E${paramvalues.p

第1题：

第2题：

已知xml文档包含如下内容（list为根元素）： ＜list＞ ＜item id="0001"＞ ＜price＞18＜/price＞ ＜/item＞ ＜item id="0002"＞ ＜price＞15＜/price＞ ＜/item＞ ＜item/＞ ＜product＞ ＜item id="01"＞＜/item＞ ＜/product＞ ＜/list＞ 使用xslt进行转换时，语句＜xsl:template match=”/list/item[@id]”＞能够匹配到（）个item元素。

• A、3
• B、2
• C、1
• D、0

第3题：

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

• A、Selection, projection, join
• B、Difference, projection, join
• C、Selection, intersection, join
• D、Intersection, projection, join
• E、Difference, projection, product

第4题：

WebSphere Commerce Accelerator will be used to create a product. The product has 6 variations determined by attributes Size， which has three values and Color， which has two values. What is the PREFERRED method to create the product and its SKUs using the Product Management tool？（）

• A、Create the product. Create each SKU. For each SKU create two descriptive attributes with the correct values.
• B、Create the product. Create two defining attributes. Create each SKU and during creation assign theattributes to the SKU with the correct values.
• C、Create the product. Create two defining attributes with the permitted values. Generate the SKUs.
• D、Create the product. Create two descriptive attributes with the permitted values. Generate the SKUs.

第5题：

Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）

• A、 It would be created only if a unique index is manually created first.
• B、 It would be created and would use an automatically created unique index.
• C、 It would be created and would use an automatically created nonunique index.
• D、 It would be created and remains in a disabled state because no index is specified in the command.

第6题：

The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement?（）

• A、The results are not sorted.
• B、The results are sorted numerically.
• C、The results are sorted alphabetically.
• D、The results are sorted numerically and then alphabetically.

第7题：

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

• A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
• B、Define the new column as NOT NULL with a default value of ’Undefined.’
• C、Define the new column as NULL. Use application logic to enforce the data constraint.
• D、Define the new column as NULL with a default value of ’Undefined.’

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

以下用法中正确的是（）

ARS = conn.Execute（“SELECT *FORM product”）

BSet RS = conn.Execute （“SELECT *FORM product”）

CConn.Execute （“DELETE *FORM product WHERE ID=132”）

DConn.Ececute “DELETE *FORM product WHERE ID=132”

第14题：

Given a web application in which the request parameter productID contains a product identifier. Which twoEL expressions evaluate the value of the productID？（）

• A、${productID}
• B、${param.productID}
• C、${params.productID}
• D、${params.productID[1]}
• E、${paramValues.productID}
• F、${paramValues.productID[0]}

第15题：

为UAP3300申请license时，需要和ESN做绑定的是（）。

• A、Activation ID
• B、Contract No
• C、Entitlement ID
• D、Product ID

第16题：

Given a web application in which the request parameter product ID contains a product identifier.Which two EL expressions evaluate the value of the product ID？（）

• A、 ${product ID}
• B、 ${param.productID}
• C、 ${params.productID}
• D、 ${params.productID[1]}
• E、 ${paramvalues.productID}
• F、 ${paramValues.productID[0]}
• G、 ${pageContext.request.productID}

第17题：

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

• A、Selection, projection, join
• B、Difference, projection, join
• C、Selection, intersection, join
• D、Intersection, projection, join
• E、Difference, projection, product

第18题：

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

• A、selection, projection, join
• B、difference, projection, join
• C、selection, intersection, join
• D、intersection, projection, join
• E、difference, projection, product

第19题：

You are implementing an ASP.NET MVC 2 application. In the Areas folder， you add a subfolder named Product to create a single project areA.  You add files named ProductController.vb and Index.aspx to the appropriate subfolders.  You then add a file named Route.vb to the Product folder that contains the following code.01 Public Class Route  Inherits AreaRegistration02  03 Public Overrides ReadOnly Property AreaName As String04 Get  05 Return "product"06 End Get  07 End Property08  09 Public Overrides Sub RegisterArea（ByVal context As AreaRegistrationContext）10  11 context.MapRoute（"product_default"， "product/{controller}/{action}/{id}"， New With {.controller = "Product"， .action = "Index"，.id = ""}）12  13 End Sub  End Class  When you load the URL http：///product， you discover that the correct page is not returned. You need to ensure that the correct page is returned. What should you do？（）

• A、Replace line 11 with the following code segment. context.MapRoute（"product_default"，   "{area}/{controller}/{action}/{id}"， New With {.area = "product"， .controller = "Product"，   .action = "Index"， .id = ""}）
• B、Replace line 11 with the following code segment. context.MapRoute（"product_default"，   "{area}"， New With {.controller = "Product"， .action = "Index"， .id = ""}）
• C、Add the following code segment at line 12.  AreaRegistration.RegisterAllAreas（）
• D、Add the following code segment to the RegisterRoutes method in the Global.asax.vb file.   AreaRegistration.RegisterAllAreas（）

第20题：

第21题：

第22题：

第23题：