Interview questions

DB Administration interview questions – page 5

611 questions. Tap “Show answer” to check yourself.

  1. Explain about openEdge RDBMS?

  2. What is Oracle table

  3. Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.

  4. How to create a report with different objects can be seen at diffetrent countries not all the objects can be seen by all the countries people

  5. Can you take Image Backups using RMAN?20. Can you use Back upsets created by RMAN with any other utility?

  6. What is a Star Schema?

  7. What are the enhanced features in Teradata V2R5 and V2R6?

  8. How to insert value in the combo box cell of dataGridView using insert query in C#? How to handle the data error event?

  9. What are the scenarios or situations under which Progress Database creates new index entry for a record?

  10. How do you handle exceptions / errors in stored procedures?

  11. What is a data warehousing?

  12. Explain the relationship among database, tablespace and data file.What is schema

  14. What is Group by in Select statement?

  15. Whenever a DBA creates a user in which datafile that will be get created ?

  16. What is a lookup table in database? where can we use these type of table?

  17. Explain about Enterprise scalability and ROI of Data integration suite?

  18. How would you pass hints to the SQL processor?

  19. How is the data structure of System R different from the relational structure?

  20. Difference between Insert, Update and Modify?

  21. Explain about Progress Actional?

  22. Explain about Open switch business continuity software?

  23. What is Difference between E-R Modeling and Dimentional Modeling.

  24. What is Data Independence?

  25. What is the difference between Symetrically parallel processing,Massively parallel processing?

  27. Select statement to read data into internal tables. Types of Select statements

  28. Explain about Actional Flow mapping?

  29. How teradata makes sure that there are no duplicate rows being inserted when its a SET table?

  30. If you have an open cursor on a table, modify the same tableand commit, what would happen?

  31. In Microstrategy, what are Logical Views used for?

  32. Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9iAny attempts would be appreciated

Companies that ask DB Administration questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide