How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?
2 12500How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?
4 15619i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?
6 13630using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.
4 11968sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
1 8256Post New Fidelity SQL PLSQL Interview Questions
What will happen if an array goes out of bounds?
How do I edit a grouped worksheet in excel?
my dear friends i want to know about pattern of HPCL & SAIL written exam papers. so please send me the details.
What is the difference between Normalization and De-normalization?
1) What is an Virtual memory? 2) How do we test API's in both Windows/Linux/Unix? 3) What is an IOCTL? 4) How do you open a char device through API's? 5) What is major num/ minor num? 6) What is the max num for minor num? 7) Who gives you the major / minor numbers? 8) Reverse a string using recursive func. 9) fork/vfork/clone. 10) What does fork returns? 11) What is a zombie process? 12) What happens when a child completes before parent tries to wait for it? 13) Interrupt handlers, top-hdnl....?
How long does chkdsk r take windows 10?
What is information integration ?
How to access a models data from a view in backbone.js?
Why is stringbuffer not immutable?
What is ideal voltage and ideal current?
What is sql trace? : abap data dictionary
Few important terminology we come across networking concepts?
descriptive program for web application.
What is declaring array?
Dear sir/madam, plz sand me techanical test question (mechanical)