当前位置: 网站首页 >
OCP认证
- 【2019年8月版本】Oracle OCP认证 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...[详细]
- 【2019年8月版本】Oracle OCP认证 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...[详细]
- 【2019年8月版本】Oracle OCP认证 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...[详细]
- 【2019年8月版本】Oracle OCP认证 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 ...[详细]
- 【2019年8月版本】Oracle OCP认证 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...[详细]
- 【2019年8月版本】Oracle OCP认证 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....[详细]
- 【2019年8月版本】Oracle OCP认证 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...[详细]
- 【2019年8月版本】Oracle OCP认证 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"[详细]
- 【2019年8月版本】Oracle OCP认证 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 ...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-30Which two statements are true atout the ORD_ITEMS table and the ORD_SEQ sequence? A) Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ. B) Colunn OR...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-29Which two commands execute successfully? A) GRANT CREATE SEQUENCE TO manager, emp; B) GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION: C) GRANT CREATE TABLE, emp TO manager; ...[详细]
