登陆题目详情
单选题 删除存储过程的命令是( )
学科：数据库高级应用 v4.0
时间：2023-09-20 02:46:40
相关题目
相关作业
题目1单选题
创建存储过程的命令是( )A. create procedureB. create databaseC. create tableD. create function
题目2单选题
调用存储过程,需要用到( )关键词A. callB. selectC. showD. use
题目3单选题
删除存储过程的命令是( )A. drop databaseB. drop procedureC. drop tableD. drop function
题目4单选题
MySQL语句默认的结束符是( )A. B. &&C. //D.
题目5单选题
设置MySQL语句的结束符为&&,对应命令是( )A. delimiterB. delimiter //C. delimiter &&D. &&
题目6单选题
对于无参的存储过程sp_selectStu( ),下面调用存储过程的命令正确的是( )A. call sp_selectStu('张三')B. call sp_selectStu( )C. call sp_selectStuD. sp_selectStu('张三')
题目7单选题
异常处理代码:"declare continue handler for Not found set done=1;"表示要求程序在遇到某类错误(Not found)时,程序运行过程是( )A. 继续执行( continue)B. 设置局部变量done的值为1C. 以上都是
题目8填空题
【变量】根据代码,写出语句(SELECT @y;)运行结果是( ). -- 若存在存储过程sp_b,则删除DROP PROCEDURE IF EXISTS sp_b; -- 创建存储过程sp_b,根据姓名查询记录delimiter $$CREATE PROCEDURE sp_b(in i int,out j int)BEGIN DECLARE x int default 0; SET x=i; SET j=x+2;END $$delimiter ; -- 初始化用户变量SET @y=0; -- 调用存储过程sp_bCALL sp_b(1,@y); 查询用户变量SELECT @y题目9填空题
【常规处理】看代码,写出运行后表中有几条记录( )? -- 若存在表student,则删除DROP TABLE IF EXISTS student; -- 创建表student(学号id、姓名name、性别sex)CREATE TABLE student( id INT(10) PRIMARY KEY NOT NULL UNIQUE auto_increment, name VARCHAR(20) NOT NULL, sex CHAR(2))ENGINE=INNODB CHARACTER SET utf8; -- student表插入记录INSERT INTO student VALUE (1,'姚朗','男');INSERT INTO student VALUE (2,'陈雲磊','男'); -- 若存在存储过程sp_insert_student,则删除DROP PROCEDURE IF EXISTS sp_insert_student; 创建存储过程sp_insert_student,插入三条记录delimiter $$CREATE PROCEDURE sp_insert_student()BEGIN INSERT INTO student(id,name,sex) VALUE (3,'张三','男'); INSERT INTO student(id,name,sex) VALUE (3,'李四','女'); INSERT INTO student(id,name,sex) VALUE (5,'王五','男');END $$delimiter ; -- 调用存储过程CALL sp_insert_student(); -- 查看student记录SELECT * FROM student题目10填空题
【异常处理】看代码,写出运行后表中有几条记录( )? -- 若存在表student,则删除DROP TABLE IF EXISTS student; -- 创建表student(学号id、姓名name、性别sex)CREATE TABLE student( id INT(10) PRIMARY KEY NOT NULL UNIQUE auto_increment, name VARCHAR(20) NOT NULL, sex CHAR(2))ENGINE=INNODB CHARACTER SET utf8; -- student插入记录INSERT INTO student VALUE (1,'姚朗','男');INSERT INTO student VALUE (2,'陈雲磊','男'); -- 若存在存储过程sp_insert_student,则删除DROP PROCEDURE IF EXISTS sp_insert_student; -- 创建存储过程sp_insert_student,插入三条记录delimiter $$CREATE PROCEDURE sp_insert_student()BEGIN -- 处理错误,当遇到错误(主键重复),忽略当前错误,继续执行下一调命令,同时给@a赋值 DECLARE CONTINUE HANDLER FOR 1062 set @a='主键重复'; INSERT INTO student(id,name,sex) VALUE (3,'张三','男'); INSERT INTO student(id,name,sex) VALUE (3,'李四','女'); INSERT INTO student(id,name,sex) VALUE (5,'王五','男');END $$delimiter ; -- 调用存储过程CALL sp_insert_student(); -- 查看student记录SELECT * FROM student下载 题海APP
拍照搜题更快捷
- 海量题库
- 无搜索限制
- 快捷拍照搜题
