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 analyze command ? what kind of statistics does it generate?

2 5165

how do u know the total no of rows in a table?

6 9357

what are archived logs?

1 2283

what are bitmap indexes? How does they work?

1 2327

what are the database links ?

2 4947

does the query needs a hint to access a materialized view?

1 3983

what are different types of locks?

6 8970

master table and child table performances and comparisons in Oracle ?

1 2223

what are the different types of cursors? explain?

4 10567

what are different types of deletes?

1 3923

can a view be updated?

3 9986

what is pragma?

2 6920

can you write commit in triggers?

4 11101

can u call user defined functions in select statements

2 5496

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 7126

Un-Answered Questions { Databases }

How to rebuild the master database?

1161

What is an indexed view?

1021

What is temporary table in sql server? Why we use temp table?

1017

What are different types of constraints?

997

what are all the common sql function? : Sql dba

1130

What is oracle latest version?

1171

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

what are aggregate and scalar functions? : Sql dba

1124

what is sql server agent? : Sql dba

1181

How do I start sql server 2017?

1013

what is collation? : Sql dba

1229

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?

1903

What is subquery? Explain the properties of a subquery?

1057

How do I remove duplicates in two columns?

1180

What are the properties of the transaction?

1069

For More Un-Answered { Databases } Questions Click Here