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.


相关考题: