网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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.
考题
The company issues an annual report every March.A: a long
B: a yearly
C: a financial
D: a product
考题
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？（）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
考题
单选题According to the passage, which technique is not used by advertisers to get our attention?A
A product may be filmed or photographed to make it appear better.B
A product may be presented as “unique”, “supreme”C
A product may claim to be “new” or “improved”.D
A 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？（）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（）
考题
单选题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？（）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？（）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.’
考题
单选题Every product _____ before it is sold.A
needs to examineB
needs to have examinedC
wants examiningD
wants 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？（）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.
考题
单选题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（）A
using the MERGE commandB
using the SQL*Loader utilityC
using the correlated UPDATE commandD
using 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 commandB
Using the SQL*Loader utilityC
Using the correlated UPDATE commandD
Using 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？（）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.
热门标签
最新试卷