当前位置: Oracle培训中心-> 071题库
165
164

新闻中心

  • 【第27题】OCP认证071近期出现的考试题库分享2019-05-23
  • 071题库分享-第27题、choose the best answer: 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 customers WHERE cust_credit_limit 1000 GROUP BY cust_city HAVING AVG(cust_credit_limit) BETWEEN 5000 AND 6000; Which statement is true regarding the outcome of the above query? A) It executes........详情
  • 【第28题】OCP认证071近期出现的考试题库分享2019-05-23
  • 071题库分享-第28题、choose two: View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks would require subqueries? A) Display the minimum list price for each product status. B) Display the total number of products supplied by supplier 102 and have product status as 'obsolete'. C) Display all suppliers whose list price is less than 1000. D) Display the number of pr........详情
  • 【第29题】OCP认证071近期出现的考试题库分享2019-05-23
  • 071题库分享-第29题、choose the best answer: You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase. Which statement would accomplish this ........详情
  • 【第30题】OCP认证071近期出现的考试题库分享2019-05-23
  • 071题库分享-第30题、choose the best answer View the Exhibit and examine the structure of the SALES and STORES tables. You want to display the store name and the total quantity sold for each item in the store. Which SQL statement will give the required output? A) SELECT str.name, s1.items_id, SUM(s1.quantity) FROM sales s1 JOIN stores str ON (s1.store_id = str.store_id) GROUP BY str.name, s........详情
  • 【第21题】OCP认证071近期出现的考试题库分享2019-05-23
  • 071题库分享-第21题、choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year. Only a few employees earn commission. Which SQL statement would you execute to get the desired output? A) SELECT fir........详情
  • 【第20题】OCP认证071近期出现的考试题库分享2019-05-22
  • 20.choose the best answer View the Exhibit and examine the data in the PROMOTIONS table. PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr. You need to produce a report that provides the name,cost,and start date of all promos in the POST category that were launched before January 1, 2000. Which SQL statement would you use?.....详情
  • 【第19题】OCP认证071近期出现的考试题库分享2019-05-22
  • 19.choose the best answer View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: SQLSELECT promo_name,CASE WHEN promo_cost=(SELECT AVG(promo_cost) FROM promotions WHERE promo_category= 'TV') THEN 'HIGH' ELSE 'LOW' END COST_REMARK FROM promotions;.....详情
  • 【第18题】OCP认证071近期出现的考试题库分享2019-05-22
  • 18.choose the best answer View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables. You issue the following query: SQLSELECT p.prod_id,prod_name,prod_list_price, quantity_sold,cust_last_name FROM products p NATURAL JOIN sales s NATURAL JOIN customers c WHERE prod_id =148; Which statement is true regarding the outcome of this query?.....详情
  • 【第17题】OCP认证071近期出现的考试题库分享2019-05-22
  • 17.choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. Evaluate the following SQL statement: SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date,6),1) "Review" FROM employees; The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID, and review date for employees. The review date is the first Monday after the completion of six months o........详情
  • 【第16题】OCP认证071近期出现的考试题库分享2019-05-22
  • OCP认证的071考试复杂多变,不断的有新考题出现,对很多考生造成了困扰,对此,我们专门收集整理了近期出现的071考试原题,并由专业人员对考题进行了讲解,帮助大家顺利通过071考试。--------------------------------------------16.choose twoView the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.You have a requirement from the supplies department to give a list containing P........详情
  • 【第15题】OCP认证071近期出现的考试题库分享2019-05-22
  • OCP认证的071考试复杂多变,不断的有新考题出现,对很多考生造成了困扰,对此,我们专门收集整理了近期出现的071考试原题,并由专业人员对考题进行了讲解,帮助大家顺利通过071考试。--------------------------------------------15.choose the best answerView the Exhibit and examine the structure of the ORDER_ITEMS table.Examine the following SQL statement:SELECT order_id, product_id, unit_priceFROM order_itemsW........详情
  • 【第14题】OCP认证071近期出现的考试题库分享2019-05-22
  • 14.choose the best answer View the Exhibit and examine the data in EMP and DEPT tables. In the DEPT table, DEPTNO is the PRIMARY KEY. In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing the DEPTNO column in the DEPT table. What would be the outcome of the following statements executed in the given sequence? DROP TABLE emp;.....详情
  • 【第13题】OCP认证071近期出现的考试题库分享2019-05-22
  • 13.choose the best answer Which statement is true regarding the USING clause in table joins? A) It can be used to access data from tables through equijoins as well as nonequijoins. B) It can be used to join tables that have columns with the same name and compatible data types. C) It can be used to join a maximum of three tables. D) It can be used to restrict the number of columns used in a N........详情
  • 【第12题】OCP认证071近期出现的考试题库分享2019-05-22
  • OCP认证的071考试复杂多变,不断的有新考题出现,对很多考生造成了困扰,对此,我们专门收集整理了近期出现的071考试原题,并由专业人员对考题进行了讲解,帮助大家顺利通过071考试。--------------------------------------------12.choose the best answerEvaluate the following query:SQL> SELECT promo_name || q'{'s start date was \}' || promo_begin_dateAS "Promotion Launches"FROM promotions;What would be the o........详情
  • 【第11题】OCP认证071近期出现的考试题库分享2019-05-22
  • 11.choose the best answer Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: SQL CREATE TABLE DEPARTMENT_DETAILS (DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) , HOD VARCHAR2(50)); SQL CREATE TABLE COURSE_DETAILS (COURSE_ID NUMBER PRIMARY KEY, COURSE_NAME VARCHAR2 (50) , DEPARTMENT_ID NUMBER REFERENCES DEPARTMENT_DETAILS(DEPARTMENT_ID)); You want........详情
首页  上一页  12345  下一页 尾页 共70条记录 4/5
关闭