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

2902

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

STC,

1 5395

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

1 7136

What is blocking and how would you troubleshoot it?

1 6849

Explain CREATE DATABASE syntax?

2 8758

How to start SQL Server in minimal configuration mode?

1 8093

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

3 8668

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

1 5528

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

1 4893

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

1 4539

What are cursors? Explain different types of cursors?

6 29100

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

2 11074

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

3 8297

What is a join and explain different types of joins?

2 5879

Can you have a nested transaction?

1 3610

Un-Answered Questions { Databases }

Explain stored procedure?

1110

from where do u receive the information to develop report

2053

How to delete an existing database user?

1083

what are the new features introduced in oracle form services in 11g release 2?

1078

Please explain compound trigger in oracle?

1111

How to execute stored procedure in select statement sql server?

1116

How to create a new view in oracle?

1131

Is mysql connect deprecated?

1021

How useful is microsoft access?

927

Is oracle dba in demand?

646

What is limit in dbms?

1115

Why would you use sql agent? : sql server DBA

1132

Is sqlexception checked or unchecked?

1017

What is field size access?

799

Explain artificial key?

1216

For More Un-Answered { Databases } Questions Click Here