Youexecutedthefollowingqueryinyourdatabase:FROMV$FLASHBACK_DATABASE_LOGWhatwouldyoudeterminefromtheoutput?()A.thetimewhenthelastflashbackoperationinyourdatabasewasperformedB.thetimewhenthefirstflashbackoperationinyourdatabasewasperformedC.alistofflashback

题目
Youexecutedthefollowingqueryinyourdatabase:FROMV$FLASHBACK_DATABASE_LOGWhatwouldyoudeterminefromtheoutput?()

A.thetimewhenthelastflashbackoperationinyourdatabasewasperformed

B.thetimewhenthefirstflashbackoperationinyourdatabasewasperformed

C.alistofflashbackoperationsperformedinyourdatabaseusingSCNandtime

D.theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase

相似考题

1.AdatabaseuserSMITHtriestoquerytheV$SESSIONviewandfailstoaccessitasfollows：SQL>connectsmith/smithConnected.SQL>SELECT*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

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

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

4.Afterexecutingthecommandalterdiskgroupdiskgroup2dropdiskdg2a；youissuethefollowingcommandfromtheASMinstance：Selectgroup_number，count（*）fromv$asm_operation；WhatistheimplicationifthequeryagainstV$ASM_OPERATIONreturnszerorows？（）A.Thedropdiskoperationisstillproceedingandyoucannotyetruntheundropdisksoperation.B.Thedropdiskoperationiscompleteandyoucanruntheundropdiskscommandifneeded.C.Thedropdiskoperationiscompleteandyoucannotruntheundropdiskcommand.D.ThequerywillfailsincethereisnotaV$ASM_OPERATIONviewavailableinanASMinstance.E.Noneoftheaboveistrue.

参考答案和解析
参考答案：D
更多“Youexecutedthefollowingqueryinyourdatabase:FROMV$FLASHBACK_DATABASE_LOGWhatwouldyoudeterminefromtheoutput?() ”相关问题

  • 第1题：

    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.0

    B.1

    C.2

    D.3


    参考答案：C

  • 第2题：

    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_StSexMale

    C．Select 姓名, 性别 From V_StSexMale Where Sex='男'

    D．Select 姓名, 性别 From V_StSexMale


    1 添加数据源 2 选择查询类型 3 选择输出字段 4 记录筛选 5 其它

  • 第3题：

    查询视图v_stu中的数据，正确的是（）。

    A．SELECT * FROM VIEW v_stu

    B．SELECT * VIEW v_stu

    C．SELECT * FROM v_stu

    D．SELECT * FROM v_stu AS VIEW


    SELECT * FROM v_stu

  • 第4题：

    当需要查询日志文件所有组及其成员的名称和文件位置,可以使用()方式。

    A.SELECT * FROM V$LOGFILE

    B.SELECT * FROM V$LOG

    C.SELECT * FROM V$LOGHISTORY

    D.SELECT * FROM V$DBA


    参考答案：A

  • 第5题：

    要查询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;


    SELECT * from v_fstu;

相关内容