单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code， which is the prima

第1题：

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.

第2题：

You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

• A、Average row size
• B、Last analyzed date
• C、Size of table in bytes
• D、Size of table in database blocks
• E、Number of free blocks in the free list
• F、Number of extents present in the table.

第3题：

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

• A、null lock on the row being updated
• B、null lock on the table containing the row
• C、ROW SHARE lock for the row being updated
• D、ROW EXCLUSIVE lock for the row being updated
• E、shared row-exclusive lock for the row being updated
• F、a shareable table lock for the table containing the row
• G、exclusive table-level lock for the table containing the row

第4题：

The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code， which is the primary key.As part of the archival process， the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products， the company deals with many new products during every quarter. Whichmethod is best suited for this quarterly data transfer（）

• A、Using the MERGE command
• B、Using the SQL*Loader utility
• C、Using the correlated UPDATE command
• D、Using the INSERT command to perform bulk operation

第5题：

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.’

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）

• A、RMAN only
• B、Flashback Table only
• C、Flashback Versions Query only
• D、Flashback Database and Flashback Transaction Query
• E、Flashback Versions Query and Flashback Transaction Query

第14题：

As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）

• A、A leaf will be marked as invalid.
• B、An update in a leaf row takes place.
• C、The index will be updated automatically at commit.
• D、A leaf row in the index will be deleted and inserted.
• E、The index becomes invalid when you make any updates.

第15题：

You work as a database administrator for Certkiller .com. As a result of performance analysis， you created an index on theprod_namecolumn of the  Certkiller prodtable， which contains about ten thousand rows. Later， you updated a product name in the table.  How does this change affect the index？（）

• A、A leaf will be marked as invalid.
• B、An update in a leaf row takes place.
• C、The index will be updated automatically at commit.
• D、A leaf row in the index will be deleted and inserted.
• E、The index becomes invalid when you make any updates

第16题：

By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） A list of changes made along with the transaction identifier of each change.  b） The necessary SQL statements to undo the erroneous changes.  Which option would you choose？（）

• A、 RMAN only.
• B、 Flashback Table only.
• C、 Flashback Version Query only.
• D、 Flashback Database and Flashback Transaction Query.
• E、 Flashback Version Query and Flashback Transaction Query.

第17题：

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（）

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：