View Count: 0 Duration: 24 mins Accessed date: Not Yet Viewed View Count: 0 Duration: 43 mins Accessed date: Not Yet Viewed View Count: 0 Duration: 16 mins Accessed date: Not Yet Viewed View Count: 0 Duration: 29 mins Accessed date: Not Yet Viewed View Count: 0 Duration: 33 mins Accessed date: Not Yet Viewed

### Be the first one to comment about this video

 Stored Procedures and UDF Download
 Sorry!For this module there is no Sample Code.
 Sorry!For this module there is no Assignments.
Question No: 1 of 20
`Stored procedure can be called from SELECT statement. `
Options:
1. TRUE
2. FALSE
View Answer/Explanation:
b
Explanation:

Question No: 2 of 20
```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:
1. The salary of the employee is displayed
2. The OUTPUT keyword doesnot exist in procedures
3. RETURN keyword can not be used in procedures
4. No out put will be got, as @sal doesnot hold any value
View Answer/Explanation:
d
Explanation:

Question No: 3 of 20
```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:
1. Procedure returns error as RETURN statement cannot be used used in stored procedures
2. exec@sal=sp_emp_sal@empno statement is syntactically wrong so values returned does not come into @sal variable in the calling procedures
3. Successfully executes and displays the salary for a given employee
4. Invalid PRINT statement as the @sal has to be converted into string.
View Answer/Explanation:
c
Explanation:

Question No: 4 of 20
`DML statements are allowed in Stored procedures `
Options:
1. TRUE
2. FALSE
View Answer/Explanation:
a
Explanation:

Question No: 5 of 20
`Which statements are true regarding stored procedures `
Options:
1. Cannot be utilized in SELECT statement
2. TRY and CATCH block cannot be used in the procedures
3. Procedures cannot be called from functions
4. We can go for transaction management
View Answer/Explanation:
a c d
Explanation:

Question No: 6 of 20
`Store procedure can be used by `
Options:
1. A single user
2. By a single user in a single application
3. By a single user in multiple applications
4. By multiple users in multiple applications
View Answer/Explanation:
d
Explanation:

Question No: 7 of 20
`what are valid parameters in stored procedures `
Options:
1. Input parameters
2. Output parameters
3. Only input parameters
4. Default parameters
View Answer/Explanation:
a b d
Explanation:

Question No: 8 of 20
`OUTPUT parameters are_____________ `
Options:
1. Uni-directional
2. Bi-directional
View Answer/Explanation:
b
Explanation:

Question No: 9 of 20
`Which are valid system procedure statement to rename a column `
Options:
1. sp_rename'employee.fkdeptno','deptno'
2. sp_ename'fkdeptno','deptno','column'
3. sp_rename'employee.fkdeptno','deptno','column
4. sp_renamecol'employee.fkdeptno','deptno'
View Answer/Explanation:
a c
Explanation:

Question No: 10 of 20
`The same procedure sp_rename can be used to rename the column and to rename the table also `
Options:
1. TRUE
2. FALSE
View Answer/Explanation:
a
Explanation:

1

#### Live Online Training

© Copyright 1997 - 2017 | www.bestdotnettraining.com | www.deccansoft.com All Rights Reserved.