- ocp考试
- ocp题库解析：1Z0-051-V9.02-第159题
ocp题库解析：1Z0-051-V9.02-第159题，完整题库请点击这里联系老师咨询了解159. View the Exhibit and examine the structure of the CUSTOMERS table.NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY thathave the same data types and size as the corresponding ...
- ocp题库解析：1Z0-051-V9.02-第158题
ocp题库解析：1Z0-051-V9.02-第158题，完整题库请点击这里联系老师咨询了解158. Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose allthat apply.)A. It locks only the columns specified in the SELECT list.B. It locks the rows that satisfy the cond...
- ocp题库解析：1Z0-051-V9.02-第157题
ocp题库解析：1Z0-051-V9.02-第157题，完整题库请点击这里联系老师咨询了解157. View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.Evaluate the following SQL command:SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limitFROM orders o JOIN cus...
- ocp题库解析：1Z0-051-V9.02-第156题
ocp题库解析：1Z0-051-V9.02-第156题，完整题库请点击这里联系老师咨询了解156. Evaluate the following SQL statement:SQL> SELECT cust_id, cust_last_name "Last Name"FROM customersWHERE country_id = 10UNIONSELECT cust_id CUST_NO, cust_last_nameFROM customersWHERE country_id = 30;Whi...
- ocp题库解析：1Z0-051-V9.02-第155题
ocp题库解析：1Z0-051-V9.02-第155题，完整题库请点击这里联系老师咨询了解155. Evaluate the following SQL statement:SQL> SELECT promo_id, promo_categoryFROM promotionsWHERE promo_category = 'Internet' ORDER BY 2 DESCUNIONSELECT promo_id, promo_categoryFROM promotionsWHERE promo_c...
- ocp题库解析：1Z0-051-V9.02-第154题
ocp题库解析：1Z0-051-V9.02-第154题，完整题库请点击这里联系老师咨询了解154. View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.Evaluate the following SQL statement:SQL>SELECT prod_id FROM productsINTERSECTSELECT prod_id FROM salesMINUSSELECT prod...
- ocp题库解析：1Z0-051-V9.02-第153题
ocp题库解析：1Z0-051-V9.02-第153题，完整题库请点击这里联系老师咨询了解153. View the Exhibits and examine the structures of the PRODUCTS and SALES tables.Which two SQL statements would give the same output? (Choose two.)A. SELECT prod_id FROM productsINTERSECTSELECT prod_id FROM ...
- ocp题库解析：1Z0-051-V9.02-第152题
ocp题库解析：1Z0-051-V9.02-第152题，完整题库请点击这里联系老师咨询了解152. Which statement is true regarding the UNION operator?A. By default, the output is not sorted.B. NULL values are not ignored during duplicate checking.C. Names of all columns must be identical across all S...
- ocp题库解析：1Z0-051-V9.02-第151题
ocp题库解析：1Z0-051-V9.02-第151题，完整题库请点击这里联系老师咨询了解151. View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.The CUSTOMERS table contains the current location of all currently active customers. TheCUST_HISTORY table stores histor...
- ocp题库解析：1Z0-051-V9.02-第150题
ocp题库解析：1Z0-051-V9.02-第150题，完整题库请点击这里联系老师咨询了解150. View the Exhibit and examine the data in the PROMOTIONS table.You need to display all promo categories that do not have 'discount' in their subcategory.Which two SQL statements give the required result? (...
- ocp题库解析：1Z0-051-V9.02-第149题
ocp题库解析：1Z0-051-V9.02-第149题，完整题库请点击这里联系老师咨询了解149. View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.Evaluate the following SQL statement:SQL> SELECT prod_id FROM costsWHERE promo_id IN (SELECT promo_id FROM promotionsWHER...
- ocp题库解析：1Z0-051-V9.02-第148题
ocp题库解析：1Z0-051-V9.02-第148题，完整题库请点击这里联系老师咨询了解148. View the Exhibit and examine the structure of the PRODUCTS tables.You want to generate a report that displays the average list price of product categories where the averagelist price is less than half the...
- ocp题库解析：1Z0-051-V9.02-第147题
ocp题库解析：1Z0-051-V9.02-第147题，完整题库请点击这里联系老师咨询了解147. View the Exhibit and examine the structure of the PROMOTIONS table.Evaluate the following SQL statement:SQL>SELECT promo_name,CASEWHEN promo_cost >=(SELECT AVG(promo_cost)FROM promotionsWHERE promo_...
- ocp题库解析：1Z0-051-V9.02-第146题
ocp题库解析：1Z0-051-V9.02-第146题，完整题库请点击这里联系老师咨询了解146. Evaluate the following SQL statement:SQL> SELECT cust_id, cust_last_nameFROM customersWHERE cust_credit_limit IN(select cust_credit_limitFROM customersWHERE cust_city ='Singapore');Which statement is t...
- ocp题库解析：1Z0-051-V9.02-第145题
ocp题库解析：1Z0-051-V9.02-第145题，完整题库请点击这里联系老师咨询了解145. View the Exhibit and examine the structure of the CUSTOMERS table.You issue the following SQL statement on the CUSTOMERS table to display the customers who are in thesame country as customers with the las...
- ocp题库解析：1Z0-051-V9.02-第144题
ocp题库解析：1Z0-051-V9.02-第144题，完整题库请点击这里联系老师咨询了解144. View the Exhibit and examine the structure of the PRODUCTS table.You want to display the category with the maximum number of items.You issue the following query:SQL>SELECT COUNT(*),prod_category_idFROM...
- ocp题库解析：1Z0-051-V9.02-第143题
ocp题库解析：1Z0-051-V9.02-第143题，完整题库请点击这里联系老师咨询了解143. View the Exhibit and examine the structure of the PROMOTIONS table.You have to generate a report that displays the promo name and start date for all promos that started afterthe last promo in the 'INTERNE...
- ocp题库解析：1Z0-051-V9.02-第142题
ocp题库解析：1Z0-051-V9.02-第142题，完整题库请点击这里联系老师咨询了解142. View the Exhibit and examine the structure of the PRODUCTS table.Evaluate the following query:SQL> SELECT prod_nameFROM productsWHERE prod_id IN (SELECT prod_id FROM productsWHERE prod_list_price =(SEL...
- ocp题库解析：1Z0-051-V9.02-第141题
ocp题库解析：1Z0-051-V9.02-第141题，完整题库请点击这里联系老师咨询了解141. View the Exhibit and examine the structure of CUSTOMERS and GRADES tables.You need to display names and grades of customers who have the highest credit limit.Which two SQL statements would accomplish the ...
- ocp考试题库下载：11g-v9.02-051-140题
ocp考试题库下载：11g-v9.02-051-140题，完整题库请点击这里联系老师咨询了解140. Examine the structure of the PRODUCTS table:name Null TypePROD_ID NOT NULL NUMBER(4)PROD_NAME VARCHAR2(20)PROD_STATUS VARCHAR2(6)QTY_IN_HAND NUMBER(8,2)UNIT_PRICE NUMBER(10,2)You want to display the nam...
- ocp考试题库下载：11g-v9.02-051-139题
ocp考试题库下载：11g-v9.02-051-139题，完整题库请点击这里联系老师咨询了解139. Which three statements are true about multiple-row subqueries? (Choose three.)A. They can contain a subquery within a subquery.B. They can return multiple columns as well as rows.C. They cannot contain ...
- ocp考试题库下载：11g-v9.02-051-138题
ocp考试题库下载：11g-v9.02-051-138题，完整题库请点击这里联系老师咨询了解138. Which statement is true regarding subqueries?A. The LIKE operator cannot be used with single- row subqueries.B. The NOT IN operator is equivalent to IS NULL with single- row subqueries.C. =ANY and =ALL ...
- ocp考试题库下载：11g-v9.02-051-137题
ocp考试题库下载：11g-v9.02-051-137题，完整题库请点击这里联系老师咨询了解137. View the Exhibits and examine PRODUCTS and SALES tables.You issue the following query to display product name and the number of times the product has beensold:SQL>SELECT p.prod_name, i.item_cntFROM (...
- ocp考试题库下载：11g-v9.02-051-136题
ocp考试题库下载：11g-v9.02-051-136题，完整题库请点击这里联系老师咨询了解136. View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks would require subqueries? (Choose two.)A. Display the minimum list price for each product status.B. Display all suppliers...
- ocp考试题库下载：11g-v9.02-051-135题
ocp考试题库下载：11g-v9.02-051-135题，完整题库请点击这里联系老师咨询了解135. Which three statements are true regarding subqueries? (Choose three.)A. Subqueries can contain GROUP BY and ORDER BY clauses. 对，可以包含group by 和order byB. Main query and subquery can get data from ...
- ocp考试题库下载：11g-v9.02-051-134题
ocp考试题库下载：11g-v9.02-051-134题，完整题库请点击这里联系老师咨询了解134. Where can subqueries be used? (Choose all that apply.)A. field names in the SELECT statement 标量子查询B. the FROM clause in the SELECT statement 内联视图C. the HAVING clause in the SELECT statement sel...
- ocp考试题库下载：11g-v9.02-051-133题
ocp考试题库下载：11g-v9.02-051-133题，完整题库请点击这里联系老师咨询了解133. Which two statements are true regarding subqueries? (Choose two.)A. A subquery can retrieve zero or more rows.B. Only two subqueries can be placed at one level.C. A subquery can be used only in SQL quer...
- ocp考试题库下载：11g-v9.02-051-132题
ocp考试题库下载：11g-v9.02-051-132题，完整题库请点击这里联系老师咨询了解132. View the Exhibit and examine the structure of the SALES and PRODUCTS tables.In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table,You want to list each product ID and ...
- ocp考试题库下载：11g-v9.02-051-131题
ocp考试题库下载：11g-v9.02-051-131题，完整题库请点击这里联系老师咨询了解131. View the Exhibit and examine the structure of the PRODUCT, COMPONENT, and PDT_COMP tables.In PRODUCT table, PDTNO is the primary key.In COMPONENT table, COMPNO is the primary key.In PDT_COMP table, (PDT...
- ocp考试题库下载：11g-v9.02-051-130题
ocp考试题库下载：11g-v9.02-051-130题，完整题库请点击这里联系老师咨询了解130. View the Exhibit and examine the data in the EMPLOYEES table:You want to display all the employee names and their corresponding manager names.Evaluate the following query:SQL> SELECT e.employee_name ...
