- 【2019年8月版本】Oracle OCP认证 071考试原题-52Which two statements are true about INTERVAL data types A) INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. B) The value in an INTERVAL DAY TO SECOND colum...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-51Which two statements are true about conditional INSERT ALL? A) Each row returned by the subquery can be inserted into only a single target table. B) It cannot have an ELSE clause. C) The total...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-50Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS A) SYSDATE CAN be used in expressions only if the default date format ...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-49What is true about non-equijoin statement performance? A) The Orade join syntax performs better than the SQL:1999 compliant ANSI join syntax. B) Table aliases can improve performance. C) The B...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-48Which two are true about executing statements? A) INSERT INTO rate_list VALUES (-.9) inserts the value as -.9. B) INSERT INTO rate_list VALUES (0.999) produces an eror. C) INSERT INTO rate_lis...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-47which three statements are true about GLOBAL TEMPORARY TABLES? A)A DELETE comand on GLOBAL TEMPORARY TABLE cannot be rolled back B) GLOBAL TEMPORARY TABLE rows inserted by a session are availab...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-46Which three are true about dropping columns from a table? A) A column can be removed only if it contains no data. B) A column drop is implidtly committed C) A column that is referenced by anot...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-45You have been tasked to create a table for a banking application. One of the columns must meet three requirements: 1) Be stored in a format supporting date arithmetic without using conversion f...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-44The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two querdes execute successfully? A) SELECT COUNT(prod_id) FROM sales WHERE quantity_sold55000 GROUP BY prod_id;...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-43Which two are true? A) It drops any triggers defined on the table. B) It retains the indexes defined on the table. C) It retains the integrity constraints defined on the table. D) A ROLLBACR ...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-42Which two are true? A) The subquery is executed for every row in the EMPLOYEES table. B) The subquery is not a correlated subquery. C) The subquery is executed before the DELETE statement is e...[详细]
