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,

1 2420

What is the difference between online clustering and Offline clustering?

IBM,

1 2488

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

IBM,

3 9010

What is the diffrence between update_one and auto_fix?

IBM,

3 11338

what are the advanced features in sql 2008?

Wipro,

2 6544

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 8092

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

2 6191

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

1 2303

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 13779

what is correlated subquery

3 5309

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

1 2033

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

7 11670

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

1 4096

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 6887

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 6909

Un-Answered Questions { Databases }

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

How do I start sql server 2017?

1001

When should you use an instead of trigger?

1033

Where can you add custom error messages to sql server?

1190

What is normalization and what are the advantages of it?

1042

define sql insert statement ? : Sql dba

1086

How to use values from other tables in update statements using oracle?

1139

What is a coalesce function?

1261

How do I find the sql server version?

1096

what is the command syntax for inserting a document?

What is a scheduled job or what is a scheduled task?

1022

Were you involved in any data conversion, which one?

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2089

What is standby servers? Explain types of standby servers.

1067

How to start an oracle instance?

1086

For More Un-Answered { Databases } Questions Click Here