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 dbcc command and why is it used?

1 1131

How will you decide the active and passive nodes?

1 1205

How can you hide the sql server instances?

1 1094

What is the difference between value type and reference type?

1 1015

Define magic tables in sql server?

1 1170

Explain different types of collation sensitivity?

1 1052

What command is used to rename the database?

1 1114

What is the sql server agent?

1 1166

What is sub-query in sql server? Explain its properties.

1 1158

What is the most common trace flags used with sql server?

1 1150

Explain the properties of sub-query in sql server?

1 1097

What are the different types of collation sensitivity in sql server?

1 1201

What are the advantages of using third-party tools?

1 1062

What is the usage of sign function?

1 1207

What are the different type of replication in sql server?

1 1043

Un-Answered Questions { Databases }

What are the kinds of subquery?

1101

How to rebuild the master database?

1160

What is sql server query analyzer?

1124

Can we do dml on views?

1032

Does group by remove duplicates?

1112

How raid can influence database performance?

1114

How to enter binary string literals in ms sql server?

1235

Are you familiar with user exits in reports?

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

1065

Equi join and non equi join is possible with sql server?

1130

What versions of clipper does netlib support?

1088

What are different types of constraints?

996

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? IBM 1. What is virtual dataset? 2. How do you handle reject link to a peek stage? 3. What is transaction table? 4. Which one is the efficient from the following? a. ODBC enterprise b. Oracle enterprise 5. How can you extract data from excel sheet? Do you know how to parameterize, this option? 6. Six pages of complex query I have, how do you simplify this query? 7. Difference between dataset and lookup file set?

1983

Can we use distinct and group by together?

1133

How can we solve concurrency problems?

1120

For More Un-Answered { Databases } Questions Click Here