GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle System Architecture Interview Questions


Oracle System Architecture Interview Questions

Questions: 33
Comments: 38
 Oracle System Architecture Tags
 Showing Questions 1-10 of 33 Questions
[1] 2 3 4 Next >>
 Sponsored Links

 
 Oracle System Architecture Interview Questions
Sorting Options :  

what is a cluster and how it is used  
View Question | Asked by : ajit99

Why oracle is called kernel packagecomponents of oracle tablesql system variables local and global variables
View Question | Asked by : kavita

Latest Answer: sga stands fro system global area.. which is the part of the oracle instance(includes memory struture and background processes). for faster executon and better performance everthing comes in the sga.so sga is located in oracle instance,,, which itself ...
Read Answers (1) | Asked by : madhu

Latest Answer: The Oracle call interface (OCI)  The Oracle call interface is the lowest level at which client programs are intended to interact with Oracle. This interface is well documented and provides access to most of the functionality of Oracle, including ...

The  Checkpoint  (CKPT)  process  is  responsible  for  signaling  DBWR  at checkpoints  and  updating  all  the  data  files  
Latest Answer: HiThe checkpoint (CKPT) process frees up limited memory space and ensures instance recovery. It is a background process that monitors the number of dirty buffers that have not been written to disk. Depending on the LOG_CHECKPOINT_INTERVAL parameter, it ...

Database buffers, Redo Log Buffer the Shared Pool and   Cursors. 
Latest Answer: Its a part of shared pool and both comes under sga by default ...

SGA  and  ORACLE  background  processes constitute an ORACLE instance. (or) Combination of memory structure and background process. 
Latest Answer: A system Global Area and Oracle Background Processes together consitute an Instance. ...

The  System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. 
Latest Answer: It is a shared memory region allocated by oracle that contains data and control information for an Oracle Instance. An SGA compromises of Buffer Cache, Redo Log Buffers and Shared Pool Area. ...

Database  buffers store the most recently  used blocks of database data. It can also contain modified data that has not yet been permanently written to disk. 
Latest Answer: Buffer Cache Stores the most recently used blocks of data. It can also have modified data that has not permenently written to disk. When a row in a table is updated the foreground server processes reads the datafile information on the disk in to the ...

Redo Log Buffer stores redo entries a log of changes made to the database. 
Latest Answer: It stores redo log entries a log of changes made to a Database. ...

View page [1] 2 3 4 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Expert Members
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape