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 are the steps you will take to improve performance of a poor performing query?

2866

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

STC,

1 5323

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 7077

What is blocking and how would you troubleshoot it?

1 6772

Explain CREATE DATABASE syntax?

2 8665

How to start SQL Server in minimal configuration mode?

1 7999

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

3 8572

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 5465

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

1 4839

How to determine the service pack currently installed on SQL Server?

1 4472

What are cursors? Explain different types of cursors?

6 28895

What are the disadvantages of cursors? How can you avoid cursors?

2 10985

Explain the general syntax for a SELECT statements covering all the options.

3 8189

What is a join and explain different types of joins?

2 5793

Can you have a nested transaction?

1 3532

Un-Answered Questions { Databases }

ow to bring suspect mode datbase online from scratch

1820

What is the difference between oracle media recovery and crash recovery?

1191

Can we use having clause without group by?

996

What is indexing and its types?

1033

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2640

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2178

What is the best database management system?

997

Where are the settings stored for each instance in oracle?

1118

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1558

What are stored procedures in a database?

958

What is nvl?

1071

What is mongoose odm?

Can I work with several databases simultaneously? : sql server management studio

1004

What is the function of ms access?

944

Explain the microsoft sql server delete command? : sql server architect

806

For More Un-Answered { Databases } Questions Click Here