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

Search Interview Questions


 2796 questions in repository.
 There are more than 200 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

   



Magicbricks


   




Database - Interview Questions and Answers for 'Magicbricks' - 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     MagicBricks


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?
  What do you mean by "Java is a statically typed language" ?
  Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?
  What are different ways of object creation in Java ?
  What are points to consider in terms of access modifier when we are overriding any method?
 What is the difference between declaration, instantiation and initialization ?
  What are the common uses of "this" keyword in java ?


 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     MagicBricks


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?
  What do you mean by "Java is a statically typed language" ?
  Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?
  What are different ways of object creation in Java ?
  What are points to consider in terms of access modifier when we are overriding any method?
 What is the difference between declaration, instantiation and initialization ?
  What are the common uses of "this" keyword in java ?




Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner



comments powered by Disqus
 

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:
         

X Close this

X Close this

Help Us Improve.
Please share your
interview experience.

Company Name:   


Questions Asked: