gs gs117 SQL: Queries, Constraints and Triggers - Functions and Procedures - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL: Queries, Constraints and Triggers. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Create function dept count(dept_name varchar(20)) begin declare d count integer; select count(*) into d count from instructor where instructor.dept_name= dept_name return d count; end Find the error in the the above statement.
Select dept name, budget from instructor where dept count() > 12; Select dept name, budget from instructor where dept count(dept name) > 12; Select dept name, budget where dept count(dept name) > 12; Select dept name, budget from instructor where dept count(budget) > 12;Create procedure dept_count proc(in dept name varchar(20), out d count integer) begin select count(*) into d count from instructor where instructor.dept name= dept count proc.dept name end Which of the following is used to call the procedure given above ?
Declare d_count integer; Declare d_count integer; call dept_count proc(’Physics’, d_count); Declare d_count integer; call dept_count proc(’Physics’); Declare d_count; call dept_count proc(’Physics’, d_count);Repeat sequence of statements; __________________ end repeatFill in the correct option :
If boolean expression then statement or compound statement elseif boolean expression then statement or compound statement else statement or compound statement end ifIf boolean expression then statement or compound statement elsif boolean expression then statement or compound statement else statement or compound statement end ifIf boolean expression then statement or compound statement elif boolean expression then statement or compound statement else statement or compound statement end ifIf boolean expression then statement or compound statement else statement or compound statement else statement or compound statement end if declare exit handler for out of classroom seats begin sequence of statements endThe above statements are used for
Online Quizzes of gs117 Database Management System
