11 2019 档案
摘要：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
阅读全文
posted @ 2019-11-27 10:09
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-27 09:44
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-25 10:17
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-25 09:39
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-20 09:59
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
阅读全文
posted @ 2019-11-20 09:27
cnblogs_5359
摘要：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,
阅读全文
posted @ 2019-11-19 09:59
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-19 09:16
cnblogs_5359
摘要：choose two Evalute these conmands which execate sucestully CREATE SEQUENCE ord_seq INCREMENT BY 1 START WITH 1 MAXVALUE 100000 CYCLE CACHE 5000; Which
阅读全文
posted @ 2019-11-18 15:01
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-18 14:37
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-14 14:28
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-14 13:27
cnblogs_5359
摘要：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
阅读全文
posted @ 2019-11-11 10:58
cnblogs_5359
摘要：Choose three. Which three statements are true about defining relations between tables in a relatonal database? A) Foreign key columns allow null value
阅读全文
posted @ 2019-11-11 10:10
cnblogs_5359
摘要：Choose three. Which three statements are true about GLOBAL TEMPORARY TABLES? A) A GLOBAL TEMPORARY TABLE cannot have PUBLIC SYNONYM. B) A GLOBAL TEMPO
阅读全文
posted @ 2019-11-06 10:09
cnblogs_5359
摘要：Choose two Which two statements are true about transactions in the Oracle Database serve? A) An uncommitted transaction commits automatically if the u
阅读全文
posted @ 2019-11-06 09:38
cnblogs_5359
摘要：Choose two Which two statements are true about transactions in the Oracle Database serve? A) An uncommitted transaction commits automatically if the u
阅读全文
posted @ 2019-11-04 10:49
cnblogs_5359
摘要：choose two In the PROMOTIONS table, the PROMO_BEGTN_DATE columm is of datatype DATE and the default date format is DD-MON-RR. Which two statements are
阅读全文
posted @ 2019-11-04 10:18
cnblogs_5359
