Interview questions

Database Administrator (dba) interview questions – page 34

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

  1. When did you last coordinate your work with others in a team project? What was your most successful contribution?

  2. What is the difference between goal and ambition?

  3. Have you ever had a role in a team project where your role was not clearly defined? How do you handle this?

  4. When you have worked on a team, and your role was crucial, what was that role? In what way was this team effort different or similar to working on your own?

  5. What are connection strings?

  6. What is a general purpose scheduling tool?

  7. Regarding joins what are the differences you observed inoracle 9i and sql server?

  8. Which view would you query to see whether John has the CREATE TABLE privilege?a. DBA_SYS_PRIVSb. DBA_USER_PRIVSc. DBA_ROLE_PRIVSd. DBA_TAB_PRIVS

  9. What are the main differences between ms access and sqlserver

  10. What are the different architecture of data warehouse?

  11. A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

  12. Can we call stored Procedure in Function in Sql Server 2000and vice versa.

  14. How do u connect ado.net to sql server

  15. Name some of modeling tools available in the Market?

  16. Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.

  17. What is session ?how sessions are handeled in application?write the clauses of sql server in their order.

  18. Which parameter in the export file is used to specify a structure ?only export (no rows)?a. ROWSb. TABLEc. NODATAd. DIRECT

  19. What is the difference between joins and scope relationship?

  20. How to explain favorite spot in an interview? Briefly with example

  21. Difference between Triggers and Stored Procedure

  22. Where are connection strings stored?

  23. What is transaction ? Give me one example.

  24. What type of Indexing mechanism do we need to use for a typical data warehouse?

  25. Which is not a system privilege?a. SELECTb. UPDATE ANYc. EXECUTE ANYd. CREATE TABLE

  27. Why after installing a new operating system still the performance of the system is very slow

  28. Containers : Usage and Types?

  29. What is commit charger?

  30. Wht r the data types present in bo?n wht happens if we implement view in the designer n report

  31. What is OLTP?

  32. What are your goals for the future?

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