题目内容

视频中是什么产品的广告?

A. 好吃的坚果
B. 汽车手刹
C. 保护小动物
D. 纯属搞笑

查看答案
更多问题

有如下存储过程: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; };

答案查题题库