单项选择题
You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()
A. Use the CHANGE_PASSWORD command of the Listener control utility.
B. Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
C. Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
D. Manually modify the listener.ora file to include the password for the listener and restart the listener.
相关考题
-
单项选择题
WhichstatementistrueregardingthecreationofnestedplansusingResourceManager?()
A. Only one nested subplan is allowed.
B. The plans can be nested up to four levels.
C. Resource Manager does not support nested plans.
D. Nested plans control only the degree of parallelism but not the CPU.
E. Each nested plan gets a proportion of the CPU resources assigned to its parent group. -
多项选择题
You execute the following command to create two consumer groups, FIN_GROUP1 and PAY_GROUP1 for a plan, PROD_PLAN: BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN (SIMPLE_PLAN =>’prod_plan’, CONSUMER_GROUP1 => ’fin_group1’, GROUP1_CPU => 80, CONSUMER_GROUP2 => ’pay_group1’, GROUP2_CPU => 20); END; Which three statements are true? ()
A. SYS_GROUP gets 100% CPU resources at level 1.
B. FIN_GROUP1 gets 80% CPU resources at level 1.
C. FIN_GROUP1 gets 80% CPU resources at level 2.
D. PAY_GROUP1 gets 20% CPU resources at level 1.
E. PAY_GROUP1 gets 20% CPU resources at level 2.
F. OTHER_GROUP gets 100% CPU resources at level 1.
G. OTHER_GROUP gets 100% CPU resources at level 2. -
单项选择题
Yourbusinesshasdepartmentalreportsthataregeneratedeveryday.Eachdepartmentmustusethesamesetofqueries,butaccessadifferentsubsetofdatainthetables,dependingonwhichdepartmentgeneratesthereport.Theformatofthereportsisbeingdeveloped;currently,theformatchangesdaily.Howwouldyouconfigurethedatabasetoensurethateachdepartmentgeneratesitsreport(basedonitstargetdata)usingthemostrecentreportformateveryday?()
A. By having each user run the report generation procedure at the scheduled time, supplying the necessary input variables.
B. By creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOB.
C. By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
D. By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
E. By creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER.
