Chinaunix首页 | 论坛 | 博客
  • 博客访问: 466323
  • 博文数量: 448
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 4536
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59

ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291









发布时间:2019-02-15 11:38:09

10、(5-6) choose the best answer:Examine the structure of the EMPLOYEES table:There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.You want to display the name, joining date, and manager for all the employees.Newly hired employees are yet to be assigned a department or a man.........【阅读全文】

阅读(767) | 评论(0) | 转发(0)

发布时间:2019-02-15 11:14:58

9、(5-5) choose the best answerView 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, s1.items_id, SUM(s1.quantit.........【阅读全文】

阅读(566) | 评论(0) | 转发(0)

发布时间:2019-02-14 11:03:17

8、(5-4) 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 creditlimit should be labeled New Credit Limit. The column headings should have .........【阅读全文】

阅读(439) | 评论(0) | 转发(0)

发布时间:2019-02-14 10:43:30

7、(5-1) 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) D.........【阅读全文】

阅读(420) | 评论(0) | 转发(0)

发布时间:2019-02-13 17:13:36

6、(4-21) 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 customersWHERE cust_credit_limit > 1000GROUP BY cust_cityHAVING AVG(cust_credit_limit) BETWEEN 5000 .........【阅读全文】

阅读(473) | 评论(0) | 转发(0)

登录 注册