单选题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?（）ADECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEBDECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSCCREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSDCREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
单选题
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.physicalB.networkC.transportD.application(72) A.pathB.windowC.responseD.process(73) A.processB.segmentC.programD.user(74) A.connectionsB.requestsC.acknowledgmentsD.datagrams(75) A.longB.shortC.fixedD.dynamic
Evaluate the following statements:What are the two consequences of the above statements?() 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.
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 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.physicalB.networkC.transportD.application@@@SXB@@@A.pathB.windowC.responseD.process@@@SXB@@@A.processB.segmentC.programD.user@@@SXB@@@A.connectionsB.requestsC.acknowledgmentsD.datagrams@@@SXB@@@A.longB.shortC.fixedD.dynamic
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 TABLEB.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
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.REFERENCESB.SELECTC.UPDATED.ALTER
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 MirrorB. DS5300 systems at each site running Metro MirrorC. DS5100 systems at each site running Global MirrorD. XIV systems at each site running synchronous mirroring
You have a computer that runs Windows Vista. You create a dial－up connection.You need to run a custom script each time you connect by using the dial－up connection.What should you do?() A.AB.BC.CD.D
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. A.connections B.requests C.acknowledgmentsD.datagrams
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. A.path B.window C.response D.process
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 TABLEB、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
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、REFERENCESB、SELECTC、UPDATED、ALTER
A financial customer has three data centers that are four kilometers apart. Their SAP application data needs to be kept synchronized within 10 milliseconds. Which solution satisfies the customer’s recovery time objective（）A、DS8700 systems at each site running Metro MirrorB、DS8700 systems at each site running Global MirrorC、DS5300 systems at each site running Global MirrorD、XIV systems at each site running Remote Mirroring
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 MirrorB、DS5300 systems at each site running Metro MirrorC、DS5100 systems at each site running Global MirrorD、XIV systems at each site running synchronous mirroring
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）A、You cannot roll back this statement.B、All pending transactions are committed.C、All views based on the DEPT table are deleted.D、All indexes based on the DEPT table are dropped.E、All data in the table is deleted, and the table structure is also deleted.F、All data in the table is deleted, but the structure of the table is retained.G、All synonyms based on the DEPT table are deleted.
Evaluate the following statements： CREATE TABLE purchase_orders （po_id NUMBER（4）， po_date TIMESTAMP， supplier_id NUMBER（6）， po_total NUMBER（8，2）， CONSTRAINT order_pk PRIMARY KEY（po_id）） PARTITION BY RANGE（po_date） （PARTITION Q1 VALUES LESS THAN （TO_DATE（？1-apr-2007？d-mon-yyyy？）， PARTITION Q2 VALUES LESS THAN （TO_DATE（？1-jul-2007？d-mon-yyyy？）， PARTITION Q3 VALUES LESS THAN（TO_DATE（？1-oct - 2007？d-mon-yyyy？）， PARTITION Q4 VALUES LESS THAN （TO_DATE（？1-jan-2008？d-mon-yyyy？））； CREATE TABLE purchase_order_items （po_id NUMBER（4） NOT NULL， product_id NUMBER（6） NOT NULL， unit_price NUMBER（8，2）， quantity NUMBER（8）， CONSTRAINT po_items_fk FOREIGN KEY （po_id） REFERENCES purchase_orders（po_id）） PARTITION BY REFERENCE（po_items_fk）； What are the two consequences of the above statements？（）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.
You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）A、 Create an INSERT trigger to assign the default value to each item in the table. B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. C、 Create an UPDATE trigger to update the default value for each new item in the table. D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）A、Ensure that the Close method is called on each connection object after it has finishedexecuting.B、Ensure that each connection object is left open after it has finished executing.C、Increase the Max Pool Size value inside the connection string.D、Increase the Min Pool Size value inside the connection string.E、Increase the Connection Lifetime value inside the connection string.F、Increase the value of the ConnectionTimeout property of the SqlConnection object.
You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Some client computers run Windows XP Professional, and the rest run Windows NT 4.0 Workstation. TestKing includes departments for accounting, design, marketing, and sales. Each department has a corresponding organizational unit (OU). A member server named Testking1 can be accessed only by user accounts in the Accounting, Design, Marketing, and Sales OUs. You install Terminal Server on Testking1. Then you install four new applications on Testking1. Each application is intended for users in only one of the four departments. You need to ensure that each application can be accessed only by users in the appropriate department. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?（）A、In the Default Policy Group Policy object (GPO), configure the Start program on connection policy to be the program path and file name of the application to start when the user logs on.B、In each OU, set the Environment property for each user to the program path and file name of the application that corresponds to the OU.C、On Testking1, select the RDP-Tcp connection properties. Set the program path and file name of the application to start when the user logs on.D、Create one Group Policy object (GPO) for each department. Link each GPO to the corresponding OU. For each GPO, configure the Start program on connection policy to run the application that corresponds to the appropriate department.
You are designing an application that will use Windows Azure Table storage to store millions of data points each day. The application must retain each day’s data for only one week. You need to recommend an approach for minimizing storage transactions. What should you recommend？（）A、 Use a separate table for each date. Delete eachtable when it is one week old.B、 Use a separate table for each week. Delete each table when it is one week old.C、 Use a single table， partitioned by date. Use Entity Group Transactions to delete data when it is one week old.D、 Use a single table， partitioned by week. Use Entity Group Transactions to delete data when it is one week old.
单选题You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Some client computers run Windows XP Professional, and the rest run Windows NT 4.0 Workstation. TestKing includes departments for accounting, design, marketing, and sales. Each department has a corresponding organizational unit (OU). A member server named Testking1 can be accessed only by user accounts in the Accounting, Design, Marketing, and Sales OUs. You install Terminal Server on Testking1. Then you install four new applications on Testking1. Each application is intended for users in only one of the four departments. You need to ensure that each application can be accessed only by users in the appropriate department. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?（）AIn the Default Policy Group Policy object (GPO), configure the Start program on connection policy to be the program path and file name of the application to start when the user logs on.BIn each OU, set the Environment property for each user to the program path and file name of the application that corresponds to the OU.COn Testking1, select the RDP-Tcp connection properties. Set the program path and file name of the application to start when the user logs on.DCreate one Group Policy object (GPO) for each department. Link each GPO to the corresponding OU. For each GPO, configure the Start program on connection policy to run the application that corresponds to the appropriate department.
单选题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?（）ADS8700 systems at each site running Metro MirrorBDS5300 systems at each site running Metro MirrorCDS5100 systems at each site running Global MirrorDXIV systems at each site running synchronous mirroring
单选题Consider this syntax： MERGE INTO t1 USING t2 ON （join predicate）….. What does the MERGE syntax do？（）AIt performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. BIt creates a natural join of tables T1 and T2 for all columns that have the same name. CIt creates a Cartesian product of table T1 and table T2 for all columns that have the same name. DFor each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
单选题You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）A Create an INSERT trigger to assign the default value to each item in the table. B Create a CHECK constraint to validate the data and to assign the default value to each item in the table. C Create an UPDATE trigger to update the default value for each new item in the table. D Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
单选题36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）ARows BTotals CColumns DCells EData
单选题A financial customer has three data centers that are four kilometers apart. Their SAP application data needs to be kept synchronized within 10 milliseconds. Which solution satisfies the customer’s recovery time objective（）ADS8700 systems at each site running Metro MirrorBDS8700 systems at each site running Global MirrorCDS5300 systems at each site running Global MirrorDXIV systems at each site running Remote Mirroring
单选题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?（）AREFERENCESBSELECTCUPDATEDALTER