Choose two The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries execute successfully? A) SELECT COUNT(prod_id) FROM sales WHERE quantity_sold>55000 GROUP BY pro ...

Choose two. You execute this command: TRUNCATE TABLE dept; Which two are true? A) It drops any triggers defined on the table. B) It retains the indexes defined on the table. C) It retains the integrit ...

Choose two Examine this SQL statement: DELETE FROM employees WHERE EXISTS (SELECT 'dummy' FROM emp_history WHERE employee_id = e.employee_id) Which two are true? A) The subquery is executed for every ...

Choose three The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS ...

Choose two. Which two statements are true about single row functions? A) CONCAT: can be used to combine any number of values B) MOD: returns the quotient of a division operation C) CEIL: can be used ...

Choose two Examine the description of the BOOKS_TRANSACTIONS table Name Null? Type ---------------------------------------------------- ...

Choose two. You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output? A) SELECT SYSDA ...

Choose the best answer Examine the description of the PRODUCT_INFORMATION table: Name NULL? Type --------------------------------------------------------------- ...