cnblogs_5359

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

摘要： Choose three Which three statements are true about sequences in a single instance Orade database? A) A sequence's unallocated cached values are lost i 阅读全文

摘要： choose two Which two statenents are tue about the COUNT function? A) It can only be used for NUMBER data types. B) COUNT (DISTINCT inv_amt) returns th 阅读全文

摘要： Choose two. Which two statements are true about the results of using the INTERSECT operator in compound queres? A) Reversing the order of the intersec 阅读全文