在mysql服务器上,存储过程是一组预先定义并( )的sql语句,可以用( )定义存储过程。
A. 编写、CREATE PROCEDURE
B. 编译、CREATE PROCEDURE
C. 解释、ALTER PROCEDURE
D. 编写、ALTER PROCEDURE
查看答案
下面选项中,用于定义存储过程中变量的关键字是()
A. DELIMITER
B. DECLARE
C. SET DELIMITER
D. SET DECLARE
下面选项中,用于在删除存储过程时,检测存储过程是否存在的关键字是
A. IF EXISTS
B. HAS EXISTS
C. AS EXISTS
D. IS EXISTS
下面声明一个名为cursor_student的游标,语法格式正确的是
A. CURSOR cursor_student OF select s_name,s_gender FROM student;
B. CURSOR cursor_student FOR select s_name,s_gender FROM student;
C. DECLARE cursor_student CURSOR FOR select s_name,s_gender FROM student;
DECLARE cursor_student CURSOR OF select s_name,s_gender FROM student;
MySQL中,预设的拥有最高权限的超级用户的用户名为()
A. test
B. administrator
C. DBA
D. root
微信支付 
支付宝支付