Interview questions

Database Administrator (dba) interview questions – page 29

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

  1. What are the Large object types supported by Oracle?

  2. What clause is in the ALTER TABLE command is used to reorganize a table?

  3. Explain in brief about critical column.

  4. Is it correct/feasible develop a Data Mart using an ODS?

  5. If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

  6. What is ODS?

  7. How to get a calender in date field in oracle forms?

  8. Which keyword is not valid of the BUFFER_POOL parameter of the STORAGE clause?

  9. What are non-additive facts in detail?

  10. What are dimensions?

  11. What is data cleaning? How can we do that?

  12. What is the differnece between materialized view and snapshot

  14. What is the difference between DATABASE ADMINISTRATION & ORACLE?

  15. Which command is used to assign a profile to an existing use?a. ALTER PROFILEb. ALTER USERc. SET PROFILEd. The profile should be specified when creating the user; it cannot be changed.

  16. What does level of Granularity of a fact table signify?

  17. Which script creates the CHAINED_ROWS table?A. catproc.sqlB. catchain.sqlC. utlchain.sqlD. No script is necessary: ANALYZE TABLE LIST CHAINED ROWS creates the table.

  18. Explain truncate with restore option with example

  19. What is the function you would use to transfer a string into a decimal?

  20. What is the difference between a unique constraint and a primary key constraint?

  21. What is active data warehousing?

  22. Which keyword should be used in the CREATE INDEX command to create a function ?based index?A. CREATE FUNCTION INDEX?B. CREATE INDEX ? ORGANIZATION INDEXC. CREATE INDEX? FUNCTION BASED ? D. None of the above

  23. What is a level of Granularity of a fact table?

  24. A constraint is created with the DEFERRABLE INITIALLY IMMEDIATE CLAUSE. What does this mean?

  25. What is the definitions for Datawarehose and Datamart?

  27. What are aggregations?

  28. What is the Difference between View and Stored Procedure?

  29. Which component is not part of the ROWID?A. TablespaceB. Data file numberC. Object IDD. Block ID

  30. Profiles cannot be used to restrict.a. CPU time usedb. Total time connected to the databasec. Maximum time a session can be inactived. Time spent reading blocks

  31. I have a server with 2GB RAM.Who is the optimal size for the shared pool size The shared pool reserved size is 1/10 to shared pool size Is there a mathematic type for compute the shared pool size ?

  32. How are the Dimension tables designed?

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