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