搜题

【多选题】

You&ensp;plan&ensp;to&ensp;use&ensp;SQL&ensp;Performance&ensp;Analyzer&ensp;to&ensp;analyze&ensp;the&ensp;SQL&ensp;workload.&ensp;You&ensp;created&ensp;a&ensp;SQL&ensp;Tuning&ensp;Set&ensp;as&ensp;a&ensp;part&ensp;of&ensp;the&ensp;workload&ensp;capturing.&ensp;<br /> What&ensp;information&ensp;is&ensp;captured&ensp;as&ensp;part&ensp;of&ensp;this&ensp;process？（）

A、 the SQL text

B、 the execution plan

C、 the execution context

D、 the execution frequency

E、 the system change number （SCN）

查看正确答案

更多“ You&ensp;plan&ensp;to&ensp;use&ensp;SQL&ensp;Performance&ensp;Analyzer&ensp;to&ensp;analyze&ensp;the&ensp;SQL&ensp;workload.&ensp;You&ensp;created&ensp;a&ensp;SQL&ensp;Tuning&ensp;Set&ensp;as&ensp;a&ensp;part&ensp;of&ensp;the&ensp;workload&ensp;capturing.&ensp;<br /> What&ensp;information&ensp;is&ensp;captured&ensp;as&ensp;part&ensp;of&ensp;this&ensp;process？（）”相关的问题

第1题

[单选题] You&ensp;have&ensp;created&ensp;a&ensp;resource&ensp;plan，&ensp;DB_PLAN，&ensp;using&ensp;DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN&ensp;and&ensp;you&ensp;want&ensp;to&ensp;impose&ensp;a&ensp;restriction&ensp;on&ensp;utilization&ensp;of&ensp;resources&ensp;by&ensp;the&ensp;database&ensp;users.&ensp;&ensp; Which&ensp;step&ensp;must&ensp;be&ensp;performed&ensp;before&ensp;you&ensp;can&ensp;start&ensp;using&ensp;the&ensp;resource&ensp;plan？（）

A、assign&ensp;users&ensp;to&ensp;consumer&ensp;groups B、set&ensp;the&ensp;resource&ensp;plan&ensp;for&ensp;the&ensp;instance C、configure&ensp;a&ensp;simple&ensp;resource&ensp;plan&ensp;and&ensp;specify&ensp;plan&ensp;directives D、configure&ensp;a&ensp;complex&ensp;resource&ensp;plan&ensp;and&ensp;specify&ensp;plan&ensp;directives

点击查看答案

第2题

[单选题] You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）

A、&ensp;assign&ensp;users&ensp;to&ensp;consumer&ensp;groups B、&ensp;set&ensp;the&ensp;resource&ensp;plan&ensp;for&ensp;the&ensp;instance C、&ensp;configure&ensp;a&ensp;simple&ensp;resource&ensp;plan&ensp;and&ensp;specify&ensp;plan&ensp;directives D、&ensp;configure&ensp;a&ensp;complex&ensp;resource&ensp;plan&ensp;and&ensp;specify&ensp;plan&ensp;directives

点击查看答案

第3题

[单选题] You&ensp;run&ensp;the&ensp;SQL&ensp;Tuning&ensp;Advisor&ensp;（STA）&ensp;to&ensp;tune&ensp;a&ensp;SQL&ensp;statement&ensp;that&ensp;is&ensp;part&ensp;of&ensp;a&ensp;fixed&ensp;SQL&ensp;plan&ensp;baseline.&ensp;The&ensp;STA&ensp;generates&ensp;a&ensp;SQL&ensp;profile&ensp;for&ensp;the&ensp;SQL&ensp;statement，which&ensp;recommends&ensp;that&ensp;you&ensp;accept&ensp;the&ensp;profile.&ensp; Which&ensp;statement&ensp;is&ensp;true&ensp;when&ensp;you&ensp;accept&ensp;the&ensp;suggested&ensp;SQL&ensp;profile？（）&ensp;&ensp;

