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 do you mean by exception log in replication?

1022

Explain mirroring?

879

What is the difference between natural join and equi join?

945

What are the important features of sybase?

995

What is the default table size in sybase?

912

What measures are there to increase the db space?

919

Differentiate between replication server and sql remote?

980

List different types of locks in sybase?

998

What is the use of 'with check' option in views?

917

How do the blocker processes exist internally in sybase?

917

What are table partitions? How is it different with ase 15.0 version?

899

Explain locking. List its types.

930

List different types of sybase index.

890

You want to delete a table in sybase. How would you do it?

874

Differentiate between db-lib and ct-lib?

987

Un-Answered Questions { Databases }

What are the rules of setting a primary key?

837

What do you mean by oracle dba and what is its role?

600

How many database files are there in sql server 2000?what are they?

1067

What is data control language (dcl)?

1161

What is cursor in mysql?

912

Why do we use view in sql?

981

How to set primary key in mongoose?

What is the difference between unix timestamp and mysql timestamp?

1064

How to connect to mongodb using mongoose in node.js?

Can postgres use multiple indexes?

856

What is the difference between hot backup and cold backup in oracle?

1024

How do you organize a database?

940

How can one get sql*loader to commit only at the end of the load file? : aql loader

1078

What is 32-bit nuances?

What is rdbms with diagram?

905

For More Un-Answered { Databases } Questions Click Here