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

What is difference between equi join and natural join?

1062

What is meant by indexing?

1034

What is a trigger and its types?

1000

What is a trigger what are the advantages of trigger?

1019

What is equi join with example?

1148

What is difference between order by and group by?

1022

What is difference between drop truncate and delete?

1108

What is the difference between ddl and dml?

1069

What is indexing explain it with an example?

1025

What is an example of a foreign key?

991

What is difference between inner join and full join?

1077

What is the purpose of indexing?

1057

What is difference between unique and primary key?

925

What is an indice?

1049

What is difference between views and tables?

1029

Un-Answered Questions { Databases }

What is sqlite format?

1209

Explain some predefined exceptions.

1047

What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

1333

Can we delete column in sql?

1122

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

990

What is the function of access?

849

does pl/sql support “overloading”? Explain

1001

How to implement service broker?

1026

How do I transfer data from one database to another in mysql?

917

Explain how ms access is better than ms sql server?

890

What are the triggers in sql?

1118

What is the starting oracle error number? What is meant by forward declaration in functions?

1013

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1094

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2197

Why do we need distributed database?

1008

For More Un-Answered { Databases } Questions Click Here