A、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;not&ensp;added&ensp;to&ensp;the&ensp;SQL&ensp;plan&ensp;baseline. B、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;added&ensp;to&ensp;the&ensp;fixed&ensp;SQL&ensp;plan&ensp;baseline&ensp;as&ensp;a&ensp;fixed&ensp;plan. C、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;added&ensp;to&ensp;the&ensp;fixed&ensp;SQL&ensp;plan&ensp;baseline&ensp;as&ensp;a&ensp;nonfixed&ensp;plan. D、&ensp;The&ensp;tuned&ensp;plan&ensp;is&ensp;added&ensp;to&ensp;a&ensp;new&ensp;nonfixed&ensp;SQL&ensp;plan&ensp;baseline&ensp;as&ensp;a&ensp;nonfixed&ensp;plan.

点击查看答案

第4题

[单选题] Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

A、&ensp;A&ensp;window&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan. B、&ensp;A&ensp;program&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan. C、&ensp;A&ensp;job&ensp;class&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan. D、&ensp;A&ensp;window&ensp;group&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan.

点击查看答案

第5题

[] Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

A、A.&ensp;A&ensp;window&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan. B、B.&ensp;A&ensp;program&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan. C、C.&ensp;A&ensp;job&ensp;class&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan. D、D.&ensp;A&ensp;windows&ensp;group&ensp;must&ensp;have&ensp;been&ensp;created&ensp;with&ensp;the&ensp;WEEKEND_PLAN&ensp;resource&ensp;plan.

点击查看答案

第6题

[] You&ensp;are&ensp;planning&ensp;the&ensp;consolidation&ensp;of&ensp;the&ensp;application&ensp;servers. You&ensp;need&ensp;to&ensp;identify&ensp;the&ensp;appropriate&ensp;disk&ensp;configuration&ensp;for&ensp;the&ensp;VMs&ensp;based&ensp;on&ensp;the&ensp;company’s&ensp;planned&ensp;changes. Which&ensp;disk&ensp;configuration&ensp;should&ensp;you&ensp;identify？（） You&ensp;are&ensp;planning&ensp;the&ensp;consolidation&ensp;of&ensp;the&ensp;application&ensp;servers. You&ensp;need&ensp;to&ensp;identify&ensp;the&ensp;appropriate&ensp;disk&ensp;configuration&ensp;for&ensp;the&ensp;VMs&ensp;based&ensp;on&ensp;the&ensp;company’s&ensp;planned&ensp;changes. Which&ensp;disk&ensp;configuration&ensp;should&ensp;you&ensp;identify？（）

A、A.fixed-size&ensp;virtual&ensp;hard&ensp;disk&ensp;（VHD） B、B.dynamically&ensp;expanding&ensp;virtual&ensp;hard&ensp;disk&ensp;（VHD） C、C.differencing&ensp;disks D、D.pass-through&ensp;disks

点击查看答案

第7题

[单选题] The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement： SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’； What will be the outcome of this statement？（）

A、&ensp;The&ensp;statement&ensp;will&ensp;deactivate&ensp;DAY_PLAN. B、&ensp;The&ensp;statement&ensp;will&ensp;activate&ensp;DAY_PLAN&ensp;as&ensp;the&ensp;top&ensp;plan. C、&ensp;The&ensp;statement&ensp;will&ensp;activate&ensp;MANAGERS_PLAN&ensp;as&ensp;the&ensp;top&ensp;plan. D、&ensp;The&ensp;statement&ensp;will&ensp;return&ensp;an&ensp;error&ensp;because&ensp;MANAGERS_PLAN&ensp;is&ensp;not&ensp;the&ensp;top&ensp;plan.

点击查看答案

第8题

[] Your&ensp;virtual&ensp;environment&ensp;includes&ensp;Windows&ensp;Server&ensp;2008&ensp;R2&ensp;Hyper-V&ensp;servers.&ensp;You&ensp;plan&ensp;to&ensp;deploy&ensp;Microsoft&ensp;Virtual&ensp;Desktop&ensp;Infrastructure.&ensp;You&ensp;plan&ensp;to&ensp;scale&ensp;both&ensp;static&ensp;and&ensp;dynamic&ensp;deployments&ensp;across&ensp;several&ensp;servers.&ensp;You&ensp;need&ensp;to&ensp;design&ensp;a&ensp;plan&ensp;that&ensp;supports&ensp;static&ensp;and&ensp;dynamic&ensp;deployments&ensp;and&ensp;that&ensp;allows&ensp;for&ensp;capacity&ensp;growth&ensp;without&ensp;outages.&ensp; What&ensp;should&ensp;you&ensp;include&ensp;in&ensp;your&ensp;plan？（） Your&ensp;virtual&ensp;environment&ensp;includes&ensp;Windows&ensp;Server&ensp;2008&ensp;R2&ensp;Hyper-V&ensp;servers.&ensp;You&ensp;plan&ensp;to&ensp;deploy&ensp;Microsoft&ensp;Virtual&ensp;Desktop&ensp;Infrastructure.&ensp;You&ensp;plan&ensp;to&ensp;scale&ensp;both&ensp;static&ensp;and&ensp;dynamic&ensp;deployments&ensp;across&en

