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 binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
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
相关考题：
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.
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.
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.
ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQLDESCV$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.
Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?() A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.
Youexecutedthefollowingcommands：SQLALTERSESSIONSETOPTIMIZER_USE_PENDING_STATISTICS=false；SQLEXECUTEDBMS_STATS.SET_TABLE_PREFS（’SH’，’CUSTOMERS’，’PUBLISH’，’false’）；SQLEXECUTEDBMS_STATS.GATHER_TABLE_STATS（’SH’，’CUSTOMERS’）；WhichstatementiscorrectregardingtheabovestatisticscollectionontheSH.CUSTOMERStableintheabovesession？（）A.Thestatisticsarestoredinthependingstatisticstableinthedatadictionary.B.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforallsessions.C.Thestatisticsaretreatedasthecurrentstatisticsbytheoptimizerforthecurrentsessionsonly.D.Thestatisticsaretemporaryandusedbytheoptimizerforallsessionsuntilthissessionterminates.
Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?() A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.
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.
【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）A．Create_Table，Alter_Table，Drop_TableB．Create_View，Alter_View，Drop_ViewC．Create_Procedure，Alter_Procedure，Drop_ProcedureD．Rollback