Interested to Buy Any Domain ? << Click Here >> for more details...
What is a heap related to database ?
- 1 Answers
- 7755 Views
- TCS, University of Edinburgh, I also Faced
- E-Mail Answers
Answer / dhaval kodrani
There is one database heap per database, and the database
manager uses it on behalf of all applications connected to
the database. It contains control block information for
tables, indexes, table spaces, and buffer pools. It also
contains space for the log buffer (logbufsz) and temporary
memory used by utilities. Therefore, the size of the heap
will be dependent on a large number of variables. The
control block information is kept in the heap until all
applications disconnect from the database
| Is This Answer Correct ? | 8 Yes | 2 No |
What do you understand by a database object? Can you list a few of them?
what are archived logs?
what is shell?
How to retrieve the count of updated rows?
How view is different from a table?
Explain oracle data types with examples?
Where is the export dump file located?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Which is better Oracle or MS SQL? Why?
What is a Garbage Collection? and what is full recursive Garbage collection?
Oracle General 
