有如下存储过程:CREATE PROCEDURE up_studentInfo( )BEGINSELECT * FROM student WHERE birthday < '1998-1-1';END下面选项中,能对上述存储过程实现正确调用的是( )
A. SELECT up_studentInfo;
B. CALL up_studentInfo( )
CALL up_studentInfo;
D. SELECT up_studentInfo( );
有如下存储过程: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; };