网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
AdatabaseuserSMITHtriestoquerytheV$SESSIONviewandfailstoaccessitasfollows：SQL>connectsmith/smithConnected.SQL>SELECT*FROMv$session；SELECT*FROMv$session*ERRORatline1：ORA-00942：tableorviewdoesnotexistWhicharethetwopossiblesolutionstoenableSMITHtoquerythedatainV$SESSION（）
A.grantingSELECTprivilegetoSMITHonV$SESSION
B.grantingSELECTprivilegetoSMITHonV_$SESSION
C.askingtheuserSMITHtorunthecatalog.sqlscript
D.grantingSELECTprivilegetoSMITHonV$FIXED_TABLES
E.settingtheO7_DICTIONARY_ACCESSIBILITYparametertoTRUE
F.creatingaviewbasedonV$SESSIONandgrantingSELECTprivilegetoSMITHontheviewthatwascreated
参考答案
更多 “ 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 ” 相关考题
热门标签
最新试卷