摘要:
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 阅读全文
摘要:
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 阅读全文
摘要:
Choose the best answer Examine the description of the PRODUCT_INFORMATION table: Name NULL? Type PROD_ID NOT NULL NUMBER(2) PROD_NANE VARCRAR2 (10) LI 阅读全文