alice9313

OCP最新考试题库-052新考题及答案整理-34

摘要： 34、Which is true about invalid PL/SQL objects? A) They are automatically recompiled against the new definition of a referenced object at the same time 阅读全文

posted @ 2018-09-06 11:03 alice9313 阅读(129) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-33

摘要： 33、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install. Your plan is to install both Oracle da 阅读全文

posted @ 2018-09-06 10:44 alice9313 阅读(160) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-32

摘要： 32、Which two statements are true about tablespaces? A) A database can contain multiple undo tablespaces. B) A database can contain only a single tempo 阅读全文

posted @ 2018-09-05 13:35 alice9313 阅读(185) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-31

摘要： 31、Your database Is configured In archivelog mode. The USERS01 tablespace Is currently online. You are required to take the tablespace offline. Which 阅读全文

posted @ 2018-09-05 11:28 alice9313 阅读(174) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-30

摘要： 30、Which four are true about the tools used to administer Oracle databases? A) SQL*Plus can be used to create databases. B) RMAN can be used to start 阅读全文

posted @ 2018-09-05 11:13 alice9313 阅读(130) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-29

摘要： 29、Which two are true about undo tablespaces? A) They always retain undo for the time period defined by UNDO_RETENTION. B) They must have only one dat 阅读全文

posted @ 2018-09-04 15:24 alice9313 阅读(162) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-28

摘要： 28、USER1. EMP has a referential Integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO. user1 executes these commands: SQL> UPDATE dep 阅读全文

posted @ 2018-09-04 14:45 alice9313 阅读(547) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-27

摘要： 27、Which two are true about data dictionary views? A) ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed d 阅读全文

posted @ 2018-09-04 13:42 alice9313 阅读(146) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-26

摘要： 26、Your database Is open in ARCHIVELOG mode. • LOG_ARCHIVE_DEST Is set to Fast Recovery Area (FRA) and it Is 100% full when a log switch takes place. 阅读全文

posted @ 2018-09-03 11:33 alice9313 阅读(131) 评论(0) 推荐(0)

OCP换题库了，最新052考试题库及答案整理-25

摘要： 25、Examine this LISTENER. ORA file: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = srvl.example.com 阅读全文

posted @ 2018-09-03 11:16 alice9313 阅读(131) 评论(0) 推荐(0)