View the exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement: SQL> SELECT prod_id FROM costs WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_cost < ALL (SELECT MAX(promo_cost) FROM promotions GROUP BY…
View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables. You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table…
Which statements are true? (Choose all that apply.) A. The data dictionary is created and maintained by the database administrator. B. The data dictionary views consists of joins of dictionary base tables and user-defined tables. C. The usernames of all…
Which three statements are true regarding group functions? (Choose three.) A. They can be used on columns or expressions. B. They can be passed as an argument to another group function. C. They can be used only with a SQL…
Evaluate the following SELECT statement and view the exhibit to examine its output: SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status, FROM user_constraints WHERE table_name = ‘ORDERS’; CONSTRAINT_NAME CON SEARCH_CONDITI ON R_CONSTRAINT_NAME DELETE_RULE STATUS ORDER_DATE_NN C "ORDER_DATE" IS NOT NULL ENABLED…
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 tables, which references the PRODUCTS table. Similarly, the CUST_ID and TIME_ID columns are also foreign…
Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME -—————— Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikilineni Julia Nayer You need to display customers’ second names where the second name starts with "Mc" or…
Which statement is true regarding the INTERSECT operator? A. The names of columns in all SELECT statements must be identical. B. It ignores NULL values. C. Reversing the order of the intersected tables alters the result. D. The number of…
Examine the following query: SQL> SELECT prod_id, amount_sold FROM sales ORDER BY amount_sold FETCH FIRST 5 PERCENT ROWS ONLY; What is the output of this query? A. It displays 5 percent of the products with the highest amount sold. B.…
The first DROP operation is performed on PRODUCTS table using the following command: DROP TABLE products PURGE; Then you performed the FLASHBACK operation by using the following command: FLASHBACK TABLE products TO BEFORE DROP; Which statement describes the outcome of…