- 【2020年8月】OCP 071考試新題(-3題)CUUG內部題庫【2020年8月】OCP 071考試新題(-3題)CUUG內部題庫Choose the best answer.Examine the description of the CUSTOMERS table:Name Null? Type-------------------------------------------...[詳細]
- 【2020年8月】OCP 071考試新題(-2題)CUUG內部題庫【2020年8月】OCP 071考試新題(-2題)CUUG內部題庫Choose two.Which two are true about unused columns?A) You can query the data dictionary to see the names of unused columns.B) CASCADE CONSTRAINTS mus...[詳細]
- 【2020年8月】OCP 071考試新題(-1)CUUG內部題庫【2020年8月】OCP 071考試新題(-1)CUUG內部考試Choose two.Examine this query:SELECT * FROM bricks , colors;Which two statements are true?A) You can add a WHERE clause with filtering criteria.B) It r...[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-60Choose two Which two are true about the WITH GHANT OPTION clause? A) The grantee can grant the object privilege to any user in the database, with or without including this option B) It can be ...[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-59You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output? A) UNION ALL B) MINUS O) INTERSECT D) SUBTRACT...[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-58A) MERGE INTO new_prices n USING (SELECT * FROM products) p WHEN MATCHED THEN UPDATE SET n.price = p. cost*.01 WHEN NOT MATCHED THEN INSERT (n.prod_id, n.price)...[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-57Which two statements are true? A) The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row. B) The first ROLLBACK command restores the 101 rows that were ...[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-56You want to display detalls of all customers who reside in cities starting with the letter D followed by at least two character Which query can be used? A) SELECT * FROM customers WHERE city = ...[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-55Which two methods should you use to prevent prompting for a hire date value when this query is executed? A) Use the DEFINE command before executing the query. B) Store the query in a script and...[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-54SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3; What is returned upon execution? A) 0 rows B) an error C) 8 rows D) 6 rows E) 1 row F) 3 rows[詳細]
- 【2019年8月版本】Oracle OCP認證 071考試原題-53choose two Which two true about a sql statement using SET openatons such as UNION? A) The data type of each column returned by the second query must be implldtly convertible to the data type of...[詳細]
