cnblogs_5359

摘要： Choose three. Which three statements are true about a self join? A) It must be an inner join. B) It can be an outer join. C) The ON clause must be use 阅读全文

摘要： choose three Examine this SQL statement: SELECT cust_id, cus_ last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, 阅读全文

摘要： Choose two Examine the data in the CUST NAME column of the CUSTOMERS table: CUST_NAME Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikk 阅读全文

摘要： choose two Evalute these conmands which execate sucestully CREATE SEQUENCE ord_seq INCREMENT BY 1 START WITH 1 MAXVALUE 100000 CYCLE CACHE 5000; Which 阅读全文

摘要： choose two. ·MANAGER is an existing role with no privileges or roles. ·EMP is an existing role containing the CREATE TABLE privilege. ·EMPLOYEES is an 阅读全文

摘要： choose two The ORDERS table has a column ORDER_DATE of date type DATE The default display format for a date is DD-MON-RR Which two WHERE conditions de 阅读全文

摘要： Choose two. Which two statements are true about the DUAL table? A) It can display multiple rows and columns. B) It can be accessed only by the SYS use 阅读全文

摘要： Choose three Which three actions can you perfom only with system privileges? A) Truncate a table in another schema. B) Access flat files via a databas 阅读全文

摘要： Choose three. Which three statements are true about defining relations between tables in a relatonal database? A) Foreign key columns allow null value 阅读全文

摘要： Choose three. Which three statements are true about GLOBAL TEMPORARY TABLES? A) A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM. B) A GLOBAL TEMPO 阅读全文