Which SQL statement would you execute to accomplish the task?

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 theCITY column of the LOCATIONS table for each department.Which SQL statement would you execute to accomplish the task? A. UPDATE dept d […]

Read More

What would be the outcome of the above SQL statement?

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement:SQL> SELECT prod_id FROM costsWHERE promo_id IN (SELECT promo_id FROM promotionsWHERE promo_cost < ALL(SELECT MAX(promo_cost) FROM promotionsGROUP BY (promo_end_datepromo_begin_date)));What would be the outcome of the above SQL statement? A. It displays prod IDs in the promo with the […]

Read More

Which statements are true?

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 the users including the database administrators are stored in the data dictionary. D. The USER_CONS_COLUMNS […]

Read More

Which three statements are true regarding group functions?

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 statement that has the GROUP BY clause. D. They can be used on only one […]

Read More

Which two statements are true about the output?

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_constraintsWHERE table_name = ‘ORDERS’;CONSTRAINT_NAME CON SEARCH_CONDITIONR_CONSTRAINT_NAME DELETE_RULE STATUSORDER_DATE_NN C “ORDER_DATE” ISNOT NULLENABLEDORDER_CUSTOMER_ID_NNC “CUSTOMER_ID” ISNOT NULLENABLEDORDER_MODE_LOV C order _mode in(‘direct’,‘online’)ENABLEDORDER TOTAL MIN C order total >= 0 ENABLEDORDER PK P ENABLEDORDERS CUSTOMER ID R CUSTOMERS ID SET NULL […]

Read More

Which statement is true regarding the above command?

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 keys in the SALES table referencing theCUSTOMERS and TIMES tables, respectively.Evaluate the following CREATE TABLE command:CREATE […]

Read More

Which query gives the required output?

Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAME——————-Renske LadwigJason MallinSamuel McCainAllan MCEwenIrene MikilineniJulia NayerYou need to display customers’ second names where the second name starts with “Mc” or “MC”.Which query gives the required output? A. SELECT SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1) FROM customers WHERE SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1) LIKE […]

Read More

Which statement describes the outcome of the FLASHBACK command?

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 the FLASHBACK command? A. It recovers only the table structure. B. It recovers the table structure, data, and the […]

Read More