当前位置: 网站首页 >
OCP认证
- 【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题）[详细]
- 【OCP 071】最新OCP 12c题库考试原题（071-76题）76、View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables. The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the foll...[详细]
- 【OCP 071】最新OCP 12c题库考试原题（071-75题）Which statements are correct regarding indexes? (Choose all that apply.) A. A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to creates a unique index. B. I...[详细]
