Evaluate the following SQL statement SQL>SELECT promo_id, prom _category FROM promotionsWHERE promo_category=’Internet’ ORDER BY promo_id UNION SELECT promo_id, promo_category FROM Pomotions WHERE p ...

You execute these commands: SQL>DEFINE hiredate = ’01-APR -2011’; SQL>SELECT employee_id, first_name, salary FROM employees WHERE hire date > &hiredate AND manager_id >&mgr_id; For which substituti ...

Which two statements are true? (Choose two.) A) The USER SYNONYMS view can provide information about private synonyms. B) The user SYSTEM owns all the base tables and user-accessible views of the data ...

View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the SALES table.Which references the PRODUCTS table. Similarly, ...

Which statement is true regarding the SESSION_PRIVS dictionary view? A) It contains the object privileges granted to other users by the current user session. В) It contains the system privileges gran ...

View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER TOTAL have the default values'direct “and respectively. Which two INSERT statements are valid? (C ...

Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INVENTORIEStables. You have a requirement from the supplies department to give a list containing PRODUCT _ID,SUPPLIER ID, and ...

Which statement is true about the INTERSECT operator used in compound queries? A) It processes NULLS in the selected columns. B) INTERSECT is of lower precedence than UNION or UNION ALL. C) It ignores ...