【C3】
A.outside
B.through
C.across
D.about
第1题
A. Another repair session is running concurrently.
B. The failure ID has not been mentioned in the command for data file 5.
C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
第2题
A.Youwillneedtoopenthedatabasewiththeresetlogscommand.
B.AllyouneedtodoisexecutethetracefilefromSQL*Plusanditwillperformtherecoveryforyou.
C.Youwillusetheresetlogsversionofthecreatecontrolfilecommand.
D.Youwillusethenoresetlogsversionofthecreatecontrolfilecommand.
E.Youwillusethetracefiletocreateabackupcontrolfile,andthenyouwillrecoverthedatabasewiththerecoverdatabaseusingbackupcontrolfilecommand
第3题
A.Alpha a = x;
B.Foo f = (Delta)x;
C.Foo f = (Alpha)x;
D.Beta b = (Beta)(Alpha)x;
第4题
1:ORA-01110:datafile4:,,/oracle01/oradata/orcl/users01.dbfORA-27041:01116:errorinopeningdatabasefile4ORA-unabletoopenfileLinuxError:
2:NosuchfileordirectoryAdditionalinformation:
3Youcanchoosefromthefollowingsteps:
a.Restorethemissingdatabasedatafiles.
b.Takethemissingdatafileoffline.
c.Shutdownthedatabase.
d.IssuetherecovertablespaceUSERScommand.
e.IssuetheStartupMountcommandtomountthedatabase.
f.BringtheUSERStablespaceonline.
g.Issuethealterdatabaseopencommand.
Whichisthecorrectorderofthesestepsinthiscase?()
第5题
A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.
B.Thedatabaseisopenedinrestrictedmode,soqueriesarenotallowed.
C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.
D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.
E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisreadonly.
第6题
A. It executes successfully but partition pruning cannot happen for this partition key.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
第7题
A.Thedatabaseopensnormally.
B.Thedatabasepromptsforadatabaserecovery.
C.Thedatabasewriterwritestoatracefile,indicatingthatthetemporaryfileisnotfound.
D.Thedatabasegetsmountedandthrowsanerrorindicatingthatthetemporaryfilerequiresrecovery.
第8题
A.00
B.0001
C.000120
D.00012021
E.Compilation fails.
F.An exception is thrown at runtime.
第9题
A.Itwouldresultinanerrorbecausethewarningthresholdcannotbemorethanthecriticalthreshold.
B.Thewarningthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthecriticalthreshold.
C.Thecriticalthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthewarningthreshold.
D.Boththresholdvaluesareusedandalertsaregeneratedwhenspaceusageexceedstherespectivethresholdvalues.
第10题
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!