随笔分类 -  ocp-其他

摘要:View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which r 阅读全文
posted @ 2017-11-15 15:34 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
摘要:You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g database. The Prod1, Prod2 and Prod3 Oracle Database 10 阅读全文
posted @ 2017-11-15 15:30 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
摘要:Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions: What c 阅读全文
posted @ 2017-11-15 15:18 巴啦啦大魔王 阅读(188) 评论(0) 推荐(0)
摘要:You observed the following output for a user session: What do you infer from the preceding output?A. Resumable set for session with sid 18B. The user 阅读全文
posted @ 2017-11-15 15:14 巴啦啦大魔王 阅读(183) 评论(0) 推荐(0)
摘要:Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process wou 阅读全文
posted @ 2017-11-15 15:12 巴啦啦大魔王 阅读(266) 评论(0) 推荐(0)
摘要:You executed the following commands in a database session: Which statement is true about the contents of the recycle bin in this situation?A.They rema 阅读全文
posted @ 2017-11-15 14:14 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
摘要:View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you re 阅读全文
posted @ 2017-11-15 13:58 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
摘要:A user receives the following error while performing a large volume of inserts into a table: The issue is resolved by increasing the space quota on th 阅读全文
posted @ 2017-11-15 13:55 巴啦啦大魔王 阅读(157) 评论(0) 推荐(0)
摘要:The environmental variable ORACLE-BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Vi 阅读全文
posted @ 2017-11-15 11:17 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
摘要:How many different calendars does Oracle 11g support?A. 22 B. 7C. 6D. 15E. 2 Oracle supports seven distinct calendars:Gregorian,Japanese Imperial,ROC 阅读全文
posted @ 2017-11-15 10:49 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
摘要:If two windows overlap, which window attribute will determine whether one should be chosen over the other?A. WINDOW_PRIORITYB. PRIORITYC. PRIORITY_LEV 阅读全文
posted @ 2017-11-14 17:36 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
摘要:Which of the following calendaring syntax expressions would evaluate to the last day of every month?A. FREQ = MONTHLY; BYMONTHDAY = 31B. FREQ = MONTHL 阅读全文
posted @ 2017-11-14 16:59 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
摘要:What is the default value for the ENABLED attribute of a job or program when it is created? A. TRUEB. FALSEC. There is no default. It must be defined 阅读全文
posted @ 2017-11-14 16:47 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
摘要:Which of the following is not a valid calendaring syntax element?A. FREQB. BYHOURC. RUNDATED. INTERVALE. BYMINUTE The calendaring syntax does not supp 阅读全文
posted @ 2017-11-14 16:25 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
摘要:Within a resource-plan definition, what differentiates a top-level plan from a subplan?A. A subplan has the PLAN_SUB parameter value set to SUB.B. A t 阅读全文
posted @ 2017-11-14 16:14 巴啦啦大魔王 阅读(77) 评论(0) 推荐(0)
摘要:Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?A. CREATE_MAPPING_PRIORITYB. SET_MAPPING_PRIORITYC. SET_MAPPING_ORDERD. PRIO 阅读全文
posted @ 2017-11-14 16:11 巴啦啦大魔王 阅读(60) 评论(0) 推荐(0)
摘要:Every resource plan must contain an allocation to which consumer group?A. LOW_GROUPB. SYS_GROUPC. DEFAULT_GROUPD. BASE_GROUPE. OTHER_GROUPS The OTHER_ 阅读全文
posted @ 2017-11-14 16:08 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
摘要:Which of these represent the main components of Database Resource Manager? (Choose all that apply.)A. Resource consumer groupsB. Resource plansC. Reso 阅读全文
posted @ 2017-11-14 16:05 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
摘要:Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?A. The database must be in read-write mode.B. The da 阅读全文
posted @ 2017-11-14 15:32 巴啦啦大魔王 阅读(76) 评论(0) 推荐(0)
摘要:Which of the following supplied functions is used to identify external tables, directories, and BFILES?A. DBMS_TDB.CHECK_DIRECTORIESB. DBMS_TDB.CHECK_ 阅读全文
posted @ 2017-11-14 15:29 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)