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

Describe and explain about SQL native client?

1 1185

Detail about query optimizer?

1 1186

Explain about SQLOS?

1 1072

Explain about protocol layer present in SQL server?

1 1326

Explain about the architecture of MYSQL?

1 1034

Explain about reporting services of MYSQL?

1 1139

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

1 1131

How do you connect MySQL database with PHP?

1 1050

Give some features of MongoDB.

1 50

What is syntax of for loop in r?

1 46

What is BSON?

1 48

How do you limit the number of result returned?

1 47

What is the syntax of mongodb collection?

1 45

Define mongodb SUM?

1 45

What is the role of use command?

1 57

Un-Answered Questions { Databases }

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2302

Can you index views?

951

Have you created fact table and dimension tables?

696

What are the types of database explain each of them briefly?

1044

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

What are different types of constraints?

995

Why should you use or avoid select * statements?

1103

What is a scheduled job or what is a scheduled task?

1029

What are the different types of subquery?

1226

Do we need to rebuild index after truncate?

1126

What are the kinds of subquery?

1093

define sql insert statement ? : Sql dba

1092

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

how to escape special characters in sql statements? : Sql dba

1108

Can sql servers link to other servers like oracle?

905

For More Un-Answered { Databases } Questions Click Here