单选题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题：

第2题：

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.

第3题：

第4题：

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

第5题：

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.

第6题：

Which two types of information might be found at the Small Business Partner Central website？ （）

• A、 sales program information
• B、 online product ordering
• C、 technology partner products and services
• D、 product information on the Data Center products
• E、 specialization and certification details

第7题：

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

第8题：

第9题：

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.

第10题：

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