Chinaunix首页 | 论坛 | 博客
  • 博客访问: 146803
  • 博文数量: 260
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 2661
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

Oracle dba培训、OCP、OCM、MYSAL认证,可以找我们,cuug专业做这些

文章分类

全部博文(260)

文章存档

2019年(222)

2018年(38)

我的朋友

发布时间:2019-02-15 15:27:25

12、(5-12)choose two:Examine the data in the CUSTOMERS table:You want to list all cities that have more than one customer along with the customer details.Evaluate the following query:SQL>SELECT c1.custname, c1.cityFROM Customers c1______Customers c2ON (c1.city=c2.city AND c1.custname<>c2.cus.........【阅读全文】

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

发布时间:2019-02-15 13:19:30

11、(5-8) choose the best answer:Examine the structure of the BOOKS_TRANSACTIONS table.You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_IDhas been entered.Examine this partial SQL statement:SQL> UPDATE books_transactionsSET book.........【阅读全文】

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

发布时间: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.........【阅读全文】

阅读(287) | 评论(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 str.name, s1.items_id, SUM(s1.quantit.........【阅读全文】

阅读(213) | 评论(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 .........【阅读全文】

阅读(148) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册