- 【2020年8月】Oracle OCP 071考试新题(-14题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-14题)CUUG内部题库Choose the best answer.Examine this statement, which executes successfully:SELECT d.department_name, ROUND (AVG (NULLIF (e.salary,0))) AS avg...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-13题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-13题)CUUG内部题库Choose the best answer.Examine this statement which returns the name of each employee and their manager:SELECT e.last_name AS emp, m.1ast_na...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-12题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-12题)CUUG内部题库Choose the best answer.Examine these statements:CREATE TABLE alter_test (c1 VARCHAR2 (10),c2 NUMBER(10)) ;INSERT INTO alter_test VALUES ('123...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-11题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-11题)CUUG内部题库Choose two.Which two are true about transactions in the Oracle Database?A) An uncommitted transaction is automatically committed when the use...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-10题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-10题)CUUG内部题库Choose two.Examine the description of the PRODUCTS table which contains data:Name Null? Type----------------------------------...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-9题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-9题)CUUG内部题库Choose two.Examine the description of the EMPLOYEES table:Name Null? Type--------------------------------------------------------...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-8题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-8题)CUUG内部题库Choose two.Which two statements are true about CURRENT_TIMESTAMP?A) The time is in the time zone of DBTIMEZONE.B) It always returns the same v...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-7题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-7题)CUUG内部题库Choose two.Examine the description of the CUSTOMERS table:Name Null? Type--------------------------------------------------...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-6题)CUUG内部题库【2020年8月】Oracle OCP 071考试新题(-6题)CUUG内部题库Choose the best answer.Examine this statement:SELECT 1 AS id, 'John' AS first_name, NULL AS commissionFROM DUALINTERSECTSELECT 1, 'John' ,NULL...[详细]
- 【2020年8月】Oracle OCP 071考试新题(-5题)CUUG内部题库Choose two.Which two are SQL features?A) providing graphical capabilitiesB) providing variable definition capabilitiesC) providing database transaction controlD) processing sets of dataE) providi...[详细]
- 【2020年8月】OCP 071考试新题(-4题)CUUG内部题库【2020年8月】OCP 071考试新题(-4题)CUUG内部题库Choose two.Which two are true about virtual columns?A) They can be referenced in the WHERE clause of an UPDATE or DELETE statement.B) They cannot ha...[详细]
