Interview questions

Database Administrator (dba) interview questions – page 33

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

  1. HOW TO DELETE THE SINGLE QUOTATION IN THE SOURSE TO LOAD THE DATA TO DESTINATION

  2. If i have one transaction say mainTransaction, within thismainTransaction i have another two transaction say t1 and t2.Now while execution t1 completes successfully and commitstatement fires, but while executing t2 some error occursand rollback statement fires. What happen to t1, is it rollback or not?

  3. How to check whether some services are running in anotherserver or not? Suppose i am currently in a server named A.I want to checkwhether some services are running in server B withoutlogging into the server B.

  4. What is sql override?what is the use of it?

  5. How to replace double quotes by single quotes in sql server

  6. What is conformed fact?

  7. Which dictionary view shows the password expiration date for a user?

  8. When your team encounters a problem, such as irritation with another co-worker, how do you reach a good resolution?

  9. What is main use of table space and index object?please its urgent

  10. How to Handle the exceptions in Sqlsrver 2005?

  11. How to run a servlet program?

  12. To use the transportable tablespace feature, the block size of the target and source database should bea. 4KBb. Same sizec. Not larger that 16KBd. Different size

  14. What is LIS ?

  15. What is referential integrity? What are the advantages of it?

  16. What is the difference between DTS and SSIS?

  17. How can we do ETL process in SQL Server?

  18. What is the uses of cursor

  19. What are the advantages of using sql server over ms access or why should one use sql instead of ms access

  20. What are cursors? Name four types of cursors and when eachone would be applied?

  21. Store procedure will return a value?

  22. How to link up the text file to a Database table?

  23. When transporting a tablespace from one database to another, it should be a. Read-only. b. Offline. c. Online. d. Tablespace status does not matter.

  24. When you are part of a team that is working exceptionally well, what do you think the reasons are for its success?

  25. What is the maximum number of profiles that can be assigned to a user?

  27. What are the different tools available for hot backups. Is it preferable to take it manually all the time or it depends on the size of the database.

  28. What is a linked cube?

  29. What is degenerate dimension table?

  30. What are the magic tables in SQL Server 2000?

  31. PC(code, model, speed, ram, hd, cd, price)Find the hard drive sizes that are equal among two or more PCs.

  32. Which role in the following list is not a predefined role from Oracle?a. SYSDBAb. CONNECTc. IMP_FULL_DATABASEd. RESOURCE

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