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

2 5673

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

3 11860

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

1 4627

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

3 6802

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 4344

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

TCS,

3 9711

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

1 4717

How to call Report from other Report ?

1 8762

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

InteQ,

4 12151

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

Bank Of America,

4 15056

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

Wipro,

10 18829

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

HCL,

1 10387

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

HCL,

1 7989

What is blocking and how would you troubleshoot it?

HCL,

3 8269

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

HCL,

3 11455

Un-Answered Questions { Databases }

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2046

how to escape special characters in sql statements? : Sql dba

1110

how to start mysql server? : Sql dba

1260

List out the different types of locks available in sql server?

1045

Why should you use or avoid select * statements?

1106

What is oracle latest version?

1170

What are the two main functions of queries in databases?

1525

Can we do dml on views?

1032

How did mongodb get its name?

What is a view in sql?

1035

What is the difference between case version and decode version?

1103

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1907

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1127

How to enter binary string literals in ms sql server?

1235

Where can you add custom error messages to sql server?

1203

For More Un-Answered { Databases } Questions Click Here