Interview questions

Database Administrator (dba) interview questions – page 30

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

  1. Why is Data Modeling Important?

  2. What is Virtual Data Warehousing?

  3. Fill in the blank: The parameter MAXTRANS specifies the maximum number of concurrent transactions per ___________________.

  4. What are the benefits of data warehousing?

  5. How to modify already created table?

  6. When validating a constraint, why would you specify the EXCEPTIONS clause?

  7. What is the difference between a stored procedure and a userdefined function in sql server?

  8. What is the difference between groupby and orderby?

  9. If you run the ALTER SESSION SET NLS_DATE_FORMAT + ?DDMMYY? statement, which dictionary view would you query to see the value of the parameter?a. V$SESSION_PARAMETERSb. NLS_SESSION_PARAMETERSc. NLS_DATABASE_PARAMETERSd. V$SESSION

  10. How to delete duplicate rows in sql server2005

  11. What is SCD1 , SCD2 , SCD3?

  12. Rate yourself in .net and sql database?

  14. How get current date in SQL server 2000

  15. Explain what are db_options used for?

  16. What is the difference between stored procedures and stored functions in ORACLE

  17. What is CTE in sql server 2005?

  18. What are the different types of backup avaible in SQL Server

  19. I have created ODBC through Data sources and tests completed sucessfully.when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0.it is given following error-message .Error: ORA-03121: NO interface driver connected- function not performed.

  20. What is difference between TRUNCATE & DELETE?

  21. What are non-additive facts?

  22. Difference between sql server2000 and sql server2005

  23. What are the contents of a DCLGEN?

  24. What is normalization and its forms?

  25. Do you always double-check your work?

  27. Why use RUNSTAT Utility?

  28. What is the datatype returned by count(*)

  29. Describe a situation when you had to deal with an upset person and you were able to calm him/her down. how did you handle it?

  30. Which one is faster execute reader, scalar, execute non query ?

  31. What is referential integrity and how is it achieved?

  32. Which resource is not used to calculate the COMPOSITE_LIMIT?a. PRIVATE_SGAb. CPU_PER_SESSIONc. CONNECT_TIMEd. LOGICAL_READS_PER_CALL

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