- 【12c OCP认证】2019年度OCP最新考试题库-071.87题87、View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables. The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS tab...[详细]
- 【12c OCP认证】2019年度OCP最新考试题库-071.86题86、Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME ------------------- Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikilineni Julia Nayer You n...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-85题）85、The following are the steps for a correlated subquery, listed in random order: 1. The WHEREclause of the outer query is evaluated. 2. The candidate row is fetched from the table specified i...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-84题）84、The first DROPoperation is performed on PRODUCTStable using the following command: DROP TABLE products PURGE; Then you performed the FLASHBACKoperation by using the following command: FLAS...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-83题）83、Examine the following query: SQL SELECT prod_id, amount_sold FROM sales ORDER BY amount_sold FETCH FIRST 5 PERCENT ROWS ONLY; What is the output of this query? A. It displays 5 percent ...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-82题）82、Which statement is true regarding the INTERSECToperator? A. The names of columns in all SELECTstatements must be identical. B. It ignores NULLvalues. C. Reversing the order of the intersec...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-81题）81、Which statement is true about an inner join specified in the WHERE clause of a query? A. It must have primary-key and foreign-key constraints defined on the columns used in the join conditio...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-80题）80、View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables. You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order. ...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-79题）79、Which statement is true about transactions? A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction. B. Each Data D...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-78题）78、View the exhibit and examine the structure of the CUSTOMERStable. Which two tasks would require subqueries or joins to be executed in a single statement? A. finding the number of customer...[详细]
- 【OCP-12c】2019年OCP认证考试原题解析（071-77题）【OCP-12c】2019年OCP认证考试原题解析（071-77题）[详细]
