Top Interviews Question and their answer with examples (Part 2) Here are some mentioned points. 1. What is your salary expectation? A nasty question, do not give the salary number to them exactly as every compan
@i,1)-- no need to look beyond window of upper left diagonal (@i) + @max cells-- and t...
Another interview I had with a database professional, turned out to be a dull conversation. The person came in to apply for a senior function, and he definitely had the experience for it. His personality was good, and would fit the team perfectly. But every answer we asked him, he answ...
Advanced SQL interview questions Here are15 advanced SQL interview questions or conceptswithdetailed answers, designed to test in-depth SQL knowledge and problem-solving ability: 21. What are Window Functions? Explain with an example. Answer: Window functionsperform calculations across a set of table ...
Database Answer First Prev Next Last Editorial / Best Answer Answered by: Yadnesh Jun 1st, 2013 -- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we...
Languages Interview Questions Cisco(35) Micro Processor Interview Questions Cognizant(1) Placement Assistance Dell(22) Aptitude Interview Questions GE(2) Placement Assistance HAL(1) Placement Assistance Infosys(212) Challenging Puzzles ISRO(6) Placement Assistance ...
Ask Question Home Interview Questions Oracle PL/SQL Oracle PL/SQL Private Procedure What is Private Procedure in Oracle PL/SQL? Interview Candidate Mar 19th, 2017 4 15971 PL/SQL Answer First Prev Next Last Showing Answers 1 - 4 of 4 Answersarundhati Apr 20th, 2017 A procedure define ...
This can be done by using the TRANSLATE function as it replaces character by character. Was this answer useful? Yes 1 ReplySwathy Dec 12th, 2011 Varsha could you please write the query for this above question? Was this answer useful? Yes Replykira...
Ask Question Home Interview Questions Oracle PL/SQL Can we use commit or rollback command in the exception part of PL/SQL block?Interview Candidate Oct 19th, 2005 32 24036 PL/SQL Answer First Prev Next Last Editorial / Best Answer Answered by: answertoyourquery Nov 9th, 2005 Yes, we ...
PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. Interview Candidate Sep 9th, 2004 16 38891 PL/SQL Answer First Prev Next Last Showing Answers 1 - 16 of 16 Answerstm1966_muthu Feb 17th, 2006...