当前位置: 网站首页 >
OCP认证
- 【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...[详细]
- Oracle 11g OCP认证052考试题库（76）-CUUG内部学员版Which two are true about UNDO data ? A)Inactive UNDO cannot be overwritten until the elapsed time since becoming inactive exceeds UNDO_RETENTION. B)Active UNDO can never be overwritten. C)Act...[详细]
- Oracle 11g OCP认证052考试题库（75）-CUUG内部学员版Which two are true about UNDO segments and UNDO tablespaces in the same database and instance ? A)Multiple transactions may share a single UNDO segment. B)A database can have multiple active UN...[详细]
- Oracle 11g OCP认证052考试题库（74）-CUUG内部学员版Which three are true about UNDO segments and UNDO tablespaces in the same database and instance ? A)A database can have multiple UNDO tablespaces. B)UNDO segments are automatically dropped shor...[详细]
- Oracle 11g OCP认证052考试题库（73）-CUUG内部学员版Which four are true about UNDO ? A)Guaranteed UNDO retention prevents inactive and expired undo from being deleted. B)DML statements generate UNDO. C)Active UNDO is never deleted. D)Inactive ...[详细]
- Oracle 11g OCP认证052考试题库（72）-CUUG内部学员版Which three are true about UNDO data? A)It is used to rewind a database by using FLASHBACK DATABASE. B)It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFORE DROP. C)It is ...[详细]
