AuserexecutesaqueryontheEMPtable,whichcontainsthousandsofrows,togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror:SQL>SELECTenameFROMempWHEREdeptno=10ORDERBYsalSELECTenameFROMempWHEREdeptno=10ORDERBYsal*ERRORatline1:ORA01157:c

题目

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.


相似考题