gs gs115 SQL Subqueries - SQL Comments - Quiz No.1
gs gs115 Structured Query Language Quiz
This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL Subqueries. 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.
Question 1: Which of the following correctly defines a stored procedure in SQL?
A prepared SQL code which cannot be saved
A code that cannot be reused again
A code that can be saved and reused over and over again
A code that can be stored but cannot be reused
Question 2: If we have an SQL query that we write over and over again, which of the following is a better idea to make it less complex?
Use logical operators
Save it as a stored procedure
Write the query as many number of times as we want to execute
simplify it by using loops
Question 4: What is the syntax to create a stored procedure?
Create procedure procedure_name AS Sql_statements GO; Create procedure AS Sql_statements GO; Create procedure procedure_name Sql_statements GO; Create procedure procedure_name AS Sql_statements;
Question 5: Which of the following statement(s) is used to execute a stored procedure?
EXECUTE procedure_name;
EXE procedure_name;
EXEC procedure_name;
EXE PROCEDURE procedure_name;
Question 7: How many parameters can be passed to a stored procedure in SQL?
Only one
Two
Three
Any number
Question 8: Where the stored procedures are stored in a database?
Database data dictionary
Database meta data
Database server
SQL server
Question 9: Which of the following statements creates a stored procedure ‘MONEY’ with a parameter ‘note’?
CREATE PROCEDURE money As Sql_statements Go; CREATE PROCEDURE money note varchar2(10) As Sql_statements Go; CREATE PROCEDURE money @note varchar2(10) As Sql_statements Go; CREATE money @note varchar2(10) As Sql_statements Go;
Question 10: How many SQL statements can be written in a stored procedure?
One
Two
Three
Any number
