ocp考试资料群：569933648 验证码：ocp ocp 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（485）
- postgresql（54）
- ocp 12c（175）
- ocp（102）
- 未分配的博文（154）
发布时间：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......