ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间:2019-04-25 11:44:08
9.You ran this command on a source database:$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=empl.dmp VIEWS_AS_TABLES=emp_deptOn the target database, you run this command:impdp hr/hr DIRECTORY=dumpdir DUMPFILE=empl.dmp VIEWS_AS_TABLES=emp_deptWhich two statements are true?A) The expdp operation export.........【阅读全文】
发布时间:2019-04-25 11:04:04
8. Which are two ways for a database service to be recognized by a listener in Oracle Database 12c?A) Static registration in the listener.ora file using the service_name parameterB) Dynamic Registration by the smon processC) Static registration in the listener.ora file using the global_dbname par.........【阅读全文】
发布时间:2019-04-24 13:12:21
7.daily_ords_lst is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.CREATE TABLE daily_ords_list (ordno NUMBER, ord_date DATE) PCTFREE 20;Which two are true ?A) 80% of every data block in daily_ords_lst is reserved for row inserts.B) pctfree elimina.........【阅读全文】
发布时间:2019-04-24 11:54:44
6.Which four statements are true about database instance behavior?A) Redo log files can be renamed in mount state.B) Datafiles can be renamed in mount state.C) All dynamic performance views (v$ views) return data when queried from a session connected to an Instance in nomount state.D) An spfile .........【阅读全文】
发布时间:2019-04-24 11:07:30
5.One of your databases supports an OLTP workload.The default undo tablespace is fixed size with:1. RETENTION NOGUARANTEE2. undo_retention is 12 minutesUser scott get this error after a query on the sales table has run for more than 15 minutes:ORA-01555: snapshot too oldWhich three factors tak.........【阅读全文】