Database - Interview Questions and Answers for 'Database query' | Search Interview Question

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 ?

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}

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?

Explain OOPs

or

Explain OOPs Principles

or

Explain OOPs Concepts

or

Explain OOPs features

or

Tell me something about OOPs

What is a Lambda Expression ? What's its use ?

What are different ways to create String Object? Explain.

Why Char array is preferred over String for storing password?

Does garbage collection guarantee that a program will not run out of memory?

What is the difference between final, finally and finalize() ?

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 ?