The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve

题目

The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）

A、SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;
B、SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;
C、SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;
D、SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;
E、SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Examine the data from the ORDERS and CUSTOMERS table.Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）

参考答案：B

第2题：

In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）

A、if a table is not in a cluster
B、if a table has an active trigger
C、if a table has an encrypted
D、if a table has a column of data type LONG defined on it
E、if a table has a referential integrity constraint defined on it

正确答案:B,C,E

第3题：

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.

参考答案：B, C

第4题：

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table： SQL> FLASHBACK TABLE ORDERS TO SCN 771513； What is the prerequisite to perform Flashback Table？（）

A、 You must configure OMF in your database.
B、 You must enable block change tracking feature in your database.
C、 You must enable ROW MOVEMENT feature on the ORDERS table.
D、 You must use the Flashback Version Query before using the Flashback Table feature.

正确答案:C

第5题：

You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）

A、No flashback is possible to bring back the ITEM table.
B、The ORDERS table is dropped along with the ITEM table.
C、The dependent referential integrity constraints in the ORDERS table are disabled.
D、The dependent referential integrity constraints in the ORDERS table are removed.
E、The table definition of the ITEM table and associated indexes are placed in the recycle bin

正确答案:A,D

第6题：

Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）

A、A CHECK constraint is created on the OID column.
B、A NOT NULL constraint is created on the OID column.
C、The ORDERS table is the only object created in the USERS tablespace.
D、The ORDERS table and a unique index are created in the USERS tablespace.
E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

正确答案:B,D

第7题：

Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?（）

A、 ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders
B、 DROP TRIGGER trg_InsertOrders
C、 DISABLE TRIGGER trg_InsertOrders ON Orders
D、 ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION
E、 sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'

正确答案:A,C

第8题：

The ORDERS table has these columns:ORDER_ID NUMBER(4) NOT NULLCUSTOMER_ID NUMBER(12) NOT NULLORDER_TOTAL NUMBER(10,2)The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）

A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

参考答案：C, E

第9题：

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）

A、disabling the index
B、making the index invisible
C、making the index unusable
D、using the MONITORING USAGE clause for the index

正确答案:B

第10题：

单选题

View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）

The ORDERS_MASTER table would contain the ORDERJDs 1 and 2.

The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 3.

The ORDERS_MASTER table would contain the ORDERJDs 1， 2 and 4.

The ORDERS MASTER table would contain the ORDER IDs 1， 2， 3 and 4.

正确答案： B

解析：暂无解析

The ORDERS table has these colu

题目

相似问题和答案

更多相关问题

相关内容