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

UDF
View Count: 0
Duration: 33 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

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