- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-19Choose two The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOTCE_DATE column of data type DATE NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conv...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-18Choose two Which two statements are true about the WHERE and HAVING clouses in a SELECT statement? A) The WHERE clause can be used to exclude rows after divding them into groups B) WHERE and H...[详细]
- 【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 ...[详细]
