itgle.com

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table 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 t

题目

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table 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?（）

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

相似考题

1.You’ll be punished by law if you ________ your child.(A) use(B) abuse(C) used(D) abused

2.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario?（）A. The optimizer adds the new plan to the plan history.B. The optimizer selects the new plan for the execution of the SQL statement.C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

3.Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported 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.Youexecutethefollowingcommandtocreatetwoconsumergroups，FIN_GROUP1andPAY_GROUP1，foraplan，PROD_PLAN：BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’prod_plan’，CONSUMER_GROUP1=>’fin_group1’，GROUP1_CPU=>80，CONSUMER_GROUP2=>’pay_group1’，GROUP2_CPU=>20）ENDWhichthreestatementsaretrue？（）A.SYS_GROUPgets100%CPUresourcesatlevel1.B.FIN_GROUP1gets80%CPUresourcesatlevel1.C.FIN_GROUP1gets80%CPUresourcesatlevel2.D.PAY_GROUP1gets20%CPUresourcesatlevel1.E.PAY_GROUP1gets20%CPUresourcesatlevel2.F.OTHER_GROUPgets100%CPUresourcesatlevel1.G.OTHER_GROUPgets100%CPUresourcesatlevel2.

更多“You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other tabl ”相关问题

  • 第1题：

    ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQL>DESCV$FLASHBACK_DATABASE_STATNameNull？Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）

    A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.

    B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.

    C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.

    D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.

    E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.


    参考答案：C, D

  • 第2题：

    Youexecutedthefollowingcommands：SQL>ALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQL>EXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQL>EXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）

    A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.

    B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.

    C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.

    D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.


    参考答案：A

  • 第3题：

    Youexecutethefollowingcommandtocreatetwoconsumergroups，FIN_GROUP1andPAY_GROUP1foraplan，PROD_PLAN：BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’prod_plan’，CONSUMER_GROUP1=>’fin_group1’，GROUP1_CPU=>80，CONSUMER_GROUP2=>’pay_group1’，GROUP2_CPU=>20）；END；Whichthreestatementsaretrue？（）

    A.SYS_GROUPgets100%CPUresourcesatlevel1.

    B.FIN_GROUP1gets80%CPUresourcesatlevel1.

    C.FIN_GROUP1gets80%CPUresourcesatlevel2.

    D.PAY_GROUP1gets20%CPUresourcesatlevel1.

    E.PAY_GROUP1gets20%CPUresourcesatlevel2.

    F.OTHER_GROUPgets100%CPUresourcesatlevel1.

    G.OTHER_GROUPgets100%CPUresourcesatlevel2.


    参考答案：A, C, E

  • 第4题：

    Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()

    A.QuerytheV$FLASHBACK_DATABASE_LOGview.

    B.QuerytheV$FLASHBACK_DATABASE_STATview.

    C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.

    D.QuerytheV$RECOVERY_FILE_DESTview.


    参考答案：B

  • 第5题：

    Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?()

    A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.

    B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.

    C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.

    D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.


    参考答案：D

  • 第6题：

    【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）

    A．Create_Table，Alter_Table，Drop_Table

    B．Create_View，Alter_View，Drop_View

    C．Create_Procedure，Alter_Procedure，Drop_Procedure

    D．Rollback


    Rollback

相关内容