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

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

文章分类

全部博文(260)

文章存档

2019年(222)

2018年(38)

我的朋友

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

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

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

发布时间:2019-02-13 16:57:37

5、(4-12) choose two:You executed the following CREATE TABLE statement that resulted in an error:SQL> CREATE TABLE employees(emp_id NUMBER(10) PRIMARY KEY,ename VARCHAR2(20),email NUMBER(3) UNIQUE,address VARCHAR2(500),phone VARCHAR2 (20),resume LONG,hire_date DATE,re.........【阅读全文】

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

发布时间:2019-02-12 16:49:50

4、(4-11) choose two:View the Exhibit and examine the data in the PRODUCT_INFORMATION table.Which two tasks would require subqueries? (Choose two.)A) displaying all supplier IDs whose average list price is more than 500B) displaying the total number of products supplied by supplier 102071 and .........【阅读全文】

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

发布时间:2019-02-12 16:40:06

3、(4-10) choose the best answer:The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:GRANT ALLON orders, order_itemsTO PUBLIC;What must be done to fix the statement?A) ALL should be replaced with a list of specific privileges.B) WITH GRANT OPTION should .........【阅读全文】

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

登录 注册