- 【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...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-6choose three Which three statements are true about indexes and their administration in an Orade database? A) An INVISIBLE index is not maintained when Data Manipulation Language (DML) is perfor...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-5choose the best answer The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose COST_LAST_MANE values are Anderson and Ausson. Which query produces o...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-4Which two statements are true? A) PRODUCT_ID can be assigned the PEIMARY KEY constraint. B) EXPIRY_DATE cannot be used in arithmetic expressions. C) EXPIRY_DATE contains the SYSDATE by defalt ...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-3choose two The CUSTOMERS table has a CUST_CREDT_LIMIT column of date type number. Which two queries execute successtully? A) SELECT TO_CHAR(NVL(cust_credit_limit * .15,'Not Available')) FROM c...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-2choose three Which three are true about the CREATE TABLE command? A) It can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint. B) The owner of th...[详细]
- 【2019年8月版本】OCP 071认证考试最新版本的考试原题-1Which query is valid? A) SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id,join_date; B) SELECT depe_id,join_date, SUM(salary) FROM employees GROUP BY dept_id: C) SELECT d...[详细]
- 【12c OCP认证】2019年度OCP最新考试题库-071.90题90、Which statements are true? (Choose all that apply.) A. The data dictionary is created and maintained by the database administrator. B. The data dictionary views consists of joins of diction...[详细]
- 【12c OCP认证】2019年度OCP最新考试题库-071.89题89、Which three statements are true regarding group functions? (Choose three.) A. They can be used on columns or expressions. B. They can be passed as an argument to another group function. C....[详细]
- 【12c OCP认证】2019年度OCP最新考试题库-071.88题88、Evaluate the following SELECTstatement and view the exhibit to examine its output: SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status, FROM...[详细]
