AuserexecutesaqueryontheEMPtable,whichcontainsthousandsofrows,togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror:SQLSELECTenameFROMempWHEREdeptno=10ORDERBYsalSELECTenameFROMempWHEREdeptno=10ORDERBYsal*ERRORatline1:ORA01157:cannotidentify/lockdatafile201seeDBWRtracefileORA01110:datafile201:’/u01/app/oracle/oradata/orcl/temp01.dbf’Whatisapossiblereason?()A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.B.Thedatabaseisopenedinrestrictedmode,soqueriesarenotallowed.C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisreadonly.
AuserexecutesaqueryontheEMPtable,whichcontainsthousandsofrows,togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror:SQL>SELECTenameFROMempWHEREdeptno=10ORDERBYsalSELECTenameFROMempWHEREdeptno=10ORDERBYsal*ERRORatline1:ORA01157:cannotidentify/lockdatafile201seeDBWRtracefileORA01110:datafile201:’/u01/app/oracle/oradata/orcl/temp01.dbf’Whatisapossiblereason?()
A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.
B.Thedatabaseisopenedinrestrictedmode,soqueriesarenotallowed.
C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.
D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.
E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisreadonly.