Interview questions

Database Administrator (dba) interview questions – page 6

1,040 questions. Tap “Show answer” to check yourself.

  1. How to join two table?

  2. Define candidate key, alternate key, composite key.

  3. Define sql

  4. Sell me this stapler?(this pencil?this clock?or some other object on interviewer's desk).

  5. Write a query to find five highest salaries from EMP table.(there is a column SALARY)

  6. What type of documents you receiving from client later wtcan you do? what type of documents have to prepare?

  7. I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

  8. How to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

  9. How to fetch the last inserted record in a particular table?

  10. Write a query to get last 10 records from the table.

  11. What are field expressions and what are the diff types?

  12. Do you have the stomach to fire people? Have you had experience firing many people?

  14. What is the method of seperating unique and duplicaterecords in session level?

  15. What is for foreign key ?

  16. Why we use SET ROWCOUNT in Sql

  17. How can one connect two fact tables ? is it possible ? how?

  18. How to return multiple columes through through un-connectlookup?

  19. What's the most difficult part of being a (job title)?

  20. What is COALESCE / Why do we use COALESCE?

  21. What is a join and explain different types of joins.

  22. How to find nth highest salary

  23. What is NOLOCK?

  24. Can we insert ,update ,delete in target tables with oneupdate strategy tran.?

  25. What are the different index configurations a table can have?

  27. Can we use a having cluase in groupby clause.if there are 500 records i will give rownumber<250 then howmany records does it retrieve.wt is the result of nvl2(null,notnull,null)if there are four tables without using cartesian how manyjoins can be there.in the sql subqueries wt is the parent ans1)select2)update,3) delete 4)2&3

  28. Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

  29. On a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

  30. Where could you use some improvement?

  31. What is difference between "Primary key" and "Unique key"?

  32. Explain different types of constraints.

Companies that ask Database Administrator (dba) questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide