ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：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......【阅读全文】
发布时间：2019-03-11 13:00:22
A. A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to creates a unique index.C. When a table is dropped, the corresponding indexes are automatically dropped.Correct Answer: ACD......【阅读全文】
发布时间：2019-03-11 11:54:09
Name Null? TypeORDER_DATE NOT NULL DATECUSTOMER_ID NOT NULL NUMBER(6)Name Null? TypeCUST_FIRST_NAME NOT NULL VARCHAR2(20)CREDIT_LIMIT NUMBER(9,2)Which INSERT statement shoul.........【阅读全文】
