违法和不良信息举报 联系客服
免费注册 登录

You accepted the recommended SQL Profile by executing the fo

题目
单选题
You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）
A

 SQL Access Advisor

B

 Undo Advisor

C

 Segment Advisor

D

 SQL Tuning Advisor

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

A. The tuned plan is not added to the SQL plan baseline.

B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.


参考答案：C

第2题：

A user in your company has a laptop， which he uses both， on and off the network. You want to change the users profile to roaming but when you attempt to change the setting， the Roaming profile option is grayed out. How can you change the laptop users profile to roaming？（）

  • A、In Control Panel， System， User Profiles Tab， change profile to roaming.
  • B、Have him log back into the network.
  • C、Change the Profile to a Mandatory User Profile.
  • D、Change the profile to a Mandatory Roaming Profile.

正确答案:B

第3题：

You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）

A.

B.

C.

D.


参考答案：B

第4题：

You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）

  • A、The command produces an error.
  • B、The profile is dropped and current user sessions use the DEFAULT profile immediately.
  • C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
  • D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.

正确答案:A

第5题：

What happens when you run the SQL Tuning Advisor with limited scope？（）  

  • A、 Access path analysis is not performed for SQL statements.
  • B、 SQL structure analysis is not performed for SQL statements.
  • C、 SQL Profile recommendations are not generated for SQL statements.
  • D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

正确答案:B

第6题：

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?()

A. Parallel compilation of only the stored PL/SQL code

B. Sequential recompilation of only the stored PL/SQL code

C. Parallel recompilation of any stored PL/SQL code

D. Sequential recompilation of any stored PL/SQL code

E. Parallel recompilation of Java code

F. Sequential recompilation of Java code


参考答案：C, E

第7题：

You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）  

  • A、 SQL Access Advisor
  • B、 Undo Advisor
  • C、 Segment Advisor
  • D、 SQL Tuning Advisor

正确答案:D

第8题：

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()

A. Accept the recommended SQL profile.

B.Collect statistics for the related objects.

C. Run the Access Advisor for the SQL statement.

D. Run the Segment Advisor for recommendations.


参考答案：C

第9题：

What happens when you run the SQL Tuning Advisor with limited scope?（）

  • A、Access path analysis is not performed for SQL statements.
  • B、SQL structure analysis is not performed for SQL statements.
  • C、SQL Profile recommendations are not generated for SQL statements.
  • D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

正确答案:B,C

第10题：

You share your portable computer with a co-worker. You use separate user accounts to log on. A wireless network is available to you and your co-worker.  You need to prevent your co-worker from modifying your wireless network profile.  What should you do？（）

  • A、Disable the Connect even if the network is not broadcasting option.
  • B、In the Network and Sharing Center window， click the Diagnose and repair option.
  • C、Set the default wireless profile type to the Use all-users only profile （recommended） option. Recreate the wireless network.
  • D、Set the default wireless profile type to the Use all-users and per-user profiles option. Recreate the wireless network by using the Save this network for me only option.

正确答案:D

更多相关问题
相关内容