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

相似题目

• 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.

  查看最佳答案

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

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

  查看最佳答案

• What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）

  A . It fails with the ORA-665610 Invalid DDL statement on history-tracked message B . The rows in the table are truncated without being archived. C . The rows in the table are archived, and then truncated. D . The rows in both the table and the archive are truncated.

  查看最佳答案

• What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）

  A . A check constraint on the EMPLOYEE table B . A unique constraint on the EMPLOYEE table WORKDEPT column C . A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table D . A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

  查看最佳答案

• 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

  查看最佳答案

• Before welding in a tank that has carried petroleum products，the tank must be certified by （）.

  A . the Coast Guard B . the ABS C . the shipyard fire department D . a certified marine chemist

  查看最佳答案

• 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

  查看最佳答案

• The CUSTOMERS table has these columns: https://assets.asklib.com/images/image2/2018080116294948484.jpg The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? （）

  A . SELECT TOTAL(*) FROM customers; B . SELECT COUNT(*) FROM customers; C . SELECT TOTAL(customer_id) FROM customers; D . SELECT COUNT(customer_id) FROM customers; E . SELECT COUNT(customers) FROM customers; F . SELECT TOTAL(customer_name) FROM customer

  查看最佳答案

• Which of the petroleum products listed has the lowest flash point?（）

  A . Hydraulic oil B . Lubricating oil C . Diesel oil D . Refrigeration oil

  查看最佳答案

• The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）

  A . CREATE SYNONYM ord FOR orders; This command is issued by OE  B . CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE  C . CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator  D . CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator&e

  查看最佳答案

• Evaluate the following SQL statement used to create the PRODUCTS table: https://assets.asklib.com/images/image2/2018080210365762118.jpg Which statement is true regarding this command?（）

  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.

  查看最佳答案

• 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 bi

  查看最佳答案

• 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

  查看最佳答案

• Evaluate the CREATE TABLE statement：   CREATE TABLE products   （product_id NUMBER （6）  CONSTRAINT prod_id_pk PRIMARY KEY，  product_name VARCHAR2 （15））；   Which statement is true regarding the PROD_ID_PK constraint？（）

  A .  It would be created only if a unique index is manually created first. B .  It would be created and would use an automatically created unique index. C .  It would be created and would use an automatically created nonunique index. D .  It would be created and remains in a disabled state because no index is specified in the command.

  查看最佳答案

• You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

  A . All data along with the table structure is deleted  B . The pending transaction in the session is committed  C . All indexes on the table will remain but they are invalidated  D . All views and synonyms will remain but they are invalidated  E . All data in the table are deleted but the table structure will remai

  查看最佳答案

• User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

  A . null lock on the row being updated B . null lock on the table containing the row C . ROW SHARE lock for the row being updated D . ROW EXCLUSIVE lock for the row being updated E . shared row-exclusive lock for the row being updated F . a shareable table lock for the table containing the row G . exclusive table-level lock for the table containing the row

  查看最佳答案

• The CUSTOMERS table has these columns: https://assets.asklib.com/images/image2/2018080116181325145.jpg Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）

  A . SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL; B . SELECT customer_id, customer_name FROM customers WHERE postal_code = '________'; C . SELECT customer_id, customer_name FROM customers WHERE postal_code IS NULL; D . SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL; E . SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL

  查看最佳答案

• How we pack the products has a significant impact_______the cost of logistics.

  查看最佳答案

• Jerry has great confidence in the products of his company.

  查看最佳答案

• The writer wrote the text because he has noticed that good table manners______.

  A．are completely forgotten by young people B．are brought back to people' s attention C．are used when making professional decisions D．are difficult to learn and practise

  查看最佳答案

• Since the early nineties, the trend in most businesses has been toward on-demand, always-available products and services that suit the customer’s _________ rather than the company’s.

  A. benefit B. availability C. suitability D. convenience

  查看最佳答案

• The high quality of our products, which has won popular approval, could not be acquired ______ the same prices ______ elsewhere.

  查看最佳答案

• Since the early nineties, the trend in most businesses has been toward on-demand, always- available products and services that suit the customer's_______rather than the company's.

  A．benefit B．availability C．suitability D．covenience

  查看最佳答案

• <table><tbody><tr><td>The medicine has a good effect to me</td></tr></tbody></table>

  查看最佳答案