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

Where is mysql used?

1 1057

What is difference between mysql and mariadb?

1 1204

What is innodb mysql?

1 1195

What is mysql primary key?

1 1042

What is difference between oracle sql and mysql?

1 1126

What is the data type for file in mysql?

1 1037

What is the difference between mysql_connect and mysqli_connect?

1 1045

What is the datatype of image in mysql?

1 988

What is database in php mysql?

1 1066

What is full text indexing in mysql?

1 1025

What is acid in mysql?

1 935

What is trigger in mysql with example?

1 997

What is new mysqli?

1 988

What is mysql community server?

1 996

What is the difference between mysql and oracle?

1 1044

Un-Answered Questions { Databases }

what are aggregate and scalar functions? : Sql dba

1122

What is in place upgrade in sql server?

1120

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

1124

What is an indexed view?

1018

What is clustered index

1081

Does group by remove duplicates?

1108

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2207

what is the difference between openrowset and openquery?

1186

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?

1905

How can we solve concurrency problems?

1116

What is self contained sub query?

1138

What is current version of mysql?

1067

What are the advantages of database?

1009

How can I check that whether automatic statistic update is enabled or not?

1108

How to export data from database and import into another?

989

For More Un-Answered { Databases } Questions Click Here