Choose three Which three statements are true about GLOBAL TEMPORARY TABLES? A) GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select o ...

Choose three Which three are true about dropping columns from a table? A) A column can be removed only if it contains no data. B) A column drop is implicitly committed C) A column that is referenced b ...

Choose the best answer You have been asked to create a table for a banking application. One of the columns must meet three requirements: 1) Be stored in a format supporting date arithmetic without usi ...

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 ...