Oracle Dba Interview Question and Answers

41. Name the four types of segments?
 
    The four types of segments are
  • data
  • index
  • rollback
  • temporary
 
Your Name Your Email-ID
Your Answer
42. What is a view?
  A view is a logical representation of a subset or superset of informations in schema objects.
 
Your Name Your Email-ID
Your Answer
43. What is Oracle table?
 
  • A table is the basic unit of data storage in an Oracle database.
  • The tables of a database hold all of the user accessible data.
  • Table data is stored in rows and columns.
 
Your Name Your Email-ID
Your Answer
44. What is a dedicated server process?
 
  • A dedicated server process has a one to one correlation between the user process and the server process.
  • Each user process gets one server process.
 
Your Name Your Email-ID
Your Answer
45. What Oracle object is used for read consistency?
  The rollback segments are used for read consistency.
 
Your Name Your Email-ID
Your Answer