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 a Join and explain its types?

1 1165

What is the user of Primary key?

1 1036

How does index makes search faster?

QuestPond,

1 1032

How can we delete Duplicate row in table?

Wipro,

1 1122

How would you use user_constraints table in DB?

Wipro,

1 1071

Why do we backup Active Directory ?

1 1106

What is normalization? Describe its different types.

Wipro,

1 1165

What is the difference between DATETIME2 and DATETIME?

Infosys,

1 1138

What do you mean by the term 'normalization'?

Tech Mahindra,

1 1304

What is the difference between clustered and a non-clustered index?

NA,

1 1085

What is the difference between TRUNCATE and DROP?

1 1200

What are the disadvantages of using querystrings to send data from one page to another?

1 1099

What is the difference between ddl,dml and dcl commands?

BirlaSoft, Verifone,

1 1166

Explain DBCC?

QuestPond,

1 1022

Explain what role entity and relationship play in an ER diagram.

1 1122

Un-Answered Questions { Databases }

Explain system functions or built-in functions? What are different types of system functions?

1052

what is dbms? : Sql dba

1048

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

1101

What are the advantages of database?

1003

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

2554

What is in place upgrade in sql server?

1113

Is inner join faster than left join?

1265

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2691

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

What is acid mean in sql server?

1218

What is self contained sub query?

1129

Can one drop a column from a table?

1075

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

How do I find the sql server version?

1096

Why should you use or avoid select * statements?

1094

For More Un-Answered { Databases } Questions Click Here