- 【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 ...[詳細]
