ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-10-18 14:51:08
Which two statements are true about Oracle synonyms?B) All private synonym names must be unique in the database.D) A synonym can be created on an object in a package.(解析：同义词也是 Oracle 的一个对象;......【阅读全文】
发布时间：2019-10-18 09:36:29
Which three statements are true about views in an Orade batabase?B) Rows inserted into a table using a view are retained in the table if the view is doppedD) Views have no segment.F) A view can be created that refers to a non-existent table in its defining query.(解析：.........【阅读全文】
发布时间：2019-10-17 11:49:07
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATEThe NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day ofthe weekA) SELECT emp_id,NEXT_DAY(ADD_MONTHS(hite_date,6), 'MONDAY') FROM employees;C) S.........【阅读全文】
发布时间：2019-10-17 09:52:27
Which three are true about granting object privileges on tables, views, and sequences?B) DELETE can be granted on tables, views, and sequences.D) INSERT can be granted on tables, vews, and sequences.F) ALTER can be granted only on tables and sequences.(解析：update 和 delete 只能在.........【阅读全文】
发布时间：2019-10-16 10:02:47
Which three statements are true about indexes and their administration in an Orade database?B) An index can be created as part of a CREATE TABLE statement.D) A UNIQUE and non-unique index can be ceated on the same table colunnF) If a query filters on an indexed column then it will alwa.........【阅读全文】
