Database - Interview Questions and Answers for 'Database query' | Search Java Interview Question - javasearch.buggybread.com
Javasearch.buggybread.com

Search Interview Questions


 More than 3000 questions in repository.
 There are more than 900 unanswered questions.
Click here and help us by providing the answer.
 Have a video suggestion.
Click Correct / Improve and please let us know.
Label / Company      Label / Company / Text

   



Database - Interview Questions and Answers for 'Database query' - 2 question(s) found - Order By Newest

 Q1. How to count total number of tables in database ?Database2016-10-18 14:13:31

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


Related Questions

  Difference between == and .equals() ?
  Why is String immutable in Java ?
  Explain the scenerios to choose between String , StringBuilder and StringBuffer ?

or

What is the difference between String , StringBuilder and StringBuffer ?
  What are the difference between composition and inheritance in Java?
  Does garbage collection guarantee that a program will not run out of memory?
  What are different ways to create String Object? Explain.
  Why Char array is preferred over String for storing password?
  Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?
 Explain OOPs

or

Explain OOPs Principles

or

Explain OOPs Concepts

or

Explain OOPs features

or

Tell me something about OOPs
  What do you mean by "Java is a statically typed language" ?


 Q2. 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 ?Database2016-10-18 14:21:04

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


Related Questions

  Difference between == and .equals() ?
  Why is String immutable in Java ?
  Explain the scenerios to choose between String , StringBuilder and StringBuffer ?

or

What is the difference between String , StringBuilder and StringBuffer ?
  What are the difference between composition and inheritance in Java?
  Does garbage collection guarantee that a program will not run out of memory?
  What are different ways to create String Object? Explain.
  Why Char array is preferred over String for storing password?
  Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?
 Explain OOPs

or

Explain OOPs Principles

or

Explain OOPs Concepts

or

Explain OOPs features

or

Tell me something about OOPs
  What do you mean by "Java is a statically typed language" ?



Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked: