题目内容

有如下存储过程:DELIMITER //CREATE PROCEDURE CountProc1(IN s_gender VARCHAR(50),OUT num INT)BEGINSELECT COUNT(*) INTO num FROM student WHERE gender = s_gender;END //DELIMITER ;下面选项中,能对上述存储过程实现正确调用的是( )

A. CALL CountProc1(in "女",out @num);
B. SELECT CountProc1("女",@num);
C. DECLARE CountProc1("女",out @num);
D. CALL CountProc1("女",@num);

查看答案
更多问题

阅读下面SQL代码片段:DECLARE val;IF val IS NULLTHEN SELECT 'val is NULL';ELSE SELECT 'val is not NULL';END IF;下面选项中,关于运行结果的描述,正确的是()

A. 输出val is NULL
B. 输出val is not NULL
C. 语法错误
D. 运行时出现异常

下列用于声明一个存储过程Myproc语句,正确的是()

A. CREATE PROCEDURE Myproc () BEGIN SELECT * FROM student; END;
B. CREATE PROCEDURE Myproc () { SELECT * FROM student; }
CREATE PROCEDURE Myproc [] BEGIN SELECT * FROM student; END;
D. CREATE PROCEDURE Myproc { SELECT * FROM student; };

下列用于删除存储过程的SQL语句中,正确的是()。

A. DROP PROC CountProc1;
B. DELETE PROC CountProc1;
C. DROP PROCEDURE CountProc1;
DELETE PROCEDURE CountProc1;

国家信用的主要形式有( )。a、发行国家公债 b、发行国库券 c、发行专项债券 d、向银行透支或借款 e、发行金融债券

A. abc
B. abcd
C. abde
D. abcde

答案查题题库