Interview questions

Database Administrator (dba) interview questions – page 32

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

  1. What is normalization? Explain normalization types.

  2. Which password parameter in the profile definitions can restrict the user from using the old password for 90 days?

  3. Select 100 records from million records ?

  4. What is database replicaion? What are the different types of replication you can set up in SQL Server?

  5. What is Files and Filegroups in SQL Server & it's implementation.

  6. What has been your greatest achievement in terms of employee relations?

  7. How do you set yourself aside from the next

  8. If we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

  9. Why do you want to leave the current job that you are in now?

  10. Write down the code for "how we delete a table without using of Drop command " ?

  11. How many no of arguments can be passed in procedures andfunctions

  12. Which utility would you use to refresh the test table with production data?a. SQL*Loader conventional pathb. SQL * Loader direct pathc. Export/importd. SQL * Plus direct-load insert

  14. What are the methodologies of Data Warehousing.?

  15. How many types of local tables in SQL SERVER

  16. Which two parameters must you specify when importing the metadata information into the target database while transporting tablespaces?a. DATAFILES b. TABLESPACESc. TRANSPORT_TABLESPACEd. TTS_OWNERS

  17. What is the difference between SQL and SQL Server?

  18. Db2 restart logic ?

  19. Which clause in the CREATE USER command can be used to specify no limits on the space allowed in tablespace APP_DATA?

  20. Wat is the main diff between sql server 2000and sql server 2005

  21. How to Handle the exceptions in Sqlsrver2000

  22. What are the SQL codes u freequently got?

  23. Is detail important to you? Do you think details should be left to your assistant?

  24. What is the default isolation level of the sql server database?

  25. What do you mean by MEDIA RECOVERY..?

  27. Difference between Include, Forward and sendRedirect in Servlet?

  28. How many partitions are possible in partitioned tablespace?dont say 1-64.a)240b)256c)512d)none

  29. How to compile PL/1 DB2 program? Please provide me details on this process?

  30. What is the difference between recovery and restoring of the database.

  31. How send email from database?.

  32. What are the various Reporting tools in the Market?

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