Youexecutedthefollowingqueryinyourdatabase:FROMV$FLASHBACK_DATABASE_LOGWhatwouldyoudeterminefromtheoutput?() A.thetimewhenthelastflashbackoperationinyourdatabasewasperformedB.thetimewhenthefirstflashbackoperationinyourdatabasewasperformedC.alistofflashbackoperationsperformedinyourdatabaseusingSCNandtimeD.theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase

Youexecutedthefollowingqueryinyourdatabase:FROMV$FLASHBACK_DATABASE_LOGWhatwouldyoudeterminefromtheoutput?()

A.thetimewhenthelastflashbackoperationinyourdatabasewasperformed

B.thetimewhenthefirstflashbackoperationinyourdatabasewasperformed

C.alistofflashbackoperationsperformedinyourdatabaseusingSCNandtime

D.theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase


相关考题:

AdatabaseuserSMITHtriestoquerytheV$SESSIONviewandfailstoaccessitasfollows:SQLconnectsmith/smithConnected.SQLSELECT*FROMv$session;SELECT*FROMv$session*ERRORatline1:ORA-00942:tableorviewdoesnotexistWhicharethetwopossiblesolutionstoenableSMITHtoquerythedatainV$SESSION()A.grantingSELECTprivilegetoSMITHonV$SESSIONB.grantingSELECTprivilegetoSMITHonV_$SESSIONC.askingtheuserSMITHtorunthecatalog.sqlscriptD.grantingSELECTprivilegetoSMITHonV$FIXED_TABLESE.settingtheO7_DICTIONARY_ACCESSIBILITYparametertoTRUEF.creatingaviewbasedonV$SESSIONandgrantingSELECTprivilegetoSMITHontheviewthatwascreated

Afterexecutingthecommandalterdiskgroupdiskgroup2dropdiskdg2a;youissuethefollowingcommandfromtheASMinstance:Selectgroup_number,count(*)fromv$asm_operation;WhatistheimplicationifthequeryagainstV$ASM_OPERATIONreturnszerorows?()A.Thedropdiskoperationisstillproceedingandyoucannotyetruntheundropdisksoperation.B.Thedropdiskoperationiscompleteandyoucanruntheundropdiskscommandifneeded.C.Thedropdiskoperationiscompleteandyoucannotruntheundropdiskcommand.D.ThequerywillfailsincethereisnotaV$ASM_OPERATIONviewavailableinanASMinstance.E.Noneoftheaboveistrue.

Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?() A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.D.Theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase.

在oracle数据库里面检查审计配置命令的是() A.Show parameter REMOTE_LOGIN_PASSWORDFILEB.select * from v$versionC.show parameter 07_dictionary_accessibilityD.show parameter audit_trail

Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?()A.0B.1C.2D.3

当需要查询日志文件所有组及其成员的名称和文件位置,可以使用()方式。 A.SELECT * FROM V$LOGFILEB.SELECT * FROM V$LOGC.SELECT * FROM V$LOGHISTORYD.SELECT * FROM V$DBA

11、已经创建了如下视图,那么要查询所有男生姓名的最简洁SQL语句是________。 CREATE VIEW V_StSexMale AS SELECT StCode As 姓名, StName As 姓名, ClsCode As 班号, Sex As 性别 FROM Student WHERE Sex='男'A.Select StName, Sex From V_StSexMale Where Sex='男'B.Select StName, Sex From V_StSexMaleC.Select 姓名, 性别 From V_StSexMale Where Sex='男'D.Select 姓名, 性别 From V_StSexMale

要查询v_fstu视图中所有数据信息的SQL语句是()。A.SELECT * from v_fstu;B.SELECT * from view v_fstu;C.SELECT * from view where v_fstu;D.SELECT * where view=v_fstu;

查询视图v_stu中的数据,正确的是()。A.SELECT * FROM VIEW v_stuB.SELECT * VIEW v_stuC.SELECT * FROM v_stuD.SELECT * FROM v_stu AS VIEW