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

052和053考试资料群:836361015 验证码:ocp







发布时间:2019-03-18 14:15:04

80、View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables.You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.Which CREATE VIEW statement would create the views successfully?A . AS SELECT o.order_id, o..........【阅读全文】

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

发布时间:2019-03-18 13:36:14

A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.C. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.Correct Answer: B......【阅读全文】

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

发布时间:2019-03-18 10:51:42

A. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customersC. listing of customers who do not have a credit limit and were born before 1980E. listing of those customers, whose credit limit is the same as the credit lim.........【阅读全文】

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

发布时间:2019-03-18 10:05:45

A. When the MAXVALUElimit for the sequence is reached, you can increase the MAXVALUElimit by using the ALTER SEQUENCEstatement.C. The numbers generated by a sequence can be used only for one table.E. When a database instance shuts down abnormally, the sequence numbers that have been cached.........【阅读全文】

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

发布时间:2019-03-11 16:07:03

SELECT employee_id, first_name, department_nameNATURAL JOIN departments;A. The table prefix is missing for the column names in the SELECTclause.C. The DEPARTMENTStable is not used before the EMPLOYEEStable in the FROMclause.Correct Answer: D......【阅读全文】

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

登录 注册