Oracle OCP认证-Oracle OCM认证

  • ocp考试题库下载：11g-v9.02-051-129题

    ocp考试题库下载：11g-v9.02-051-129题，完整题库请点击这里联系老师咨询了解129. View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.Evaluate the following SQL statement:SQL>SELECT p.promo_id, p.promo_name, s.prod_idFROM sales s RIGHT OUTER JOIN promot...

  • ocp考试题库下载：11g-v9.02-051-128题

    ocp考试题库下载：11g-v9.02-051-128题，完整题库请点击这里联系老师咨询了解128. View the Exhibits and examine the structures of the CUSTOMERS, SALES, and COUNTRIES tables.You need to generate a report that shows all country names, with corresponding customers (if any) and sales det...

  • ocp考试题库下载：11g-v9.02-051-127题

    ocp考试题库下载：11g-v9.02-051-127题，完整题库请点击这里联系老师咨询了解127. Examine the data in the CUSTOMERS table:CUSTNO CUSTNAME CITY1 KING SEATTLE2 GREEN BOSTON3 KOCHAR SEATTLE4 SMITH NEW YORKYou want to list all cities that have more than one customer along with the custom...

  • ocp考试题库下载：11g-v9.02-051-126题

    ocp考试题库下载：11g-v9.02-051-126题，完整题库请点击这里联系老师咨询了解126. View the Exhibit and examine the data in the PROJ_TASK_DETAILS table.The PROJ_TASK_DETAILS table stores information about tasks involved in a project and the relationbetween them.The BASED_ON column ind...

  • ocp考试题库下载：11g-v9.02-051-125题

    ocp考试题库下载：11g-v9.02-051-125题，完整题库请点击这里联系老师咨询了解125. Examine the structure of the CUSTOMERS table:name Null TypeCUSTNO NOT NULL NUMBER(3)CUSTNAME NOT NULL VARCHAR2(25)CUSTADDRESS VARCHAR2(35)CUST_CREDIT_LIMIT NUMBER(5)CUSTNO is the PRIMARY KEY in the tabl...

  • ocp考试题库下载：11g-v9.02-051-124题

    ocp考试题库下载：11g-v9.02-051-124题，完整题库请点击这里联系老师咨询了解124. View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.You need to generate a report showing the promo name along with the customer name for all productsthat were sold ...

  • ocp考试题库下载：11g-v9.02-051-123题

    ocp考试题库下载：11g-v9.02-051-123题，完整题库请点击这里联系老师咨询了解123. View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERStables.You need to generate a report that gives details of the customer's last name, name of the product, andthe quantit...

  • ocp考试题库下载：11g-v9.02-051-122题

    ocp考试题库下载：11g-v9.02-051-122题，完整题库请点击这里联系老师咨询了解122. View the Exhibit for the structure of the STUDENT and FACULTY tables.You need to display the faculty name followed by the number of students handled by the faculty at thebase location.Examine the follow...

  • ocp考试题库下载：11g-v9.02-051-121题

    ocp考试题库下载：11g-v9.02-051-121题，完整题库请点击这里联系老师咨询了解121. Which two statements are true regarding the USING clause in table joins? (Choose two .)A. It can be used to join a maximum of three tables.B. It can be used to restrict the number of columns used in a N...

  • ocp 11g认证题库大全：1Z0-051-120题

    ocp 11g认证题库大全：1Z0-051-120题，完整题库请点击这里联系老师咨询了解120. View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERStables.You issue the following query:SQL>SELECT p.prod_id,prod_name,prod_list_price,quantity_sold,cust_last_nameFROM pr...

  • ocp 11g认证题库大全：1Z0-051-119题

    ocp 11g认证题库大全：1Z0-051-119题，完整题库请点击这里联系老师咨询了解119. Examine the data in the ORD_ITEMS table:ORD_NO ITEM_NO QTY1 111 101 222 201 333 302 333 302 444 403 111 40Evaluate the following query:SQL>SELECT item_no, AVG(qty)FROM ord_itemsHAVING AVG(qty) > MIN...

  • ocp 11g认证题库大全：1Z0-051-118题

    ocp 11g认证题库大全：1Z0-051-118题，完整题库请点击这里联系老师咨询了解118. View the Exhibit and examine the structure of the PROMOTIONS table.Examine the following two SQL statements:Statement 1SQL>SELECT promo_category,SUM(promo_cost)FROM promotionsWHERE promo_end_date-promo...

  • ocp 11g认证题库大全：1Z0-051-117题

    ocp 11g认证题库大全：1Z0-051-117题，完整题库请点击这里联系老师咨询了解117. Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?(Choose all that apply.)A. The HAVING clause can be used with aggregate functions in subqueries.B. The WHERE clause c...

  • ocp 11g认证题库大全：1Z0-051-116题

    ocp 11g认证题库大全：1Z0-051-116题，完整题库请点击这里联系老师咨询了解116. Examine the data in the ORD_ITEMS table:ORD_NO ITEM_NO QTY1 111 101 222 201 333 302 333 302 444 403 111 40You want to find out if there is any item in the table for which the average maximum quantity is m...

  • ocp 11g认证题库大全：1Z0-051-115题

    ocp 11g认证题库大全：1Z0-051-115题，完整题库请点击这里联系老师咨询了解115. View the Exhibit and examine the structure of the CUSTOMERS table.Evaluate the following SQL statement:SQL> SELECT cust_city, COUNT(cust_last_name)FROM customersWHERE cust_credit_limit > 1000GROUP B...

  • ocp 11g认证题库大全：1Z0-051-114题

    ocp 11g认证题库大全：1Z0-051-114题，完整题库请点击这里联系老师咨询了解114. View the Exhibit and examine the structure of the SALES table.The following query is written to retrieve all those product ID s from the SALES table that have more than55000 sold and have been ordered mor...

  • ocp 11g认证题库大全：1Z0-051-113题

    ocp 11g认证题库大全：1Z0-051-113题，完整题库请点击这里联系老师咨询了解113. Examine the structure of the ORDERS table:Name Null TypeORDER_ID NOT NULL NUMBER(12)ORDER_DATE NOT NULL TIMESTAMP(6)CUSTOMER_ID NOT NULL NUMBER(6)ORDER_STATUS NUMBER(2)ORDER_TOTAL NUMBER(8,2)You want to f...

  • ocp 11g认证题库大全：1Z0-051-112题

    ocp 11g认证题库大全：1Z0-051-112题，完整题库请点击这里联系老师咨询了解112. View the Exhibit and examine the structure of the PROMOTIONS table.Evaluate the following SQL statement:SQL>SELECT promo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_OverheadFROM promoti...

  • ocp 11g认证题库大全：1Z0-051-111题

    ocp 11g认证题库大全：1Z0-051-111题，完整题库请点击这里联系老师咨询了解111. View the Exhibit and examine the structure of the CUSTOMERS table.Which statement would display the highest credit limit available in each income level in each city in theCUSTOMERS table?A. SELECT cust_ci...

  • ocp 11g认证题库大全：1Z0-051-110题

    ocp 11g认证题库大全：1Z0-051-110题，完整题库请点击这里联系老师咨询了解110. View the Exhibit and examine the structure of the CUSTOMERS table.Using the CUSTOMERS table, you need to generate a report that shows the average credit limit forcustomers in WASHINGTON and NEW YORK.Which...

  • ocp 11g认证题库大全：1Z0-051-109题

    ocp 11g认证题库大全：1Z0-051-109题，完整题库请点击这里联系老师咨询了解109. Examine the structure of the MARKS table:name Null TypeSTUDENT_ID NOT NULL VARCHAR2(4)STUDENT_NAME VARCHAR2(25)SUBJECT1 NUMBER(3)SUBJECT2 NUMBER(3)SUBJECT3 NUMBER(3)Which two statements would execute succ...

  • ocp 11g认证题库大全：1Z0-051-108题

    ocp 11g认证题库大全：1Z0-051-108题，完整题库请点击这里联系老师咨询了解108. Which two statements are true regarding the COUNT function? (Choose two.)A. The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types.B. COUNT(*) returns the number of rows including d...

  • ocp 11g认证题库大全：1Z0-051-107题

    ocp 11g认证题库大全：1Z0-051-107题，完整题库请点击这里联系老师咨询了解107. View the Exhibit and examine the structure and data in the INVOICE table.Which two SQL statements would execute successfully? (Choose two.)A. SELECT AVG(inv_date ) 类型不一致，不能对date求平均值FROM invoi...

  • ocp 11g认证题库大全：1Z0-051-106题

    ocp 11g认证题库大全：1Z0-051-106题，完整题库请点击这里联系老师咨询了解106. Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:LIST_PRICE MIN_PRICE10000 80002000030000 30000Which two expressions give the same output? (Choose two.)A. NVL(NULLIF(list_pri...

  • ocp 11g认证题库大全：1Z0-051-105题

    ocp 11g认证题库大全：1Z0-051-105题，完整题库请点击这里联系老师咨询了解105. Examine the structure of the PROMOS table:name Null TypePROMO_ID NOT NULL NUMBER(3)PROMO_NAME VARCHAR2(30)PROMO_START_DATE NOT NULL DATEPROMO_END_DATE NOT NULL DATEYou want to display the list of promo na...

  • ocp 11g认证题库大全：1Z0-051-104题

    ocp 11g认证题库大全：1Z0-051-104题，完整题库请点击这里联系老师咨询了解104. Examine the structure of the PROMOS table:name Null TypePROMO_ID NOT NULL NUMBER(3)PROMO_NAME VARCHAR2(30)PROMO_START_DATE NOT NULL DATEPROMO_END_DATE DATEYou want to generate a report showing promo names...

  • ocp 11g考试题库大全：1Z0-051-103题

    ocp 11g考试题库大全：1Z0-051-103题，完整题库请点击这里联系老师咨询了解103. Examine the structure of the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(3)CUST_NAME VARCHAR2(30)TRANS_DATE DATETRANS_AMT NUMBER(10,2)You want to display the transaction date and specify whe...

  • ocp 11g考试题库大全：1Z0-051-102题

    ocp 11g考试题库大全：1Z0-051-102题，完整题库请点击这里联系老师咨询了解102. Examine the structure of the TRANSACTIONS table:name Null TypeTRANS_ID NOT NULL NUMBER(3)CUST_NAME VARCHAR2(30)TRANS_DATE TIMESTAMPTRANS_AMT NUMBER(10,2)You want to display the date, time, and transaction...

  • ocp 11g考试题库大全：1Z0-051-101题

    ocp 11g考试题库大全：1Z0-051-101题，完整题库请点击这里联系老师咨询了解101. Examine the data in the PROMO_BEGIN_DATE column of the PROMOTIONS table:PROMO_BEGIN _DATE04-jan-0010-jan-0015-dec-9918-oct-9822-aug-99You want to display the number of promotions started in 1999 and 2000....

  • ocp 11g考题大全：1Z0-051-100题

    ocp 11g考题大全：1Z0-051-100题，完整题库请点击这里联系老师咨询了解100. View the Exhibit and examine the structure of the PROMOTIONS table.Which SQL statements are valid? (Choose all that apply.)A. SELECT promo_id, DECODE(NVL(promo_cost,0), promo_cost,promo_cost * 0.25, 100) "Dis...

首页  上一页  34567  下一页 尾页