单项选择题

Whichcommandwillresultinatracefilebeingcreatedwiththecr……

Whichcommandwillresultinatracefilebeingcreatedwiththecreatecontrolfilecommandcontainedinit？（）

A.alterdatabasebackupcontrolfile
B.alterdatabasebackupcontrolfiletotrace
C.alterdatabasecontrolfilebackup
D.alterdatabasecontrolfilebackupto’/ora01/oracle/ctrl_backup.ctl’
E.alterdatabasebegincontrolfilebackup

<上一题目录下一题>

热门试题

单项选择题（）个变量的地址称为该变量的“指针”。

A.1
B.2
C.3
D.4

单项选择题Becauseofhardwarefailure，youdecidedtodroparedologmemberfromthedatabase.Whichconditionshouldbemettodroparedologfile？（）

A.Theredologfileshouldbelongtoanactivegroup.
B.Theredologfileshouldbelongtoaninactivegroup.
C.Theredologfileshouldbelongtothecurrentgroup.
D.Theredologfilecanbedroppedonlyifallthetransactionsarestopped.
E.Beforearedologfileisdropped，itshouldbedeletedfromtheoperatingsystem（OS）.

单项选择题WhatdoestheFastConnectionFailoverfeatureofActiveGridLinkforRACprovide?（）

A.instantnotificationofaRACnodefailuresoapplicationsneverhavetoretryatransactionthatwassenttoanodethatfailedduringthetransaction
B.near-instantnotificationofthefailureofaRACnodefailurethatminimizesthepossibilityconnectiontoafailednodebeingprovidedtoanapplication
C.applicationlevelnotificationofafailedRACnodesuchthatanapplicationcanretryatransactionifrequired
D.fasterfailoverforMultiDatasources
E.guaranteedtransactionhighavailabilitywheninteractingwithanOracleRACDatabase

单项选择题YouobservethatinyourPRODdatabase，customerinformationisbeingmodifiedbysomeunauthorizedusers.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL SQL.WhichtypeofPL SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）A.functionsB.packagesC.proceduresD.databasetriggersE.anonymousPL SQLblock

A.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL/SQL.WhichtypeofPL/SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）
A.functions
B.packages
C.procedures
D.databasetriggers
E.anonymousPL/SQLblock

单项选择题Evaluatethefollowingfunctioncode：CREATEFUNCTIONget_dept_avg（dept_idNUMBER）RETURNNUMBERRESULT_CACHERELIES_ON（EMPLOYEES）ISavgsalNUMBER（6）；BEGINSELECTAVG（SALARY）INTOavgsalFROMEMPLOYEESWHEREDEPARTMENT_ID=dept_id；RETURNavgsal；ENDget_dept_avg；Whichstatementistrueregardingtheabovefunction？（）A.ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.B.Ifthefunctionexecutionresultsinanunhandledexception，theexceptionresultisalsostoredinthecache.C.Eachtimethefunctionisinvokedinadifferentsession，thecurrentresultintheresultcachegetsoverwritten.D.Ifthefunctionisinvokedwithadifferentparametervalue，theexistingresultintheresultcache getsoverwrittenbythelatestvalue.

A.ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.
B.Ifthefunctionexecutionresultsinanunhandledexception，theexceptionresultisalsostoredinthecache.
C.Eachtimethefunctionisinvokedinadifferentsession，thecurrentresultintheresultcachegetsoverwritten.
D.Ifthefunctionisinvokedwithadifferentparametervalue，theexistingresultintheresultcache