Interested to Buy Any Domain ? << Click Here >> for more details...
What is a heap related to database ?
- 1 Answers
- 7842 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 |
How to display First 4 rows From Database Table?
What is a synonym? What are its various types?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What is an Oracle view?
Differentiate between translate and replace?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
How can we find the size of a database?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is index?
What is data file?
Oracle General 
