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?

1032

Can you tell me about the concept of ER diagrams?

1076

What are different type of Collation Sensitivity?

1001

Which one is faster delete/truncate? Why?

Infosys,

1 1815

Difference between DELETE and TRUNCATE?

TCS,

1047

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

QuestPond,

1013

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

Arigo Infotech,

995

What is Dependency Injection and provide example?

1117

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

QuestPond,

1066

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

1230

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

1160

Explain Normalization and DE normalization

iNautix,

1110

Is INSTEAD OF trigger directly applicable to Table ?

1017

difference between Clustered index and non clustered index ?

Infosys,

993

What are indexers?

1086

Un-Answered Questions { Databases }

Which are the two editions in which SQL Azure database available?

119

How to view the data files in the current database?

1098

What is table level trigger?

1020

How do I run a pl sql procedure in sql developer?

968

How to install oracle database 10g xe?

1018

How do you handle datasets larger than 50 gb?

162

What is the use of sql trace?

952

Can I run multiple instances of sql server 2000 at the same time on one computer?

1074

How to use in conditions?

1013

How to run create database statement again?

1154

What are the limitations of using a model?

1021

What is difference between hql and sql?

1077

When is the update_statistics command used?

1116

What is delimiter in dbms?

900

Can a table have 2 primary keys?

983

For More Un-Answered { Databases } Questions Click Here