Placement paper of Oracle 2-5 61. What constitute an ORACLE Instance ? SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process. 62. What is SGA ? The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. 63. What are the components of SGA ? Database buffers, Redo Log Buffer the Shared Pool and Cursors. 64. What do Database Buffers contain ? 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. 65. What do Redo Log Buffers contain ? Redo Log Buffer stores redo entries a log of changes made to the database. 66. What is Shared Pool ? Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas. 67. What is Shared SQL Area ? A Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution plan for the corresponding statement. 68. What is Cursor ? A Cursor is a handle ( a name or pointer) for the memory associated with a specific statement. 69. What is PGA ? Program Global Area (PGA) is a memory buffer that contains data and control information for a server process. 70. What is User Process ? A user process is created and maintained to execute the software code of an application program. It is a shadow process created automatically to facilitate communication between the user and the server process. 71. What is Server Process ? Server Process handle requests from connected user process. A server process is in charge of communicating with the user process and interacting with ORACLE carry out requests of the associated user process. 72. What are the two types of Server Configurations ? Dedicated Server Configuration and Multi-threaded Server Configuration. 73. What is Dedicated Server Configuration ? In a Dedicated Server Configuration a Server Process handles requests for a Single User Process. 74. What is a Multi-threaded Server Configuration ? In a Multi-threaded Server Configuration many user processes share a group of server process. 75. What is a Parallel Server option in ORACLE ? A configuration for loosely coupled systems where multiple instance share a single physical database is called Parallel Server.
Hit Ratio = (Logical Reads - Physical Reads - Hits Misses)/ Logical Reads. 45. When will be a segment released ? When Segment is dropped. When Shrink (RBS only). When truncated (TRUNCATE used with drop storage option). Page 1 of 1. Oracle Placement P
May 5, 2005 - 30 mins for aptitude and 15 mins for coding. I remeber few q's: ... The speed of the truck is 16km/hr slower than car. Find the .... category.html.
May 5, 2005 - 30 mins for aptitude and 15 mins for coding. .... www.ittestpapers.com/articles/mindtree-paper---05-may-2005---bit-campus.html#ixzz0rb7jcuLR.
Page 1 of 1. Hi Friends,. I had attended 4 ADP on june 18th the pattern is as follows firstly the written test takes place in that u will be asking aptitude,. some c q's ...
3.intel's first micropro...a.pentium b.pentiumproetc ... 9.diff between 8087,8086 (which is latest vers.) 10.some ... Displaying Satyam Placement Paper 33.pdf.
format and 10 questions were multiple choice questions. 1. ... then printf(%s,5[p]); ... code for finding out whether a string is a palindrome,reversal of linked list, ...
Sample Paper. Aakash ..... In a certain code, "Beautiful I peacock saw" is given .... (1) Mango. (2) Banana. (3) Apple. (4) Carrot. 87. Complete the series. ? (1). (2).
Sign in. Loading⦠Whoops! There was a problem loading more pages. Whoops! There was a problem previewing this document. Retrying... Download. Connect ...
Capgemini Placement Paper 3.pdf. Capgemini Placement Paper 3.pdf. Open. Extract. Open with. Sign In. Main menu. Displaying Capgemini Placement Paper ...
I told OS and COMPUTER NETWORKS. So asked me to explain types of scheduling.asked me few more from OS.â did not know theâ answer. HR: tell me about ...
Page 2 of 3. he hears of 'four-dimensional' things, he is seized by a feeling, which is very similar to the. thoughts awakened by the occult. And at the same time the statement that the world in which we. live is a four-dimensional space - time conti
They expect students to be strong in the Enterprise application and Technology integration field. QUESTION PATTERN AND A FEW QUESTIONS. The pattern was similar to CTS pattern as the HR's were former CTS employees. The booklet given here was PINK. 40
28) p and q are pointers to the same type of dataitems. Which of these are ... followed by funk characters. c) name = \ ... Page 1 of 1. TCS Placement Paper 3.pdf.
the h.r and finally got the job.and i am the one of them.i would like to share my ... 12)a problem from data interpretation..it was on line graphs...very big..not easy ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Main menu.
Ans. Divide and Conquer. 23. Program counter is incremented in. a. fetch (ans). b. decode. c. execute. 24. what does the following program do ? f(int n). {. int c;.
... and Interviews of Satyam held on 13th and 14th of September in Bangalore. ... Now,they asked whats the best way for A to send mails to B.. ... *How does JAVA implement multiple inheritance?[extends classes & implements interfaces]. HR.
Most of the question were from SOFTWARE ENGINEERING, C programming, Data structures, Operating systems such as- -> SDLC (software development life cycle)-what r various models [waterfall, prototype, iterative enhancement, spiral], wht r. the steps un
Page 1 of 1. Placement Paper of CISCO. CISCO. â â â â â (October, 2004). 1. In order to find out stack fault of a three input nand gate how many necessary input vectors. are needed ? 2. What is parity generation ? 3. A nand gate becomes ___ gat
2)a person is running at a speed of 18km/hr After oneâ min a bomb blasts .Sound travels at ... If(0==fork()). â â â I+=10; ... Displaying Wipro Placement Paper 11.pdf.
If the cost of the car is Rs.60 and a profit of 10% over selling price is earned (Ans: Rs 66/-)16. 1/3 of girls , 1/2 of boys go. to canteen .What factor and total number of classmates go to canteen. Ans: Cannot be determined. 17. The price of a prod
Page 1. Whoops! There was a problem loading more pages. Deloitte Placement Paper 1.pdf. Deloitte Placement Paper 1.pdf. Open. Extract. Open with. Sign In.
2) Some questions related 2 windows.... Ans) FAT ... a) clustered b) nonclustered c) unique but clustered or no clustered... etc. 5) Which is ... Technical interview (30 - 45 min) questions from C, C++, Area of interest & final sem project. if v stud
