Placement paper of Oracle 3-3 31. Why query fails sometimes ? Rollback segment dynamically extent to handle larger transactions entry loads. A single transaction may wipeout all avaliable free space in the Rollback Segment Tablespace. This prevents other user using Rollback segments. 32. How will you monitor the space allocation ? By quering DBA_SEGMENT table/view. 33. How will you monitor rollback segment status ? Querying the DBA_ROLLBACK_SEGS view IN USE - Rollback Segment is on-line. AVAILABLE - Rollback Segment available but not on-line. OFF-LINE - Rollback Segment off-line INVALID - Rollback Segment Dropped. NEEDS RECOVERY - Contains data but need recovery or corupted. PARTLY AVAILABLE - Contains data from an unresolved transaction involving a distributed database. 34. List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment to expand into another extend. Transaction Begins. An entry is made in the RES header for new transactions entry Transaction acquires blocks in an extent of RBS The entry attempts to wrap into second extent. None is available, so that the RBS must extent. The RBS checks to see if it is part of its OPTIMAL size. RBS chooses its oldest inactive segment. Oldest inactive segment is eliminated. RBS extents The Data dictionary table for space management are updated. Transaction Completes. 35. How can we plan storage for very large tables ? Limit the number of extents in the table Separate Table from its indexes. Allocate Sufficient temporary storage. 36. How will you estimate the space required by a non-clustered tables? Calculate the total header size Calculate the available dataspace per data block Calculate the combined column lengths of the average row Calculate the total average row size. Calculate the average number rows that can fit in a block Calculate the number of blocks and bytes required for the table. After arriving the calculation, add 10 % additional space to calculate the initial extent size for a working table. 37. It is possible to use raw devices as data files and what is the advantages over file. system files ? Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk. Disk Corruption will be very less. 38. What is a Control file ? Database's overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable. 39. How to implement the multiple control files for an existing database ? Shutdown the databse Copy one of the existing control file to new location Edit Config ora file by adding new control file.name Restart the database. 40. What is meant by Redo Log file mirrorring ? How it can be achieved? Process of having a copy of redo log files is called mirroring. This can be achieved by creating group of log files together, so that LGWR will automatically writes them to all the members of the current on-line redo log group. If any one group fails then database automatically switch over to next group. It degrades performance. 41. What is advantage of having disk shadowing/ Mirroring ? Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switchover to place of failed disk. Improved performance because most OS support volume shadowing can direct file I/O request to use the shadow set of files instead of the main set of files. This reduces I/O load on the main set of disks. 42. What is use of Rollback Segments In Database ? They allow the database to maintain read consistency between multiple transactions. 43. What is a Rollback segment entry ? It is the set of before image data blocks that contain rows that are modified by a transaction. Each Rollback Segment entry must be completed within one rollback segment. A single rollback segment can have multiple rollback segment entries. 44. What is hit ratio ? It is a measure of well the data cache buffer is handling requests for data. 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)
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 Paper 15.pdf. Oracle Placement Paper 15.pdf. Open. Extract.
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