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


参考解析

解析: 暂无解析

相关考题:

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

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.

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 BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 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

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-treeB、bitmapC、reverse keyD、function based

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

You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?()A、Event Viewer gives more details on the failure.B、The alert log file gives detailed information about the failure.C、PMON rolls back the transaction and releases the locks.D、SMON rolls back the transaction and releases the locks.E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

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.

A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?()A、 Flashback DropB、 Flashback QueryC、 Flashback Versions QueryD、 Flashback Transaction QueryE、 Flashback Table

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

单选题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 BinB when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionCwhen you want to restore a dropped user’s schemaD 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

多选题Identify three situations in which you would NOT be able to drop a tablespace. ()Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction

单选题A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?()A Flashback DropB Flashback QueryC Flashback Versions QueryD Flashback Transaction QueryE Flashback Table

多选题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

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

单选题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?()AB­treeBbitmapCreverse keyDfunction based

单选题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.’

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