ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间: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..........【阅读全文】
发布时间: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......【阅读全文】
发布时间: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.........【阅读全文】
发布时间: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.........【阅读全文】
发布时间: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......【阅读全文】