题目内容（请给出正确答案）

[主观题]

The PRODUCTS table has these columns:PRODUCT_ID NUMBER（4)PRODUCT_NAME VARCHAR2（45)PRICE NU

The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement？（）

A. The results are not sorted.

B. The results are sorted numerically.

C. The results are sorted alphabetically.

D. The results are sorted numerically and then alphabetically.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“The PRODUCTS table has these c…”相关的问题

第1题

We invite your attention to our other products such as tablecloth and table napkins, details of ____

A.A.that, receive

B.B.which, receiving

C.C.what, receive

D.D.what, receiving

点击查看答案

第2题

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action？（）

A. All the related indexes and views are automatically dropped

B. The flashback drop feature can recover only the table structure

C. Only the related indexes are dropped whereas views are invalidated

D. The flashback drop feature can recover both the table structure and its data

点击查看答案

第3题

You execute the following PL/SQL:Which two statements are true？（）

A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE ＞ 10000 is accessed.

B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE ＞ 10000 is accessed.

C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

点击查看答案

第4题

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action？（）（Choose two)

A. All the related indexes and views are automatically dropped

B. The flashback drop feature can recover only the table structure

C. Only the related indexes are dropped whereas views are invalidated

D. The flashback drop feature can recover both the table structure and its data

点击查看答案

第5题

Examine the SQL statement that creates ORDERS table:CREATE TABLE orders （SER_NO NUMBER UNI

Examine the SQL statement that creates ORDERS table:CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN (‘CREDIT‘, ‘CASH‘)), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));For which columns would an index be automatically created when you execute the above SQL statement？（）

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. composite index on ORDER_ID and ORDER_DATE

点击查看答案

第6题

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders（SER_NO NUMBER UN

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders(SER_NO NUMBER UNIQUE,ORDER_ID NUMBER,ORDER_DATE DATE NOT NULLSTATUS VARCHARD2(10)CHECK (status IN (‘CREDIT‘,‘CASH‘)),PROD_ID_NUMBERREFERENCES PRODUCTS(PRODUCT_ID),ORD_TOTAL NUMBER,PRIMARY KEY (order id, order date));For which columns would an index be automatically created when you execute the aboveSQL statement？（）

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. Composite index on ORDER_ID and ORDER_DATE

点击查看答案

第7题

Examine the following command:CREATE TABLE （prod_id number（4),Prod_name varchar2 （20),Cate

Examine the following command:CREATE TABLE (prod_id number(4),Prod_name varchar2 (20),Category_id number(30),Quantity_on_hand number (3) INVISIBLE);Which three statements are true about using an invisible column in the PRODUCTS table？（）

A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.

B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.

C. Referential integrity constraint cannot be set on the invisible column.

D. The invisible column cannot be made visible and can only be marked as unused.

E. A primary key constraint can be added on the invisible column.

点击查看答案

第8题

Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command？（）

Evaluate the following SQL statement used to creat

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

点击查看答案

第9题

A manufacturing company which produces a range of products has developed a budget for the

life-cycle of a new product, P. The information in the following table relates exclusively to product P:

A manufacturing company which produces a range of

The company’s total fixed production overheads are budgeted to be $72 million each year and total machine hours are budgeted to be 96 million hours. The company absorbs overheads on a machine hour basis.

What is the budgeted life-cycle cost per unit for product P？

A.$24·40

B.$25·73

C.$27·40

D.$22·73

点击查看答案

第10题

启用表格命令，可通过在命令行输入（）方式打开命令。

A.TABLE

B.circle

C.T

D.H