Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

TCS,

1 4480

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

Polaris,

1 6883

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

Accenture,

1 10123

Magic Tables ?

Thomson Reuters,

2 6383

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 5052

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 4793

CTE(common table expression)

Thomson Reuters,

1 9019

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13055

what is Covering Index ?

Thomson Reuters,

3 7266

How to create a view on a table which does not exists

Oracle, TCS,

4 21056

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

TCS,

1 6464

Un-Answered Questions { Databases }

Can mysql scale horizontally?

988

What is row_number()?

984

Can we write ddl statements in functions?

1116

What is default password for mysql?

869

What is end user in database?

597

Is it possible to configure the cache size for mmapv1 in mongodb?

How do I become a data manager?

527

Explain the rollup operator?

1076

How to configure odbc dsn with different port numbers?

1087

What is the advantage of postgresql?

836

Why is sharding used?

995

Explain storage engine in mongodb

What is full join in sql?

991

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

541

How do I find the size of a sql server database?

928

For More Un-Answered { Databases } Questions Click Here