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 difference between inner join and join?

1 1106

Can two tables share a primary key?

1 1105

What are cursors stored procedures and triggers?

1 1108

Is natural join and equi join same?

1 1045

What is join query?

1 954

What it means to be triggered?

1 1104

Can we use pragma autonomous_transaction in trigger?

1 1028

What is table level trigger?

1 1072

Can we call future method from queueable?

1 1114

What does nvl stand for?

1 1020

Is null vs coalesce?

1 941

What is the difference between join and inner join?

1 1083

What is triggers and stored procedures?

1 1011

What is a mutating table error and how can you get around it?

1 1160

Can we call stored procedure in trigger?

1 1014

Un-Answered Questions { Databases }

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1184

what is the command syntax for inserting a document?

please send me oracle pl/sql exp resume. and also faqs...

2564

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?

1901

How can we solve concurrency problems?

1116

Is primary key always clustered index?

1090

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

How to export data from database and import into another?

987

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

what are aggregate and scalar functions? : Sql dba

1122

Does group by remove duplicates?

1107

what are all the common sql function? : Sql dba

1123

How did mongodb get its name?

How to provide default values to function parameters?

1245

What is the current version of sql?

1091

For More Un-Answered { Databases } Questions Click Here