Oracle认证考试
The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be a
题目
The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use？ （）
- A、 Pivoting INSERT
- B、 Unconditional INSERT
- C、 Conditional ALL INSERT
- D、 Conditional FIRST INSERT
相似问题和答案
第1题：
听力原文：W: What is function of the sale slip? It is so small that it is not always considered important.
M: It is small, of course, but it contains the details of the card and they also show the details and amount of the sale.
Q: What can we learn from the conversation?
(20)
A．The sales slips are not important.
B．The sales slips show the amount of the sale.
C．The sales slips perform. important functions in the bankcard transactions.
D．The sales slips contain the details of the card.
解析：当女士问男士销售单的功能时，男士答到，它包含了信用卡的详细信息，也能显示出销售金额以及其他详细信息，可见销售单在信用卡交易中发挥着重要作用。
第2题：
Each month the credit cardholder will receive a statement from the bank showing the details of the transactions excluding the total amount outstanding.
A．Right
B．Wrong
C．Doesn't say
解析：从第三段第一句Each month the cardholder receives…together with the total amount outstanding and any minimum amount that needs to be paid．容易得出。
第3题：
It’s a good idea. We’ll discuss the details of ________.
A. its plan
B.our scheme
C.their conspiracy
D.our cooperation
第4题：
B.outstanding
C.creative
D.false
第5题：
______ is not contained in the muster list．
A.the details of how the order to abandon ship is given
B.the details of the general emergency alarm signal，the fire alarm signal and the public address system
C.the substitutes for key persons who may become disabled
D.the various fire sections enclosed by“A”class divisions
第6题：
Please ____those details that you would like to change.
A. select
B. selection
C. selecting
D. selects
第7题：
A.Spare
B.Avoid
C.Obtain
D.Remind
第8题：
You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.
You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.
Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two)
A．Enable the Always read properties from UDL file option in the Connection Properties dialog box.
B．Disable the Always read properties from UDL file option in the Connection Properties dialog box.
C．Delete the .udl files and store connection details in the registry by using system data source names.
D．Delete the .udl files, and store connection details in the registry by using user data source names.
E．Make the .udl files available on a network share.
解析：Explanation:
A: To make the connection information available for the developers we must enable the Always read properties from UDL file option.
E: We provide the developers with access to the .udl file by placing the .udl files in a network share and setting appropriate share and NTFS permissions.
Note: In SQL Server 2000, DTS packages can use Microsoft Data Link (.udl) files to create OLE DB connections and resolve the connections in run time. With this feature we can encapsulate the connection properties from a DTS package into a separate file and can edit the connection string in a .udl file instead of the connection properties in a DTS package in situations where connection information such as the server name, login, or even the OLE DB provider may change.
When specifying a data link connection, we must first specify whether to load an existing .udl file or create a data link to save with DTS Designer. If we want to use a .udl file rather than saving the data link with DTS Designer, we can create one either from Windows Explorer or during the data link configuration process in DTS Designer. We must then click Microsoft Data Link in the Data Source list of the Connection Properties dialog box and check the Always read properties from UDL file check box. In this scenario, the .udl file is already specified.
Incorrect Answers:
B: If we clear the Always read properties from UDL file option in the Connection Properties dialog box, we would have to edit the connection properties through the Data Transformation Services (DTS) package. This would increase administrative effort.
C: We cannot delete the .udl files and instead store the connection details in the registry by using system data source names as the connection details change regularly.
D: We cannot delete the .udl files, and instead store connection details in the registry by using user data source names as the connection details change regularly.
第9题：
For details of these and other lights the larger scale charts and Admiralty Lists should be __.
A.considered
B.consulted
C.concluded
D.Commanded
对于这些和另外的灯标的详细资料，大比例尺海图和英版灯标表应被参考。
第10题：
B.outstanding
C.creative
D. false