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 the default value of an integer data type in sql server 2005?

1 1011

What are the different editions available in sql server 2000?

1 1155

Can a synonym name of a table be used instead of a table name in a select statement?

1 1110

How do I determine how many instances of sql server are installed on a computer?

1 1083

What does the on update no action do?

1 1101

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1 1093

What is the parse query button used for?

1 1121

What stored by the model?

1 1163

When is the use of update_statistics command?

1 1079

Does an index slow down updates on indexed columns?

1 1070

What command would you use to add a column to a table in sql server?

1 1390

What is sql server 2000 work load governor?

1 1197

Are semicolons required at the end of sql statements in sql server 2005?

1 1067

How do I perform an unattended install of sql server 2000?

1 1189

What is nolock?

1 1054

Un-Answered Questions { Databases }

What are the properties of the transaction?

1069

What kind of problems occurs if we do not implement proper locking strategy?

1495

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?

1909

How do I find query history in sql server?

1020

Which statement is used in a select query for partial matching?

1239

what are all the common sql function? : Sql dba

1130

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

2050

What is in place upgrade in sql server?

1123

What is an indexed view?

1021

what is collation? : Sql dba

1229

How many concurrent programs you have customized, can you name some of them?

What is acid mean in sql server?

1241

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1066

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

What is a coalesce function?

1278

For More Un-Answered { Databases } Questions Click Here