当前位置: 网站首页 >
OCP认证
- 【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...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-52Which two statements are true about INTERVAL data types A) INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. B) The value in an INTERVAL DAY TO SECOND colum...[详细]
- 【2019年8月版本】Oracle OCP认证 071考试原题-51Which two statements are true about conditional INSERT ALL? A) Each row returned by the subquery can be inserted into only a single target table. B) It cannot have an ELSE clause. C) The total...[详细]
