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?

1067

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 }

Where does mysql store data?

875

What are the two types of exceptions in pl/sql?

1052

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

Explain csv tables.

1009

How delete all data from table in sql?

1014

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1278

What is the difference between nvl and nvl2?

972

How to drop an existing table?

1000

What is the difference between function and procedure in pl/sql?

1081

What happens if variable names collide with table/column names?

1191

Which files are vital that should be backed up?

603

What is a trigger in sql?

1202

What language does postgresql use?

771

What is transact-sql language?

1094

What is database client?

1001

For More Un-Answered { Databases } Questions Click Here