- 【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...[详细]
