Global Web Forum

Muhammad

بِسمِ اللَّهِ الرَّحمٰنِ الرَّحيمِ

From: Sahiwal Division

Registered: 2012-03-22

Posts: 22,197

Website

System Architecture Interview Questions And Answers

Oracle Database :: Oracle System Architecture Job Interview Questions and Answers

Oracle System Architecture frequently Asked Questions in various System Architecture related job Interviews by interviewer. Get preparation of System Architecture job interview questions

1 Tell me what are the two types of Server Configurations?
2 Explain what are the different Oracle Kernel Layers?
3 Tell me the names of ORACLE Background Process?
4 What is Server Process in Oracle System Architecture?
5 What is User Process in Oracle System Architecture?
6 Tell me what is Dedicated Server Configuration?
7 Do you know what is a Parallel Server option in ORACLE?
8 Tell me what is a Multi-threaded Server Configuration?
9 Tell us what Does DBWR do?
10 Tell me what is the maximum number of Lock Processes used?
11 Tell me what is the function of ARCH?
12 Explain what are functions of PMON?
13 Explain what is the function of Dispatcher (Dnnn)?
14 Do you know what is function of RECO?
15 What is the function of Lock (LCKn) Process in System Architecture?
16 Tell me how many Dispatcher Processes are created?
17 What is database security? How will you use it?
18 What is PGA?
19 Tell me what do Database Buffers contain?
20 Explain what is SGA? Where it is located? Why the system performance will be slow after loading the oracle?
21 Why is Oracle called kernel package?
22 Tell me what are the components of SGA?
23 What is a cluster and how it is used?
24 What is the approach taken by Oracle to pass ACID test of a database transaction?
25 Tell me what are the functions of SMON?
26 Explain what constitute an ORACLE Instance?
27 Tell me what does LGWR do?
28 What is the function of checkpoint (CKPT)?
29 Explain when Does DBWR write to the database?
30 What is SGA in Oracle System Architecture?
31 What is Shared Pool in Oracle System Architecture?
32 Tell me when does LGWR write to the database?
33 What is Cursor in Oracle System Architecture?
34 Explain what do Redo Log Buffers contain?
35 Explain what is Shared SQL Area?
36 Tell me why oracle is called kernel package, components of oracle table, sql system variables, local and global variables?

Download System Architecture Interview Questions And Answers PDF

---

Online Web Tutorials And Interview Questions With Answers Forum:
https://globalguideline.com/forum/