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

Explain about service Broker functions?

1001

Can you tell me about the concept of ER diagrams?

1032

What are different type of Collation Sensitivity?

962

Which one is faster delete/truncate? Why?

Infosys,

1 1753

Difference between DELETE and TRUNCATE?

TCS,

1015

What is Cross Join and in which scenario do we use Cross Join?

QuestPond,

990

What is a View ? Can we insert, Update and delete a view?

Arigo Infotech,

959

What is Dependency Injection and provide example?

1069

Can two different columns be merged into single column? Show practically?

QuestPond,

1028

What is the difference between DataRow.Delete() and DataRow.Remove()?

1181

What is the difference between a "where" clause and a "having" clause?

1141

Explain Normalization and DE normalization

iNautix,

1071

Is INSTEAD OF trigger directly applicable to Table ?

975

difference between Clustered index and non clustered index ?

Infosys,

954

What are indexers?

1050

Un-Answered Questions { Databases }

What is the use of mysqli_connect in php?

874

Where actually sql azure database is hosted?

161

What is a Join and explain its types?

1064

What is replication server?

892

How to convert a table data in XML format in sql server?

2505

How to end a stored procedure properly in ms sql server?

1046

Difference between sql and mysql?

2057

What is pl sql record in oracle?

987

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2012

What is a table partition?

1067

What does the no logging option do? Why would we use it? Why would we be careful of using it?

524

What is a field name?

931

Explain the difference between mysql and mysql interfaces in php?

1031

How do I connect to postgresql using putty?

842

How to include text values in sql statements?

1002

For More Un-Answered { Databases } Questions Click Here