Interview questions

Database Administrator (dba) interview questions

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

  1. What is Stored procedure ?

  2. How will you update multiple records in a single shot? From an ASP.net appli to SQL Serevr

  3. What's the difference in HTML AJAX, ASP.Net AJAX?

  4. What are the common problems (errors) you get while implementing AJAX?

  5. How do you read arguments in a shell program - $1, $2 ..?

  6. If you have a string "one two three", which shell command would you use to extract the strings?

  7. What is the difference between writing code in shell and editor?

  8. Physical standby database

  9. Backup and Recovery techniques including cold and hot backup

  10. Oracle Architecture - Shared Pool and SGA

  11. Name some of the standard Business Intelligence tools in the

  12. Use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007i need to restrect this query to current date and current year[gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosale

  14. What are the limitations of cognos reportnet? What are the enhancements in reportnet ?

  15. How much would be the size of the database in DataStage ? What is the difference between Inprocess and Interprocess ?

  16. How do you write a while loop in shell?

  17. How do you search for a string in a directory with the subdirectories recursed?

  18. Raj has a jewel chest containing Rings, Pins and Ear-rings. The chest contains 26 pieces. Raj has 2 and 1/2 times as many rings as pins, and the number of pairs of earrings is 4 less than the number of rings. How many earrings does Raj have?...

  19. Different types of shells

  20. What commands are valid in BS mode?

  21. Update and Fixes: R-* files refers to

  22. Name some app engines u worked on?

  23. What does $# stand for?

  24. You are given weights of order 1kg 3kg 9kg 27kg 81kg and so on...(powers of 3)A weight of N kg is placed on any one of the empty pans of the balance.You are supposed to add weights to both pans of the balance and make them equal.You can use one weight only once..i.e., you can't use 2 number of 3kg weights.

  25. What is the nominal voltage required in subscriber loop connected to local exchange?a) +48 voltsb) -48 voltsc) 230 voltsd) 110 volts

  27. What is a Broadband modem?

  28. How many T1 facilities the company needs between its office and the PSTN if it has 47 digital telephones, each operating at 64kbps: a. 3 low-speed video machines, each operating at 384kbps b. 1 interactive video system, requiring 1.536 mbps.

  29. Max number of satellite hops allowed in voice communication is:a) only oneb) more han onec) two hopsd) four hops

  30. I wanted to load only particular no of records suppose i have 100 records out of which i wanted to load first 10 records to target.

  31. What action is taken when the processor under execution is interrupted by a non-maskable interrupt?a) Processor serves the interrupt request after completing the execution of the current instruction.b) Processor serves the interrupt request after complet

  32. A moves 3 kms east from his starting point . He then travels 5 kms north. From that point he moves 8 kms to the east. How far is A from his starting point?

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