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 blocking and how would you troubleshoot it?

2 5557

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 11668

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 4527

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 6662

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 4256

What is the system function to get the current user's user id?

TCS,

3 9566

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 4611

How to call Report from other Report ?

1 8682

what is a sub query?how will you calculate working days in a month using sub query?

InteQ,

4 11945

what is difference between cartesian join & cross join even they give same result?

Bank Of America,

4 14862

What's the difference between a primary key and a unique key?

Wipro,

10 18432

What are the steps you will take to improve performance of a poor performing query?

HCL,

1 10270

What are the steps you will take, if you are tasked with securing an SQL Server?

HCL,

1 7890

What is blocking and how would you troubleshoot it?

HCL,

3 8096

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

HCL,

3 11267

Un-Answered Questions { Databases }

Can we save images in mysql database?

916

How to insert multiple rows with one insert statement in ms sql server?

1137

What does select top 1 do in sql?

1110

How do you backup a database in mysql?

1082

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2533

In which sql server version report builder introduced?

150

What is percent sign in sql?

1301

What is the scd? and Types of SCD?

643

Is sql workbench free?

1012

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2986

How do I find query history in sql server?

956

How to create a table?

1010

What is interval partition?

1069

What is the New in SQL server 2008?

986

What is the use of a namespace in mongodb?

For More Un-Answered { Databases } Questions Click Here