Buy Discounted Microsoft Exam Voucher
Rs. 5600
OFFER PRICE Rs. 4250/- | Contact: +91 9347458388
Azure Certification
NewBatches/Webinars
Packages
Gold Membership
Bestseller
Microsoft Azure Suite & Suite Plus
Azure DevOps Expert & Expert Plus
MS.NET Foundation For Beginners
MS.NET Full Stack Developer
UI / Web Development
SQL Server & MSBI Tools
Software Testing
Courses
MS.NET Courses (Includes Live Project)
Complete C#, OOPs and Windows Programing
ASP.NET MVC Online Training
ASP.NET WebForms
ASP.NET Core
WCF incl. Web Services and Remoting
WPF incl. MVVM and Prism
LINQ and Entity Framework
Live Project Training for Developing Enterprise Application
Live Project using Ntier Arch (.NET5 + EF Core + Angular)
Gold Membership
CareerStep IT Program
Client-side UI Technologies
Building Static Web Pages using HTML and CSS
JavaScript and HTML DOM
jQuery, AJAX and JSON
Building Interactive Web Pages using HTML5 and CSS3
BootStrap + Live Examples
AngularJS + Live Project
Angular + Typescript
ReactJS
KnockoutJS
Xamarin
SQL Server + MSBI
SQL Server 2017
Querying Data with Transact-SQL(70-761)
SQL Server Integration Service (SSIS)
SQL Server Reporting Service (SSRS)
SQL Service Analysis Service (SSAS)
Cloud Computing / Azure / AWS
AZ-900: Microsoft Azure Fundamentals
Azure Suite (AZ-104+AZ-204+AZ-305+ AZ-500)
AZ-104: Microsoft Azure Administrator
AZ-204: Developing Solutions for Microsoft Azure
AZ-305: Microsoft Azure Architect Technologies and Design
AZ-400: Microsoft Azure DevOps
DP-203: Data Engineering on Microsoft Azure
Amazon Web Services (AWS)
Testing Tools
Manual Testing
Selenium Testing with Java(Live Training)
SharePoint
SharePoint 2013
Microsoft Power Platform
Power Platform Suite
Data Analytics using PowerBI (DA-100)
MicroServices
Docker
Kubernetes
Microservices using .NET Core
Others
C and Data Structure
Core Java
OOPs and C++
Advance Java
Python Programming
Complete Azure Training
Pricing
Videos
Resources
AzureA2Z
Deccansoft
Blog
On-Job Tech Support
Wall of Fame
Testimonials
Contact Us
Login
Login or Register
×
Sign In
Register
Forgot Password?
How did you find us
WhatsApp
YouTube
LinkedIn
Facebook
Telegram
Twitter
Google
Referred by Friend
Refresh
Input symbols
By clicking Register, you accept to the
terms and conditions
and that you have read our
privacy policy.
Recover Password
×
Submit
Enquiry Now
Where did you come to know about us
WhatsApp
YouTube
LinkedIn
Facebook
LinkedIn Ad
Email
Twitter
Google
Referred
Other
Refresh
Input symbols
Stored Procedures and UDF
Interview Questions and Answer
1. Stored procedure can be called from SELECT statement.
Options:
a. TRUE
b. FALSE
Reveal Answer
2. Which statement is true for the following example createproceduresp_emp_sal(@empnoint,@salintoutput) as select@sal=salaryfromemployeewherepkempno=@empno return go -- to execute the procedure declare@empnoint=2 declare@salint execsp_emp_sal@empno,@sal print@sal
Options:
a. The salary of the employee is displayed
b. The OUTPUT keyword doesnot exist in procedures
c. RETURN keyword can not be used in procedures
d. No out put will be got, as @sal doesnot hold any value
Reveal Answer
3. Which statements are true for the following examples alterproceduresp_emp_sal(@empnoint) as declare@salint select@sal=salaryfromemployeewherepkempno=@empno return@sal go declare@empnoint=2 declare@salint exec@sal=sp_emp_sal@empno print@sal
Options:
a. Procedure returns error as RETURN statement cannot be used used in stored procedures
b. exec@sal=sp_emp_sal@empno statement is syntactically wrong so values returned does not come into @sal variable in the calling procedures
c. Successfully executes and displays the salary for a given employee
d. Invalid PRINT statement as the @sal has to be converted into string.
Reveal Answer
4. DML statements are allowed in Stored procedures
Options:
a. TRUE
b. FALSE
Reveal Answer
5. Which statements are true regarding stored procedures
Options:
a. Cannot be utilized in SELECT statement
b. TRY and CATCH block cannot be used in the procedures
c. Procedures cannot be called from functions
d. We can go for transaction management
Reveal Answer
6. Store procedure can be used by
Options:
a. A single user
b. By a single user in a single application
c. By a single user in multiple applications
d. By multiple users in multiple applications
Reveal Answer
7. what are valid parameters in stored procedures
Options:
a. Input parameters
b. Output parameters
c. Only input parameters
d. Default parameters
Reveal Answer
8. OUTPUT parameters are_____________
Options:
a. Uni-directional
b. Bi-directional
Reveal Answer
9. Which are valid system procedure statement to rename a column
Options:
a. sp_rename'employee.fkdeptno','deptno'
b. sp_ename'fkdeptno','deptno','column'
c. sp_rename'employee.fkdeptno','deptno','column
d. sp_renamecol'employee.fkdeptno','deptno'
Reveal Answer
10. The same procedure sp_rename can be used to rename the column and to rename the table also
Options:
a. TRUE
b. FALSE
Reveal Answer
11. Which statements are true regarding stored procedures
Options:
a. SQL query in the stored procedure is parsed and compiled every time they are run
b. A stored procedure is a set of statements/commands which reside in the database.
c. Stored procedures are also useful when you want to do Batch updates on the db.
d. The network traffic reduces due to procedures than executing an adhoc query
Reveal Answer
12. Maximum number of parameters that can be passed to a procedure are
Options:
a. 2150
b. 2010
c. 3150
d. 2100
Reveal Answer
13. The information about the stored procedure can be seen by using _________ procedures
Options:
a. sp_help
b. sp_helptext
c. sp_helpconstraint
d. NONE
Reveal Answer
14. SELECTNAMEFROMSYS.ALL_OBJECTSWHEREtype='P'. This statement gives us________________.
Options:
a. The list of all parameters
b. The list of all functions
c. List of all stored procedures
d. List of all database objects which start with 'p'
Reveal Answer
15. Which statement gives the definition of the procedure?
Options:
a. EXECsp_helptext'sp_insert_empcopy'
b. sp_helptext'sp_insert_empcopy'
c. sp_help'sp_insert_empcopy'
d. None
Reveal Answer
16. Alterprocedureaddition(@num1int,@num2int=10,@num3int=5) as return@num1+@num2+@num3 Is this a valid return statement for stored procedure?
Options:
a. NO, return statement is not allowed in the procedures
b. Return statement is allowed, but it cannot have mathematical expressions
c. YES, it is a valid statement
d. The sum of three values is calculated and the result is returned to the calling procedures
Reveal Answer
17. Which statements are true regarding procedures
Options:
a. The code of the stored procedure can be changed without affecting application.
b. Stored procedure is cached in SQL Server’s memory.
c. By using stored procedures we can reuse the code.
d. All the above
Reveal Answer
18. What information does the following sql query give? SELECT sys.objects.name,sys.objects.type,sys.objects.type_desc, sys.objects.schema_id,sys.syscomments.text FROMsys.objects INNERJOINsys.syscommentsONsys.objects.object_id=sys.syscomments.id wheresys.syscomments.textlike'%employee%' Andtype='P'
Options:
a. The list of parameters which take the input values from the table 'EMPLOYEE'
b. To get the definition of procedures which have 'EMPLOYEE' table used
c. The list of parameters which give the output values from the table 'EMPLOYEE' to output parameters
d. The list of procedures in which the 'EMPLOYEE' is used.
Reveal Answer
19. Functions can be called from procedures. Is this statement true?
Options:
a. YES
b. NO
Reveal Answer
20. Which statement is true regarding procedures
Options:
a. DML statements which can change the existing database are not allowed
b. Only SELECT statement can be used.
c. Procedures are used to perform DML actions
d. Try and catch block cannot be used in procedures
Reveal Answer
Packages
Gold Membership
Microsoft Azure Suite &Suite Plus
Azure DevOps Expert &Expert Plus
MS.NET Foundation For Beginners
MS.NET Full Stack Developer
UI / Web Development
SQL Server & MSBI Tools
Software Testing
Resources
Blog
Deccansoft
AzureA2Z
Wall of Fame
On-Job Tech Support
About
About BestDotNetTraining
About Trainer
Testimonials
FAQ
Other links
About Us
Contact Us
Leave us a feedback
Sitemap
Privacy Policy
Terms & Conditions
Proudly Powered by