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?

1 2906

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

STC,

1 5408

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

1 7141

What is blocking and how would you troubleshoot it?

1 6861

Explain CREATE DATABASE syntax?

2 8789

How to start SQL Server in minimal configuration mode?

2 8111

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

3 8692

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

1 5540

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

1 4905

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

1 4555

What are cursors? Explain different types of cursors?

6 29145

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

2 11102

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

3 8312

What is a join and explain different types of joins?

2 5889

Can you have a nested transaction?

1 3631

Un-Answered Questions { Databases }

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

What is self contained sub query?

1129

What are the advantages of database?

1003

How did mongodb get its name?

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1899

Can sql servers link to other servers like oracle?

900

do you know how to configure db2 side of the application? : Sql server database administration

1106

Is inner join faster than left join?

1265

How to start an oracle instance?

1086

Design database draw er diagram for a certain scenario ?

4635

Have you created fact table and dimension tables?

694

What are the types of database explain each of them briefly?

1038

What versions of clipper does netlib support?

1062

Have you written applications to retrieve stored images in a table?

1070

How to use values from other tables in update statements using oracle?

1139

For More Un-Answered { Databases } Questions Click Here