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