摘要：Choose two. You execute this command: TRUNCATE TABLE depts; Which two are true? A) It drops any triggers defined on the table. B) It retains the index 阅读全文

摘要：Choose two Examine this SQL statement: DELETE FROM employees e WHERE EXISTS (SELECT 'dummy' FROM emp_history WHERE employee_id = e.employee_id) Which 阅读全文

摘要：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 阅读全文

摘要：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 quo 阅读全文

摘要：Choose two Exanine the desatption of the BOOKS_TRANSACTIONS table Name Null? Type TRANSACTION_ID NOT NULL VARCHAR2(6) TRANSACTION_TYPE VARCHAR2(3) BOR 阅读全文