违法和不良信息举报 联系客服
免费注册 登录

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

题目
单选题
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 command

B

using the SQL*Loader utility

C

using the correlated UPDATE command

D

using the INSERT command to perform bulk operation

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

正确答案:A,E

第2题：

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

正确答案:E

第3题：

WE price this new product economically with a view()promoting the transaction.

A、to

B、of

C、in

D、on


参考答案：A

第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

正确答案:D,F

第5题：

In which scenario will you use the Flashback Transaction Query feature？（）

  • A、 when you want to restore an important table that is dropped from the Recycle Bin
  • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
  • C、when you want to restore a dropped user’s schema
  • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

正确答案:B

第6题：

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.

正确答案:C

第7题：

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.

正确答案:D

第8题：

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.


参考答案：B

第9题：

The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）

  • A、B-tree
  • B、bitmap
  • C、reverse key
  • D、function based

正确答案:B

第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

正确答案:D

更多相关问题
相关内容