- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-41The 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 column,referencing the primary key of the ORDERS table. ...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-40Which two statements are true about single row functions? A) CONCAT : can be used to combine any number of values B) MOD : returns the quotient of a division operation C) CEIL : can be used fo...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-39Which two WHERE condtions give the same resut? A) WHERE borrowed_date = SYSDATE AND (transaction_type= 'RM' OR member_id IN ('A101','A102' ) ); B) WHERE borrowed_date = SYSDATE AND transaction...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-38Which two queries give the required output? A) SELECT SYSDATE - TO_DATE (' 01-JANUARY-2019' ) FROM DUAL; B) SELECT TO_DATE (SYSDATE, ' DD/MONTH/YYYY' ) - '01/JANUARY/2019' FROM DUAL; C) SELECT...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-37Which query retrieves the number of products with a null list price? A) SELECT (COUNT(list_price) FERM Product_intormation WHERE list_price=NULL; B) SELECT Count(nvl( list_price,0) )FROM pruduc...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-36Which three statements are true about sequences in a single instance Orade database? A) A sequence's unallocated cached values are lost if the instance shuts down. B) Two or more tables cannot ...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-35Which two statenents are tue about the COUNT function? A) It can only be used for NUMBER data types. B) COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing dupicates a...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-34Choose two. Which two statements are true about the results of using the INTERSECT operator in compound queres? A) Reversing the order of the intersected tables can sometimes affect the output....[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-33Choose 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 used. D) It must be an equijoin. E) The qu...[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-32Identify three ORDER BY clauses, any one of which can complete the query successfully. A) ORDERBY 2, 1 B) ORDER BY "CUST_NO" C) ORDER BY 2,cust_id D) ORDER BY CUST_NO E) ORDER BY "Last Name"[詳細(xì)]
- 【2019年8月版本】Oracle OCP認(rèn)證 071考試原題-31You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result? A) WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,' ') +1 ...[詳細(xì)]
PostgreSQL入門到精通 100+ 個(gè)學(xué)習(xí)資料
- 冉乃綱-老師CUUG金牌講師
- 冉老師 CUUG金牌講師 Oracle及RedHat高級(jí)講師、Unix/Linux 資深專家...[詳細(xì)了解老師]
- 陳衛(wèi)星-老師CUUG金牌講師
- 陳老師 CUUG金牌講師 精通Oracle管理、備份恢復(fù)、性能優(yōu)化 11年Ora...[詳細(xì)了解老師]
