Database - Interview Questions and Answers for 'Query' - 7 question(s) found - Order By Rating Q1. Sort an Employee Object based on Name or Age Database
Ans. Use Comparable or Comparator interface Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve  sql query Asked in 1 Companies Q2. create an SQL query across multiple tables involving outer joins Database
Ans. Select * from table1 t1Left outer join table2 t2 on t1.tid = t2.id Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve  sql query  database  outer joins Asked in 2 Companies Q3. If given a choice , which one would you prefer to send params to the Get service , path params or query param ? Web Service
Ans. If the number of params is quite large , I would prefer to either split it with majority of it in query params or all in query params.
If the params are all mandatory , I would keep it as path params. If it's optional , I would keep it as query param so as to keep consistent base url.
If we don't require the param name , then they can be kept as path params as query params necessitates the usage of param name. Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve  Web Service  Get service  path vs query param  Rest  query param  path param Q4. Write Delegate function of JQuery ? JQuery
Ans. http://www.w3schools.com/jquery/event_delegate.asp Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve   Asked in 1 Companies Q5. There is a Table Student having Student Id, Name and Total Marks. Can you please write an SQL that will display the maximum marks obtained by a student ? Database
Ans. SELECT MARKS FROM STUDENT ORDER BY MARKS DESC LIMIT 1; Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve  database query Asked in 1 Companies Q6. How to count total number of tables in database ? Database
Ans. SELECT COUNT(*) FROM information_schema.tables Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve  database query Asked in 1 Companies Q7. What do you know about JQuery ? Java EE
Ans. jQuery is a cross platform JavaScript library designed to simplify the client-side scripting of HTML. JQuery is the most popular JavaScript library. Help us improve. Please let us know the company, where you were asked this question : Like Discuss Correct / Improve  jquery Asked in 1 Companies