SYSTEM ARCHITECTURE Oracle Interview Questions [33 Questions]

  1. Oracle clusterwhat is a cluster and how it is used
  2. why oracle is called kernel package
    components of oracle table
    sql system variables
    local and global variables
  3. what is SGA? Where it is located? Why the system performance will be slow after loading the oracle?
  4. What are the different Oracle Kernel Layers
  5. What is the function of checkpoint(CKPT)? The  Checkpoint  (CKPT)  process  is  responsible  for  signaling  DBWR  at checkpoints  and  updating  all  the  data  files  and control files of the database.
  6. You must first Login or Register to view all 33 questions from this category.

    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.