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 difference between is null & is not null?

1 1053

How to validate email addresses in mysql?

1 1191

How we can get distinct columns values in mysql?

1 1132

Write a query to display even rows in student table using mysql?

1 946

How to write optimized query in mysql?

1 1044

How to display odd rows in student table in mysql?

1 1088

What is the difference between myisam dynamic and myisam static in mysql?

1 1067

List some comparisons operators used in mysql?

1 1049

How do I import database through command line?

1 1078

What is the difference between the primary and unique key in mysql?

1 1047

What is the difference between having and where clause in mysql? Explain

1 1086

Explain the difference between primary key and candidate key in mysql?

1 1022

How to control the max size of a heap table?

1 1058

How to display top 10 rows in mysql?

1 1096

Is mysql case-sensitive?

1 957

Un-Answered Questions { Databases }

How do I find the sql server version?

1096

Is primary key always clustered index?

1080

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1930

Have you used lexical parameters in reports?

What is subquery? Explain the properties of a subquery?

1046

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

1000

What is the current version of postgresql?

1144

Explain “row_number()” in sql server with an example?

1061

what is sql server agent? : Sql dba

1162

Can sql servers link to other servers like oracle?

900

what is the difference between openrowset and openquery?

1174

what is bcp? When does it used? : Sql dba

1040

Why should you use or avoid select * statements?

1094

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?

1899

Why use identity in sql server?

1185

For More Un-Answered { Databases } Questions Click Here