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

Oracle (3253)
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,

2416

What is the difference between online clustering and Offline clustering?

IBM,

2486

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

IBM,

3 9006

What is the diffrence between update_one and auto_fix?

IBM,

3 11321

what are the advanced features in sql 2008?

Wipro,

2 6534

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 8081

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

2 6169

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

2301

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 13758

what is correlated subquery

3 5293

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

2027

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

7 11615

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

1 4088

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 6857

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 6876

Un-Answered Questions { Databases }

How can we optimize stored procedure?

1020

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1232

Is mongodb a database?

What is the function of grid naming service used in oracle rac

What is database partitioning?

3722

What do we need queues in sql service broker?

1130

How do I install postgresql?

943

Can we store pdf files in mysql?

1040

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

652

What type of database is postgresql?

885

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1117

What is rank function?

1086

How you can add messages to the nt event log from within a stored procedure?

1146

What do we use to remove duplicate records while fetching a data in mysql ?

1025

Explain master-detail relationship with some examples.

1058

For More Un-Answered { Databases } Questions Click Here