29、DECLARE只能用于BEGIN…END的开头部分定义局部变量,其作用范围只能在该BEGIN…END中。
29、DECLARE只能用于BEGIN…END的开头部分定义局部变量,其作用范围只能在该BEGIN…END中。
参考答案和解析
正确
相关考题:
program exam(output); var x,y,x:integer; proedure silly(x:integer;vary:integer); begin x:=5;y:=6;z:=3; writeln(x,y,z) end; begin x:=1;y:=2;z:=3; silly(x,y); writeln(x,y,z) end. 以上程序运行结果为(). A567 563B567 567C567 167D567 163
有程序段 for i:=1 to 10 do begin j:=i mod 4; case j of 0:x:‘a‘; 1:x:=‘b‘; 2:x:=‘c‘; 3:x:=‘d‘ end; end; for i:=1 to 10 do write(x:1); writeln; 输出应为( )。 AbcdabcdabcBabcdabcdabCcdabcdabcdDdabcdabcda
Which traversal method for a binary tree does the following Pascal code illustrate? Procedure traverse(p:pointer); Begin IfpNIL Then begin Traverse (p^.left); Process(p); Traverse(p^.right) End; End_A.pre_orderB.middle_orderC.noneD.last_order
ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT:SQLDESCV$FLASHBACK_DATABASE_STATNameNull?Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue?()A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.
下面的算法是计算不带节点的单链表长度,其中能正确执行的是______。A.Function Length(L:Link) integer begin p:=L; j:=0; while p↑.next≠NIL DO [p:=p↑.next; j:=j+1 ] return(j) end;B.Function Length(L:Link) integer begin p:=L; k:=0; while p≠NIL DO [p:=p↑.next; k:=k+1) return(k) end;C.Function Length(L:Link)integer begin p:=L;k:=0; repeat k:=k+1; p=p↑.next until p=NIL return(k-1) end;D.Function Length(L:Link)integer begin p:=L↑.next; k:=1; while p≠NIL DO [k:=k+1; p:=p↑.next] return(k) end;
请看以下存储过程beginbegin语句1exceptionwhen othersdbms_output.put_line('错误1');end;begin语句2dbms_output.putline('错误2');end;exceptionwhen others thendbms_output.put_line("错误3");end;请问,当语句1,语句2出错时,该存储过程输出字符串分别是什么?
属于事务控制的语句是()。A.Begin Tran、Commit、RollBackB.Begin、Continue、EndC.Create Tran、Commit、RollBackD.Begin Tran、Continue、End
完成以下PL/SQL块,功能是:显示2 到50的25个偶数。 BEGIN FOR________ IN _________ LOOP DBMS_OUTPUT.PUT_LINE(even_number*2); END LOOP END;
Which traversal method for a binary tree does the following Pascal code illustrate? procedure traverse (p:pointer); begin if pnil then begin traverse(p ↑ .left); process(p); traverse(p ↑ .right); end end;A.preorderB.postorderC.reorderD.inorder
设计下列伪程序的语句覆盖测试用例。 BEGIN INPUT(A,B,C) IF A5 THEN X=10 ELSE X=1 END IF IF B10 THEN Y=20 ELSE Y=2 END IF IF C15 THEN Z=30 ELSE Z=3 END IF PRINT(X,Y,Z) END
在下面给出的PL/SQL代码块中,()行代码会导致失败。 1DECLARE 2vNumNUMBER:-100; 3BEGIN 4vNum-vNum/10; 5END;A、1B、2C、3D、4E、5F、全部语句都能够成功执行
在Web页面中加入VBScript代码,其代码必须放在()A、 Script和End Script标记之间B、Begin Script和End Script标记之间C、\Script和/Script标记之间D、Script和/Script标记之间
属于事务控制的语句是()。A、Begin Tran、Commit、RollBackB、Begin、Continue、EndC、Create Tran、Commit、RollBackD、Begin Tran、Continue、End
属于事务控制的语句是()。A、BeginTran、Commit、RollBackB、Begin、Continue、EndC、CreateTran、Commit、RollBackD、BeginTran、Continue、End
You accepted the recommended SQL Profile by executing the following code: DECLARE sqlprofile_name varchar2(30); BEGIN sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE( task_name = ’my_task’, profile_name = ’my_profile’); END; Which advisor will analyze this profile?() A、 SQL Access AdvisorB、 Undo AdvisorC、 Segment AdvisorD、 SQL Tuning Advisor
Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?()A、current redo log and inactive redo logB、checkpoint position to end of redo logC、beginning of redo log to end of redo logD、all redo logs before the point of last commitE、beginning of redo log to checkpoint position
单选题关于局部变量的作用域,下列说法不正确的是()A主方法中定义的变量只能在主方法中使用,不能在其他方法中使用。B形参变量是属于被调方法的局部变量,而实参变量一般是属于主调方法的局部变量。C不允许在不同的方法中使用相同的变量名。D在复合语句中也可以定义变量,其作用域只在复合语句范围内。
单选题Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end? ()Acurrent redo log and inactive redo logBcheckpoint position to end of redo logCbeginning of redo log to end of redo logDall redo logs before the point of last commitEbeginning of redo log to checkpoint position
单选题You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY BEGIN TRANSACTION DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY BEGIN CATCH DECLARE @ErrorMessage nvarchar(2000) DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE(),@ErrorSeverity=ERROR SEVERITY(),@ErrorState = ERROR STATE() RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState) END CATCH; You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do?()AAdd a COMMIT TRANSACTION command to the CATCH block.BRemove the COMMIT TRANSACTION command from the TRY block.CAdd a ROLLBACK TRANSACTION command to the CATCH block.DAdd a ROLLBACK TRANSACTION command to the TRY block.
问答题设计下列伪程序的语句覆盖测试用例。 BEGIN INPUT(A,B,C) IF A5 THEN X=10 ELSE X=1 END IF IF B10 THEN Y=20 ELSE Y=2 END IF IF C15 THEN Z=30 ELSE Z=3 END IF PRINT(X,Y,Z) END
问答题Suppose you begin reading a book on page h and end on page k . If the pages are numbered and read consecutively, then how many pages have you read?
在Oracle 中,下列语句中哪些可以合法地创建一个函数? (1.0分) [多选] A. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS DECLARE dis_cd CHAR(15);BEGIN .. END; B. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS dis_cd CHAR(15);BEGIN .. END; C. CREATE FUNCTION func_name(cdcode NUMBER) ISBEGIN .. END; D. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR ISBEGIN .. END; E. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS DECLARE dis_cd STRING (15);BEGIN .. END;