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?

2855

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

STC,

1 5311

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

1 7065

What is blocking and how would you troubleshoot it?

1 6759

Explain CREATE DATABASE syntax?

2 8655

How to start SQL Server in minimal configuration mode?

1 7987

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

3 8560

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

1 5452

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

1 4830

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

1 4459

What are cursors? Explain different types of cursors?

6 28868

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

2 10971

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

3 8179

What is a join and explain different types of joins?

2 5778

Can you have a nested transaction?

1 3523

Un-Answered Questions { Databases }

What is DDL (Data Definition Language)?

891

What is the advantage of database management system?

921

How to insert data into mongodb using mongoose?

What are the limitations/drawbacks or ssrs 2008 r2?

140

What does mysqli_fetch_assoc do?

920

What are the usages of sql?

1064

Why do we need databases?

1055

Explain constraining triggers.

1104

Is candidate a key?

960

What is pl sql script?

1037

Why do we use cursors?

994

What is unique key constraint?

1068

How to find out what version of microsoft access I have?

836

How do triggers work?

949

What is the difference between inner join and outer join?

1002

For More Un-Answered { Databases } Questions Click Here