单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming

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.

An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)Which of the following SQL statements will provide the table definition that meets the specified requirements?（）

A.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

B.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

C.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

D.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

●The TCP protocolis a (71) layer protocol. Each connection connects two TCPs that may be just one physical network apart or located on opposite sides ofthe globe. In other words, each connection creates a (72) witha length that may be totally different from another path created by another connection. This means that TCP cannot use the same retransmission time for all connections. Selecting afixed retransnussion time for all connections can result in serious consequences. Ifthe retransmission time does not allow enough time for a (73) to reach the destination and an acknowledgment to reach the source, it can result in retransmission of segments that are still on the way. Conversely, if the retransnussion time is longer than necessary for a short path, it may result in delay for the application programs.

Even for one single connection, the retransmission time should not be fixed.A connection may be able to send segments and receive (74)faster during nontraffic period than during congested periods. TCP uses the dynamic retransmission time,a transmission time is different for each connection and which may be changed during the same connection. Retransmission time can be made(75) by basing it on the round-trip time (RTT). Several formulas are used for this purpose.

(71) A.physical

B.network

C.transport

D.application

(72) A.path

B.window

C.response

D.process

(73) A.process

B.segment

C.program

D.user

(74) A.connections

B.requests

C.acknowledgments

D.datagrams

(75) A.long

B.short

C.fixed

D.dynamic

A financial customer has three data centers that are approximately five kilometers apart. Their SAP application data needs to be kept synchronized within 10 milliseconds between the three sites.Which of the following solutions satisfies the customer‘s recovery time objective?（）

A. DS8700 systems at each site running Metro Mirror

B. DS5300 systems at each site running Metro Mirror

C. DS5100 systems at each site running Global Mirror

D. XIV systems at each site running synchronous mirroring

The TCP protocolis a (71) layer protocol. Each connection connects two TCPs that may be just one physical network apart or located on opposite sides ofthe globe. In other words, each connection creates a (72) witha length that may be totally different from another path created by another connection. This means that TCP cannot use the same retransmission time for all connections. Selecting afixed retransnussion time for all connections can result in serious consequences. Ifthe retransmission time does not allow enough time for a (73) to reach the destination and an acknowledgment to reach the source, it can result in retransmission of segments that are still on the way. Conversely, if the retransnussion time is longer than necessary for a short path, it may result in delay for the application programs.Even for one single connection, the retransmission time should not be fixed.A connection may be able to send segments and receive (74)faster during nontraffic period than during congested periods. TCP uses the dynamic retransmission time,a transmission time is different for each connection and which may be changed during the same connection. Retransmission time can be made(75) by basing it on the round-trip time (RTT). Several formulas are used for this purpose.

A.physical

B.network

C.transport

D.application@@@SXB@@@A.path

B.window

C.response

D.process@@@SXB@@@A.process

B.segment

C.program

D.user@@@SXB@@@A.connections

B.requests

C.acknowledgments

D.datagrams@@@SXB@@@A.long

B.short

C.fixed

D.dynamic

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

A.REFERENCES

B.SELECT

C.UPDATE

D.ALTER

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

A.A

B.B

C.C

D.D