网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()

A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.

B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.

C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.

D. Either B or C

参考答案

更多 “ To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?() A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.D. Either B or C ” 相关考题
考题 （36）为了考虑安全性，每个部门的领导只能存取本部门员工的档案，为此DBA应创建相应的（ ）。A）视图（view）B）索引（index）C）游标（cursor）D）表（table）
查看答案
考题 YouacceptedtherecommendedSQLProfilebyexecutingthefollowingcode：DECLAREsqlprofile_namevarchar2（30）；BEGINsqlprofile_name：=DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（task_name=’my_task’，profile_name=’my_profile’）；END；Whichadvisorwillanalyzethisprofile？（）A.SQLAccessAdvisorB.UndoAdvisorC.SegmentAdvisorD.SQLTuningAdvisor
查看答案
考题 Examine the commands executed to monitor database operations:$ conn sys oracle/oracle@prod as sysdbaSQL VAR eid NUMBERSQL EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING = ‘Y’);Which two statements are true?（）A. Database operations will be monitored only when they consume a significant amount of resource.B. Database operations for all sessions will be monitored.C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.D. Only DML and DDL statements will be monitored for the session.E. All subsequent statements in the session will be treated as one database operation and will be monitored.
查看答案
考题 Evaluatethefollowingcode：SQLVARIABLEtask_nameVARCHAR2（255）；SQLVARIABLEsql_stmtVARCHAR2（4000）；SQLBEGIN：sql_stmt：=’SELECTCOUNT（*）FROMcustomersWHEREcust_state_province=’’CA’’’；：task_name：=’MY_QUICKTUNE_TASK’；DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，：task_name，：sql_stmt）；END；Whatistheoutcomeofthisblockofcode？（）A.Itcreatesataskandworkload，andexecutesthetask.B.Itcreatesataskandworkloadbutdoesnotexecutethetask.C.Itproducesanerrorbecauseatemplatehasnotbeencreated.D.ItproducesanerrorbecausetheSQLTuningSethasnotbeencreated.
查看答案
考题 A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
查看答案
考题 当创建了过程,可以在SQL*Plus中使用()执行之。 A.exec函数B.SETC.COMMITD.TAKE
查看答案
考题 (36）为了考虑安全性，每个部门的领导只能存取本部门员工的档案，为此DBA 应创建相应的A）表( table)B）索引（index）C）视图( view)D）游标（cursor )
查看答案
考题 （ 22 ）如果只允许学生查看自己所选课程的信息和分数，则 DBA 应创建相应的A ）视图（ View ）B ）索引（ Index ）C) 游标（ Cursor ）D ）基本表（ Table ）
查看答案
考题 (23 ）为了提高查询速度，则 DBA 应创建相应的A ）视图（ View ）B ）索引（ Index ）C) 游标（ Cursor ）D) 基本表（ Table ）
查看答案
考题 在ggplot2中，自定义散点图中点的颜色所用的命令为（）A．scale_colour_manual()B．scale_linetype_manual()C．scale_shape_manual()D．scale_size_manual()
查看答案
热门标签
最新试卷