A、A.Use&ensp;DNS&ensp;round-robin&ensp;and&ensp;network&ensp;load&ensp;balancing B、B.Use&ensp;network&ensp;load&ensp;balancing&ensp;and&ensp;failover&ensp;clustering C、C.Use&ensp;the&ensp;Remote&ensp;Desktop&ensp;Gateway&ensp;and&ensp;network&ensp;load&ensp;balancing D、D.Use&ensp;the&ensp;Remote&ensp;Desktop&ensp;Connection&ensp;Broker&ensp;and&ensp;failover&ensp;clustering

点击查看答案

第9题

[] You&ensp;are&ensp;planning&ensp;a&ensp;new&ensp;VLAN-based&ensp;network&ensp;solution.&ensp; What&ensp;is&ensp;one&ensp;item&ensp;you&ensp;should&ensp;consider&ensp;when&ensp;creating&ensp;your&ensp;implementation&ensp;plan&ensp;as&ensp;it&ensp;concerns&ensp;VLANs？（） You&ensp;are&ensp;planning&ensp;a&ensp;new&ensp;VLAN-based&ensp;network&ensp;solution.&ensp; What&ensp;is&ensp;one&ensp;item&ensp;you&ensp;should&ensp;consider&ensp;when&ensp;creating&ensp;your&ensp;implementation&ensp;plan&ensp;as&ensp;it&ensp;concerns&ensp;VLANs？（）

A、A.generic&ensp;router&ensp;and&ensp;switch&ensp;configuration&ensp;parameters B、B.end-to-end&ensp;test&ensp;plan&ensp;after&ensp;all&ensp;components&ensp;have&ensp;been&ensp;installed&ensp;and&ensp;&ensp;configured C、C.administrator&ensp;assignments D、D.rollback&ensp;plan

点击查看答案

第10题

[单选题] You&ensp;execute&ensp;the&ensp;following&ensp;block&ensp;of&ensp;code：&ensp;&ensp; SQL>BEGIN&ensp;&ensp; DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN&ensp;&ensp; （&ensp;SIMPLE_PLAN&ensp;=>&ensp;’DEPARTMENTS’，&ensp;&ensp; CONSUMER_GROUP1&ensp;=>&ensp;’PAYROLLL’，&ensp;&ensp; GROUP1_CPU&ensp;=>&ensp;50，&ensp;&ensp; CONSUMER_GROUP2&ensp;=>&ensp;’SALES’，&ensp;&ensp; GROUP2_CPU&ensp;=>&ensp;25，&ensp;&ensp; CONSUMER_GROUP3&ensp;=>&ensp;’MARKETING’，&ensp;&ensp; GROUP3_CPU&ensp;=>&ensp;25）；&ensp;&ensp; END；&ensp;&ensp; SQL>/&ensp;&ensp; What&ensp;is&ensp;a&ensp;prerequisite&ensp;for&ensp;using&ensp;the&ensp;simple&ensp;resource&ensp;plan&ensp;created&ensp;by&ensp;executing&ensp;the&ensp;above&ensp;code？（）

A、&ensp;You&ensp;must&ensp;assign&ensp;users&ensp;to&ensp;consumer&ensp;groups. B、&ensp;You&ensp;must&ensp;grant&ensp;the&ensp;switch&ensp;privilege&ensp;to&ensp;the&ensp;users. C、&ensp;You&ensp;must&ensp;create&ensp;a&ensp;resource&ensp;plan&ensp;directive. D、&ensp;You&ensp;must&ensp;specify&ensp;the&ensp;complex&ensp;resource&ensp;plan.

点击查看答案

账号：登录

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服