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 4481

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 6892

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

Accenture,

1 10125

Magic Tables ?

Thomson Reuters,

2 6395

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 5061

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 4800

CTE(common table expression)

Thomson Reuters,

1 9028

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13061

what is Covering Index ?

Thomson Reuters,

3 7276

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

Oracle, TCS,

4 21068

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 6467

Un-Answered Questions { Databases }

How is clustered index different from non-clustered index?

Explain security with sql azure?

186

How do you create a primary key?

1011

Find first and last day of current month in sql server

1028

What is replication id?

941

what is a live lock? : Sql server database administration

961

What is mutating error in pl sql?

1022

What's dateware house and what's clustor with practicle example

2175

How do I remove sql developer from windows 10?

1115

How to dump a table to a file with 'mysqldump'?

1035

State the acid rules?

1137

How does rowid help in running a query faster?

1417

What is oracle d2k?

How do you remove duplicate records from a table?

942

What is filtered index?

1100

For More Un-Answered { Databases } Questions Click Here