随笔分类 - 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
阅读全文
摘要: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
阅读全文
摘要:Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions: What c
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:The environmental variable ORACLE-BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Vi
阅读全文
摘要:How many different calendars does Oracle 11g support?A. 22 B. 7C. 6D. 15E. 2 Oracle supports seven distinct calendars:Gregorian,Japanese Imperial,ROC
阅读全文
摘要:If two windows overlap, which window attribute will determine whether one should be chosen over the other?A. WINDOW_PRIORITYB. PRIORITYC. PRIORITY_LEV
阅读全文
摘要:Which of the following calendaring syntax expressions would evaluate to the last day of every month?A. FREQ = MONTHLY; BYMONTHDAY = 31B. FREQ = MONTHL
阅读全文
摘要: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
阅读全文
摘要:Which of the following is not a valid calendaring syntax element?A. FREQB. BYHOURC. RUNDATED. INTERVALE. BYMINUTE The calendaring syntax does not supp
阅读全文
摘要: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
阅读全文
摘要:Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?A. CREATE_MAPPING_PRIORITYB. SET_MAPPING_PRIORITYC. SET_MAPPING_ORDERD. PRIO
阅读全文
摘要:Every resource plan must contain an allocation to which consumer group?A. LOW_GROUPB. SYS_GROUPC. DEFAULT_GROUPD. BASE_GROUPE. OTHER_GROUPS The OTHER_
阅读全文
摘要:Which of these represent the main components of Database Resource Manager? (Choose all that apply.)A. Resource consumer groupsB. Resource plansC. Reso
阅读全文
摘要: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
阅读全文
摘要:Which of the following supplied functions is used to identify external tables, directories, and BFILES?A. DBMS_TDB.CHECK_DIRECTORIESB. DBMS_TDB.CHECK_
阅读全文
浙公网安备 33010602011771号