Interview questions

Database Administrator (dba) interview questions – page 28

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

  1. Why is SAS so popular?

  2. Which line in the following code has an error?1. ALTER TABEL MY_TABLE2. STORAGE (3. MINEXTENTS 44. NEXT 512K)5. NOLOGGING;

  3. What are the advantages data mining over traditional approaches?

  4. What is the main difference between Inmon and Kimball philosophies of data warehousing?

  5. A table is created with an INITRANS value of 2. Which value would you choose for INITRANS of an index created on this table?

  6. What is XMLA?

  7. Have you used lexical parameters in reports

  8. What are fact tables?

  9. List out differences between Oracle Server 9i and Oracle Server 10g.

  10. How do you connect two fact tables ? Is it possible ?

  11. Can a dimension table contains numeric values?

  12. What is difference between file and table in abinitio

  14. What is Restricted Mode of Instance Startup ?

  15. What is the diff b/w BTREE INDEX and BITMAP INDEX

  16. What is the difference between Datawarehousing and Business Intelligence?

  17. How does Oracle determine the extent sizes for a temporary segment?A. From the initialization parametersB. From the tables involved in the sort operationC. Using the default storage parameters for the tablespaceD. The database block size

  18. What is Data warehousing Hierarchy?

  19. What are external procedures ? Why and when they are used?

  20. What is a data mart?

  21. What is the difference between view and materialized view?

  22. What is ETL?

  23. What is the approximate size of a data warehouse?

  24. Which data dictionary view shows statistical information from the ANALYZE INDEX VALIDATE STRUCTURE command?

  25. What are measures?

  27. Which of the following statements may require a temporary segment?a. CREATE TABLEb. CREATE INDEXc. UPDATEd. CREATE TABLESPACE

  28. How many codds rule should oracle satisfies

  29. What is junk dimension? What are junk dimension and degenerated dimension?

  30. What is the process of upgrading oracle forms /reports from older version to new versions?

  31. What is a CUBE in data warehousing concept?

  32. What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

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