题目内容（请给出正确答案）

[主观题]

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

A. the SQL text SQL

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“You plan to use SQL Performanc…”相关的问题

第1题

You perform the following activities during the database upgrade from Oracle Database 10g

to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities？（）

A. to minimize plan regression due to the use of a new optimizer version

B. to completely avoid the use of new plans generated by a new optimizer version

C. to prevent plan capturing when the SQL statement is executed after the database upgrade

D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

点击查看答案

第2题

You are planning the creation of a new multitenant container database （CDB) and want to st

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this？（）

A. Use Oracle Managed Files (OMF).

B. Specify the SEED FILE_NAME_CONVERT clause.

C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

D. Specify the DB_FILE_NAMECONVERT initialization parameter.

E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

点击查看答案

第3题

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You importe

d SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.What would you do with these SQL statements？（）

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

B. Capture the plans from the previous version using STS and then load them into the stored outline.

C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

点击查看答案

第4题

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other tabl

e with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL＞ FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement？（）

You plan to use Flashback Drop feature to recover

A. It retrieves the latest version of the table from the recycle bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

点击查看答案

第5题

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One

server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.

You are the administrator of three SQL Server 2000

You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.

Which two actions should you take？ (Each correct answer presents part of the solution. Choose two)

A．Set the database load state for each destination server to No recovery mode.

B．Set the database load state for each destination server to standby mode.

C．Enable the allow database to assume primary role option for both destination servers.

D．Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.

E．Disable the allow database to assume primary role option for both destination servers.

点击查看答案

第6题

You run the SQL Tuning Advisor （STA) to tune a SQL statement that is part of a fixed SQL p

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.

点击查看答案

第7题

The____ is the main tool that you will use to property prepare for a meeting.

A、agenda

B、plan

C、program

D、procedure

点击查看答案

第8题

You want to analyze a SQL Tuning Set （STS) using SQL Performance Analyzer in a test databa

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

A.Every SQL statement in the STS is considered only once for execution

B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics

C.The execution plan and execution statistics are computed for each SQL statement in the STS

D.The effects of DDL and DML are considered to produce the execution plan and execution statistics

点击查看答案

第9题

Your network contains a server that runs Windows Server 2008 R2.You plan to create a custo

m script.You need to ensure that each time the script runs, an entry is added to the Application event log.Which tool should you use？（）

A.Eventcreate

B.Eventvwr

C.Wecutil

D.Wevtutil

点击查看答案

第10题

View the Exhibit and examine the steps that you executed to create a database resource pla

n. Subsequently, you execute the following procedure which results in an error:SQL＞ EXECUTE dbms_resources_manager.validate_pending_area ();What could be the reason？（）

View the Exhibit and examine the steps that you ex