1Z0-052

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

参考答案和解析
正确答案： A
解析： 暂无解析
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which statement is true about the routing table?（）

  • A、The routing table exists in the control plane only
  • B、The routing table exists in the control plane and the forwarding plane
  • C、The routing table contains both active and inactive routes
  • D、The routing table is stored on compact flash

正确答案:A

第2题：

Which statement is true about the forwarding table?（）

  • A、The forwarding table is stored in the control plane only
  • B、The forwarding table is stored in the control plane and in the forewarding plane
  • C、The forwarding table contains both active and inactive routes
  • D、The forwarding table can contain only sigle next hop per destination

正确答案:B

第3题：

定义“课程”表中“开课系名”字段的默认值为“中文”的正确命令是（ ）。

A.ALTER TABLE课程ALTER开课系名SET DE— FAULT中文

B.ALTER TABLE课程ALTER开课系名SET DE— FAULT”中文”

C.ALTER TABLE课程ALTER开课系名SET DE— FAULT开课系名=中文

D.ALTER TABLE课程ALTER开课系名SET DE FAULT开课系名=”中文”


正确答案：B
利用SQL命令可以对基本表的结构进行修改，利用下列命令可以修改表结构、定义有效性规则：ALTERTABLE<表名>ALTER[COLUMN]<字段名1>[NULLINOTNULL][SETDEFAULT<表达式>][SETCHECK<辑表达式>[ERROR<字符型文本信息>]][RENAMECOUMN<字段名2>TO<字段名3>]其中，SETDEFAULT<表达武>可以用来指定字段的默认值。注意：表达式值的类型要与字段类型一致。

第4题：

Which three are properties of the MyISAM storage engine?（）

  • A、Transaction support
  • B、FULLTEXT indexing for text matching
  • C、Table and page level locking support
  • D、Foreign key support
  • E、Geospatial indexing
  • F、HASH index support
  • G、Table level locking only

正确答案:B,E,G

第5题：

You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

  • A、All data along with the table structure is deleted 
  • B、The pending transaction in the session is committed 
  • C、All indexes on the table will remain but they are invalidated 
  • D、All views and synonyms will remain but they are invalidated 
  • E、All data in the table are deleted but the table structure will remain

正确答案:A,B,D

第6题：

Which statement is correct about the forwarding table?（）

  • A、The forwarding table is stored only on the PFE
  • B、The forwarding table contains all known routes
  • C、The forwarding table is stored on both the RE and PFE
  • D、The forwarding table is stored only on the RE

正确答案:C

第7题：

At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

  • A、 William used the Flashback Version Query feature.
  • B、 William issued the CROSSCHECK command at the RMAN prompt.
  • C、 William viewed the alert log file.
  • D、 William used the Flashback Table feature.

正确答案:A

第8题：

Which statement is correct about the forwarding table?()

A. The forwarding table is stored only on the PFE

B. The forwarding table contains all known routes

C. The forwarding table is stored on both the RE and PFE

D. The forwarding table is stored only on the RE


参考答案：C

第9题：

You executed this command to create a temporary table：  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）

  • A、The rows stay in the table only until session termination.
  • B、The rows stay in the table only until the next transaction starts on the table.
  • C、The rows are visible to all current sessions after the transaction is committed.
  • D、The rows stay available for subsequent sessions after the transaction is committed

正确答案:A

第10题：

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

正确答案:A

更多相关问题
相关内容