View the Exhibit and examine the structure of the PORDUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?

View the Exhibit and examine the structure of ORDERS and CUSTOMERStables.

There is only one customer with the cust_last_namecolumn having value Roberts. Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600?

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

次の 2 つのクエリを評価します。

上記 2 つのクエリに関して正しいのはどれですか?

GLOBAL TEMPORARY TABLES に関して正しい 3 つの記述はどれですか?