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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

HCL, Wipro,

2353

What is the difference between online clustering and Offline clustering?

IBM,

2419

When do u use clustered index and non-clustered index?

IBM,

3 8879

What is the diffrence between update_one and auto_fix?

IBM,

3 11202

what are the advanced features in sql 2008?

Wipro,

2 6429

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 7967

what are the diffeenes between oracle 9i,oracle 10g

2 6055

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2239

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 13633

what is correlated subquery

3 5166

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1984

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 11378

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 4026

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 6657

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 6671

Un-Answered Questions { Databases }

What is rank function in sql?

1032

What is a .db file?

992

Is sql between inclusive?

1139

Which is better cte or subquery?

1034

What does it mean to invest in the index?

976

Explain differences between web edition and business edition?

119

Are you doing the updates from within a cursor?

1121

Can you remove an open file under unix?

696

Explain about managing data tasks?

868

List similarities and differences between oracle & sybase.

975

How to download microsoft sql server 2005 express edition?

1051

What is @@rowcount in sql?

1011

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1068

What are some emotional triggers?

987

How many columns should be in an index?

963

For More Un-Answered { Databases } Questions Click Here