单选题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（）AUsing the MERGE commandBUsing the SQL*Loader utilityCUsing the correlated UPDATE commandDUsing the INSERT command to perform bulk operation
单选题
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
参考解析
解析：
暂无解析
相关考题：
WE price this new product economically with a view()promoting the transaction. A、toB、ofC、inD、on
Examine the data in the EMPLOYEES and EMP_HIST tables:The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.Which statement accomplishes this task?（）A.B.C.D.
Which two types of information might be found at the Small Business Partner Central website？ （）A、 sales program informationB、 online product orderingC、 technology partner products and servicesD、 product information on the Data Center productsE、 specialization and certification details
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.
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 onlyB、Flashback Table onlyC、Flashback Versions Query onlyD、Flashback Database and Flashback Transaction QueryE、Flashback Versions Query and Flashback Transaction Query
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 sizeB、Last analyzed dateC、Size of table in bytesD、Size of table in database blocksE、Number of free blocks in the free listF、Number of extents present in the table.
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.
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 updatedB、null lock on the table containing the rowC、ROW SHARE lock for the row being updatedD、ROW EXCLUSIVE lock for the row being updatedE、shared row-exclusive lock for the row being updatedF、a shareable table lock for the table containing the rowG、exclusive table-level lock for the table containing the row
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
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 commandB、Using the SQL*Loader utilityC、Using the correlated UPDATE commandD、Using the INSERT command to perform bulk operation
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.
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.’
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（）
单选题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？（）AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates
单选题According to the passage, which technique is not used by advertisers to get our attention?AA product may be filmed or photographed to make it appear better.BA product may be presented as “unique”, “supreme”CA product may claim to be “new” or “improved”.DA product may be sold at a discount.
多选题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？（）Anull lock on the row being updatedBnull lock on the table containing the rowCROW SHARE lock for the row being updatedDROW EXCLUSIVE lock for the row being updatedEshared row-exclusive lock for the row being updatedFa shareable table lock for the table containing the rowGexclusive table-level lock for the table containing the row
单选题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？（）AReplace line 11 with the following code segment. context.MapRoute（"product_default"， "{area}/{controller}/{action}/{id}"， New With {.area = "product"， .controller = "Product"， .action = "Index"， .id = ""}）BReplace line 11 with the following code segment. context.MapRoute（"product_default"， "{area}"， New With {.controller = "Product"， .action = "Index"， .id = ""}）CAdd the following code segment at line 12. AreaRegistration.RegisterAllAreas（）DAdd the following code segment to the RegisterRoutes method in the Global.asax.vb file. AreaRegistration.RegisterAllAreas（）
单选题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？（）ARMAN onlyBFlashback Table onlyCFlashback Versions Query onlyDFlashback Database and Flashback Transaction QueryEFlashback Versions Query and Flashback Transaction Query
多选题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？（）AAverage row sizeBLast analyzed dateCSize of table in bytesDSize of table in database blocksENumber of free blocks in the free listFNumber of extents present in the table.
多选题Which two types of information might be found at the Small Business Partner Central website？ （）Asales program informationBonline product orderingCtechnology partner products and servicesDproduct information on the Data Center productsEspecialization and certification details
单选题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？（）ADefine 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.BDefine the new column as NOT NULL with a default value of ’Undefined.’CDefine the new column as NULL. Use application logic to enforce the data constraint.DDefine the new column as NULL with a default value of ’Undefined.’
单选题Every product _____ before it is sold.Aneeds to examineBneeds to have examinedCwants examiningDwants to exam
单选题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？（）AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates.
单选题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.
单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code， which is the primary key. As part of the archival process， the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products，the company deals with many new products during every quarter. Which method is best suited for this quarterly data transfer（）Ausing the MERGE commandBusing the SQL*Loader utilityCusing the correlated UPDATE commandDusing the INSERT command to perform bulk operation
单选题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（）AUsing the MERGE commandBUsing the SQL*Loader utilityCUsing the correlated UPDATE commandDUsing the INSERT command to perform bulk operation
单选题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？（）ACreate the product. Create each SKU. For each SKU create two descriptive attributes with the correct values.BCreate the product. Create two defining attributes. Create each SKU and during creation assign theattributes to the SKU with the correct values.CCreate the product. Create two defining attributes with the permitted values. Generate the SKUs.DCreate the product. Create two descriptive attributes with the permitted values. Generate the SKUs.