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

[主观题]

YouacceptedtherecommendedSQLProfilebyexecutingthefollowingcode：DECLAREsqlprofile_namevarch

ar2（30）；BEGINsqlprofile_name：=DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（task_name=＞’my_task’，profile_name=＞’my_profile’）；END；Whichadvisorwillanalyzethisprofile？（）

A.SQLAccessAdvisor

B.UndoAdvisor

C.SegmentAdvisor

D.SQLTuningAdvisor

查看答案

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

您可能会需要：

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

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

更多“YouacceptedtherecommendedSQLPr…”相关的问题

第1题

YouaremaintainingtheSALESdatabaseforeSoftCorporation.YouhavenotconfiguredASMMonthedatabase

.YouwanttoknowwhatsizeoftheSGAwillprovidethebestperformance.WhichadvisorwouldyouusetodeterminethesuitablesizeoftheSGA？（）

A.SQLTuningAdvisor

B.UndoAdvisor

C.ADDM

D.MemoryAdvisor

点击查看答案

第2题

WhichtwooperationscanbeflashedbackusingtheFlashbacktechnology？（）

A.DROPUSERSMITH；

B.DROPTABLEEMPLOYEES；

C.DROPTABLESPACEUSERS；

D.ALTERTABLESALES_REPDROPPARTITIONP1；

E.ALTERTABLEEMPLOYEESDROPCOLUMNDESIG_ID；

点击查看答案

第3题

YoufindpocketsofemptyspaceintheUSER_DATAtablespaceduetoalotofDMLoperationsontheobjectsinth

eUSER_DATAtablespace.Thepocketsofemptyspacesaretoosmalltobereusedindividually.Thisisleadingtowastageofspace.Youdecidetoperformtheshrinkoperationtoreclaimthewastedspace.WhichadvisorwillyouusetodeterminetheobjectsintheUSER_DATAtablespacethataregoodcandidatesfortheshrinkoperation？（）

A.SQLTuningAdvisor

B.SQLAccessAdvisor

C.UndoAdvisor

D.SegmentAdvisor

点击查看答案

第4题

The EMPLOYEES table has these columns:Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:What is true about your ALTER statement?（）

A. Column definitions cannot be altered to add DEFAULT values.

B. A change to the DEFAULT value affects only subsequent insertions to the table.

C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.

D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

点击查看答案

第5题

Youfindthatsomequeriesonatablearetakingalongtimetoexecutebecausetherearenoindexescreatedon

thetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor？（）

A.DBMS_SERVER_ALERT

B.DBMS_ADVISOR

C.DBMS_RESOURCE_MANAGER

D.DBMS_REPAIR

点击查看答案

第6题

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuratio

n. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation? （）(Choose two.)

A. The databases configured to use the ASM instance are mounted

B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

点击查看答案

第7题

WhichcomponentdoestheSQLTuningAdvisorNOTanalyzefortheSQLstatements？（）

A.ADDM

B.AWR

C.CursorCache

D.SQLTuningSets

E.FlashRecoveryArea

点击查看答案

第8题

YouneedtogeneratealistofallcustomerlastnameswiththeircreditlimitsfromtheCUSTOMERStable.Thosecustomerswhodonothaveacreditlimitshouldappearlastinthelist.Whichtwoquerieswouldachievetherequiredresult?（）

A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESC

B.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limit

C.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLAST

D.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST

点击查看答案

第9题

Whilerunninglongrunningqueries，youreceivetheSnapshottooolderror.WhichadvisorcanhelpyoutoavoidtheSnapshottooolderror？（）

A.MemoryAdvisor

B.SegmentAdvisor

C.UndoAdvisor

D.SQLTuningAdvisor

点击查看答案