ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-04-23 11:09:00
2.Which three statements are true about pfiles, spfiles or both? A) All spfile parameters can be modified successfully with the scope=both clause. B) A spfile can be created by an idle instance. C) spfiles and pfiles may both be edited with an O/S editing utility. D) Some spfile .........【阅读全文】
发布时间：2019-04-23 10:44:13
1.One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the users tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace ? A) SWITCH DATAFILE ALL; B) ALTE.........【阅读全文】
发布时间：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.........【阅读全文】
