Oracle Interview Interview Questions & Answers
Oracle Interview Interview Online Test
1. What is the maximum number of columns in a table of oracle DB ?
Show Answer
2. What are the components of physical database structure of Oracle database?
Show Answer
3. What are actual and formal parameters ?
Show Answer
4. What are the components of logical database structure of Oracle database?
Show Answer
5. whats the length of SQL integer?
Show Answer
6. What is a tablespace?
Show Answer
7. What is a transaction in Oracle ?
Show Answer
8. What is SYSTEM tablespace and when is it created?
Show Answer
9. Explain the relationship among database, tablespace and data file ?
Show Answer
10. What are the various types of Exceptions in Oracle ?
Show Answer
11. What is implicit cursor and how is it used by Oracle ?
Show Answer
12. What is schema?
Show Answer
13. What are the types of Notation in Oracle ?
Show Answer
14. What are Schema Objects?
Show Answer
15. Can objects of the same schema reside in different tablespaces?
Show Answer
16. Can a tablespace hold objects from different schemes?
Show Answer
17. What is Oracle table?
Show Answer
18. What is an Oracle view?
Show Answer
19. What is Partial Backup ?
Show Answer
20. What is Mirrored on-line Redo Log ?
Show Answer
21. What is Full Backup ?
Show Answer
22. Can a View based on another View ?
Show Answer
23. Can a Tablespace hold objects from different Schemes ?
Show Answer
24. Can objects of the same Schema reside in different tablespace ?
Show Answer
25. What is the use of Control File ?
Show Answer
26. Do View contain Data ?
Show Answer
27. What are the Referential actions supported by FOREIGN KEY integrity constraint ?
Show Answer
28. What are the type of Synonyms?
Show Answer
29. What is a Redo Log ?
Show Answer
30. Explain the relationship among Database, Tablespace and Data file?
Show Answer
31. What are the different type of Segments ?
Show Answer
32. What are Clusters ?
Show Answer
33. What is an Integrity Constrains ?
Show Answer
34. What is an Index ?
Show Answer
35. What is an Extent ?
Show Answer
36. What is a View ?
Show Answer
37. What is an Index Segment ?
Show Answer
38. What is Table ?
Show Answer
39. Can a view based on another view?
Show Answer
40. What are the advantages of views?
Show Answer
41. What is an Oracle sequence?
Show Answer
42. What is a synonym?
Show Answer
43. What are the types of synonyms?
Show Answer
44. What is a private synonym?
Show Answer
45. What is a public synonym?
Show Answer
46. What are synonyms used for?
Show Answer
47. What is an Oracle index?
Show Answer
48. How are the index updates?
Show Answer
49. What is a Tablespace?
Show Answer
50. What is Rollback Segment ?
Show Answer
51. What are the Characteristics of Data Files ?
Show Answer
52. How to define Data Block size ?
Show Answer
53. What does a Control file Contain ?
Show Answer
54. What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
Show Answer
55. What is Index Cluster ?
Show Answer
56. When does a Transaction end ?
Show Answer
57. What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Show Answer
58. What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Show Answer
59. How does one create a new database? (for DBA)
Show Answer
60. What database block size should I use? (for DBA)
Show Answer
61. What are the different approaches used by Optimizer in choosing an execution plan ?
Show Answer
62. What does ROLLBACK do ?
Show Answer
63. How does one coalesce free space ? (for DBA)
Show Answer
64. How does one prevent tablespace fragmentation? (for DBA)
Show Answer
65. What is a database buffer cache in Oracle?
Show Answer
66. Where can one find the high water mark for a table? (for DBA)
Show Answer
67. What is COST-based approach to optimization ?
Show Answer
68. What does COMMIT do ?
Show Answer
69. How are extents allocated to a segment? (for DBA)
Show Answer
70. Name the data dictionary that stores user-defined constraints?
Show Answer
71. Define Transaction ?
Show Answer
72. What is Read-Only Transaction ?
Show Answer
73. What is a deadlock ? Explain .
Show Answer
74. What is a Schema ?
Show Answer
75. What is a cluster Key ?
Show Answer
76. What is clusters ?
Show Answer
77. What is an Index ? How it is implemented in Oracle Database ?
Show Answer
78. What is a Database instance ? Explain
Show Answer
79. What is the use of ANALYZE command ?
Show Answer
80. What is default tablespace ?
Show Answer
81. What are the system resources that can be controlled through Profile ?
Show Answer
82. What is Tablespace Quota ?
Show Answer
83. What are the different Levels of Auditing ?
Show Answer
84. What is Statement Auditing ?
Show Answer
85. What are the database administrators utilities available ?
Show Answer
86. How can you enable automatic archiving ?
Show Answer
87. What are roles? How can we implement roles ?
Show Answer
88. What are Roles ?
Show Answer
89. What are the use of Roles ?
Show Answer
90. What is Privilege Auditing ?
Show Answer
91. What is Object Auditing ?
Show Answer
92. What is Auditing ?
Show Answer
93. What is a snapshot?
Show Answer
94. How do I find used/free space in a TEMPORARY tablespace? (for DBA )
Show Answer
95. What is a profile ?
Show Answer
96. How will you enforce security using stored procedures?
Show Answer
97. What is a sequence?
Show Answer
98. What are the dictionary tables used to monitor a database spaces ?
Show Answer
99. How can we specify the Archived log file name format and destination?
Show Answer
100. What is user Account in Oracle database?
Show Answer
101. When will the data in the snapshot log be used?
Show Answer
102. What dynamic data replication?
Show Answer
103. What is Two-Phase Commit ?
Show Answer
104. How can you Enforce Referential Integrity in snapshots ?
Show Answer
105. What is a SQL * NET?
Show Answer
106. What is a SNAPSHOT ?
Show Answer
107. What is the mechanism provided by ORACLE for table replication ?
Show Answer
108. What is snapshots?
Show Answer
109. What are the various type of snapshots?
Show Answer
110. Describe two phases of Two-phase commit ?
Show Answer
111. What are the min.extents allocated to a rollback extent in Oracle ?
Show Answer
112. What is snapshot log ?
Show Answer
113. What are the benefits of distributed options in databases?
Show Answer