Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

IBM,

2 8826

What is Trace flag?

Wipro,

1 4693

Differences between Standby Vs No recovery?

Wipro,

2 16910

what is lazy writer?

Wipro,

1 8910

Can we move Resource database from one path to another? If yes,How can we?

Wipro,

1 7320

What is the use of Port no?

Wipro,

1 4844

Can you explain some of the DTS problems?

UBS, Wipro,

1 4908

What is Check point? Explain in Brief what it will do?

Wipro,

1 6182

What is DAC? what is the use of it?

Wipro,

1 6058

what is Buffer cash and Log Cache? Can you Explain it?

Wipro,

1 9005

if a table is getting updated what happens if a function is called from sql query?

RBS,

2 9386

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 4690

how can create data base link for tow servers (scott schema) give examples plz

2 5430

using comand prompt how can import table data and table space with example

2 5741

What is the mandatory setup in cyclecount ?

Oracle,

2818

Un-Answered Questions { Databases }

Name the sql joins that are available in informix.

103

Why should we use mongodb?

What is the difference between char and varchar in mysql?

1214

When cursors are useful?

1180

How to define an anonymous procedure without variables?

1206

Explain triggers?

1072

How would you pass hints to the sql processor?

1046

What is the difference between recovery and restoring of the oracle database?

1306

What is java oracle used for?

1083

What is serial data type in postgresql?

966

What are the informix isolation levels?

157

What is bcnf normalization form?

1170

How to create “dependant” parameter “make, model, year”

138

Could you give me an example how, where I code checkpoint and restart. I need and example

1110

Can you have a composite foreign key?

863

For More Un-Answered { Databases } Questions Click Here