当前位置: 网站首页 >
OCP认证
- 【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...[详细]
- 【2019年8月版本】Oracle OCP认证 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. ...[详细]
- 【2019年8月版本】Oracle OCP认证 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...[详细]
