Oralce Database Architeture Interview Questions - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 04:36 PM

1. What are the different type of Segments ?

2. What is a Data Segment ?

3. What is an Index Segment ?

4. What is Rollback Segment ?

5. Describe Referential Integrity ?

6. how to encrypt and decrypt oracle procedure

7. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

8. What is the name of the back ground process that modifies the db buffer cache?

9. What are advantage of Data Dictionary manage Tablespace

10. What is Data Block ?

11. what is the difference between SID and Global Database Name ?

12. How are Indexes Update ?

13. What is a View ?

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

15. What is the use of Control File ?

16. What is an Integrity Constrains ?

17. What is a Data Dictionary ?

18. What does a Control file Contain ?

19. What is schema?

20. What is a Tablespace?

21. What are the components of Logical database structure of ORACLE database?

22. What is SYSTEM tablespace and when is it Created?

23. what is the back ground process in oracle architecture

24. What are the uses of Rollback Segment ?

25. What are the components of Physical database structure of Oracle Database?.

26. What are the Limitations of a CHECK Constraint ?

27. What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

28. What are the Referential actions supported by FOREIGN KEY integrity constraint ?

29. Explain the relationship among Database, Tablespace and Data file.

30. what is meant by snapshot error? expain it.

31. What is a Data File ?

32. What are the Characteristics of Data Files ?

33. What is a Segment ?

34. What is an Extent ?

35. What is a Synonym ?

36. What is Table ?

37. What is a Sequence ?

38. Do View contain Data ?

39. What are Clusters ?

40. What is Hash Cluster ?

41. What is the use of Redo Log Information ?

42. what is the differnece between materialized view and snapshot

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

44. What is a Temporary Segment ?

45. What is Row Chaining ?

46. What is a Redo Log ?

47. What is the function of Redo Log ?

48. What is self-referential integrity constraint ?

49. What is Database Link ?

50. How to define Data Block size ?

51. Can a Tablespace hold objects from different Schemes ?

52. Describe the different type of Integrity Constraints supported by ORACLE ?

53. What is the maximum number of CHECK constraints that can be defined on a column ?

54. What are Schema Objects ?

55. Can objects of the same Schema reside in different tablespaces.?

56. Can a View based on another View ?

57. What are the advantages of Views ?

58. What are the type of Synonyms?

59. What is a Private Synonyms ?

60. What is a Public Synonyms ?

61. What are synonyms used for ?

62. What is an Index ?

63. What is cluster Key ?

64. What is Index Cluster ?

65. When can Hash Cluster used ?

66. What are the types of Database Links ?

67. What is Private Database Link ?

68. What is Public Database Link ?

69. What is Network Database link ?

09-12-08, 04:36 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	Oralce Database Architeture Interview Questions 1. What are the different type of Segments ? 2. What is a Data Segment ? 3. What is an Index Segment ? 4. What is Rollback Segment ? 5. Describe Referential Integrity ? 6. how to encrypt and decrypt oracle procedure 7. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ? 8. What is the name of the back ground process that modifies the db buffer cache? 9. What are advantage of Data Dictionary manage Tablespace 10. What is Data Block ? 11. what is the difference between SID and Global Database Name ? 12. How are Indexes Update ? 13. What is a View ? 14. What is the diff b/w BTREE INDEX and BITMAP INDEX 15. What is the use of Control File ? 16. What is an Integrity Constrains ? 17. What is a Data Dictionary ? 18. What does a Control file Contain ? 19. What is schema? 20. What is a Tablespace? 21. What are the components of Logical database structure of ORACLE database? 22. What is SYSTEM tablespace and when is it Created? 23. what is the back ground process in oracle architecture 24. What are the uses of Rollback Segment ? 25. What are the components of Physical database structure of Oracle Database?. 26. What are the Limitations of a CHECK Constraint ? 27. What is difference between UNIQUE constraint and PRIMARY KEY constraint ? 28. What are the Referential actions supported by FOREIGN KEY integrity constraint ? 29. Explain the relationship among Database, Tablespace and Data file. 30. what is meant by snapshot error? expain it. 31. What is a Data File ? 32. What are the Characteristics of Data Files ? 33. What is a Segment ? 34. What is an Extent ? 35. What is a Synonym ? 36. What is Table ? 37. What is a Sequence ? 38. Do View contain Data ? 39. What are Clusters ? 40. What is Hash Cluster ? 41. What is the use of Redo Log Information ? 42. what is the differnece between materialized view and snapshot 43. What are the Large object types supported by Oracle? 44. What is a Temporary Segment ? 45. What is Row Chaining ? 46. What is a Redo Log ? 47. What is the function of Redo Log ? 48. What is self-referential integrity constraint ? 49. What is Database Link ? 50. How to define Data Block size ? 51. Can a Tablespace hold objects from different Schemes ? 52. Describe the different type of Integrity Constraints supported by ORACLE ? 53. What is the maximum number of CHECK constraints that can be defined on a column ? 54. What are Schema Objects ? 55. Can objects of the same Schema reside in different tablespaces.? 56. Can a View based on another View ? 57. What are the advantages of Views ? 58. What are the type of Synonyms? 59. What is a Private Synonyms ? 60. What is a Public Synonyms ? 61. What are synonyms used for ? 62. What is an Index ? 63. What is cluster Key ? 64. What is Index Cluster ? 65. When can Hash Cluster used ? 66. What are the types of Database Links ? 67. What is Private Database Link ? 68. What is Public Database Link ? 69. What is Network Database link ? __________________ Sai Prepaid Mobile Recharge Online - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.