当前位置: 网站首页 >
OCP认证
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-17Which two statements are true? A) An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID,which is the foreign key linked to the STUDENTS and PROJECTS entities. B...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-16Which two clauses are required for this command to execute successfully? A) the DEFAULT DIRECTORY clause B) the REJECT LIMIT clause C) the LOCATION clause D) the ACCESS PARAMETERS clause E) ...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-15Which three queres use valid expressions? A) SELECT produet_id, unit_pricer, 5 "Discount",unit_price+purcharge-discount FROM products; B) SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-14Which two are true? A) The subquery is executed before the UPDATE statement is executed. B) All existing rows in the ORDERS table are updated. C) The subquery is executed for every updated row...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-13Choose the best answer. Examine this query: SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL; What is the result? A) 16 B) 160 C) 150 D) 200 E) 100[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-12Choone two Which three statements are true about dropping and unused columns in an Oracle database? A) A primary key column referenced by another column as a foreign key can be dropped if using...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-11Choose two. Which two statements are true about a self join? A) The join key column must have an index. B) It can be a left outer join. C) It must be a full outer join. D) It can be an inner...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-10Choose two Which two statements are true about Oracle synonyms? A) A synonym can have a synonym. B) All private synonym names must be unique in the database. C) Any user can create a PUBLIC s...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-9Choose three Which three statements are true about views in an Orade batabase? A) A SELECT statement cannot contain a where clause when querying a view contaning a WHERE clause in its defining ...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-8Choose the best answer The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE You want to display the date of the first Monday after the completion of s...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-7Choose three Which three are true about granting object privileges on tables, views, and sequences? A) UPDATE can be granted only on tables and views. B) DELETE can be granted on tables, views...[详细]
