Stored Procedure Interview Questions and Answers

All Categories >> Databases Programming >> Stored Procedure >> ▼

Stored Procedure Interview Questions and Answers will guide us that Stored Procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a proc, sproc, StoPro, or SP) are actually stored in the database data dictionary. So learn Stored Procedure with the help of this Stored Procedure Interview Questions with Answers guide

  1. Stored Procedure questions updated at 01 Jul 10 in Category Databases Programming and visited 2522 Times

Stored Procedure Questions and Answers:

1 :: Explain about the case statement present in Stored procedure?

CASE statement contains a complex conditional construct. If a certain statement is evaluated as true then the search_condition makes sure that the following statement gets executed. If there are no true statements are present then the ELSE clause is executed. An error is generated if there is no statement.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

2 :: How do you notify DBPAK about Stored Procedure?

There are three following statements to execute a DBPAK in the stored procedure. These are the following steps.
1) In the browser hierarchy double click on the Query widget
2) After clicking it try finding insertProc resource in the Resource editor
3) Edit the insertProc resource.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

3 :: Explain about the properties of Cursors?

These are the properties which a cursor has Assensitive, Read-only, Non-Scrollable. Assensitive is used either to perform a copy or not to perform a copy. When Read only function is used it is not updatable. It can scroll only in one direction and it cannot skip tables.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

4 :: Explain about cursors?

Cursors are supported by procedures, functions and triggers. Syntax of the cursors is embedded in SQL. Cursor should be declared before declaring handles. Before declaring cursors it is imperative to declare variables and conditions.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

5 :: Explain about the RETURN statement?

A RETURN statement is used to terminate the execution of a stored function. This inturn returns a value of expr to the function caller. In a stored function there should be at least a single return statement. If there exists multiple functions it can have multiple exit points.
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

Rate This Category:
1/5 Rating (1 vote)
 Place Your Question



Top: Stored Procedure Interview Questions and Answers
Stored Procedure Interview Questions and Answers

Top Frequently Asked Stored Procedure Question
Frequently Asked Stored Procedure Job Interview Question


Top Frequently opened Databases Programming Job Interview categories
Most popular Databases Programming Job Interview categories

Comments About Stored Procedure Interview Questions and Answers

Share your valuable opinions, ideas and suggestions about Stored Procedure Interview Questions and Answers
While placing your comment your email address is required but won't be published any where else; Personal information will be kept confidential; we do not sell or release our respective visitors private information.

  1. Webmaster 23rd of May 2012

    Webmaster Said

    Tell us what you feel about Stored Procedure Interview Questions and Answers
    All comments will be published after review. No login or registration is required to post a comment on Stored Procedure Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
    So start sharing your thoughts regarding Stored Procedure Interview Questions and Answers
    Thank you.

    Reply

    • Loften Pierce (1 Comment) 22nd of February 2011

      Loften Pierce Said

      A question concerning Stored procedure Q & A - why, under:
      Interview Categories - Database programming - MS SQL programming are referenced to PHP? I was interested in seeing T-SQL statements? Just wondering?

Leave a Comment

Leave a Comment
  4.  Enter This Verification Code  Regenerate Verification Code  



Your reply will be added to the comment above (Below any other replies to this comment) -

Top Comments About: Stored Procedure Interview Questions and Answers
Comments on Stored Procedure Interview Questions and Answers

 
Top of Link batk to Stored Procedure Interview Questions and Answers
Link batk to Stored Procedure Interview Questions and Answers

Privacy Policy | Terms and Conditions | Contact Us »