Answer Posted / er. debashreet das

actually, size of a database can be calculated by various
factors:
1. total bytes allocated to the table, i.e., suppose we
create a table as
create table tr_deb(name varchar2(15), roll_no number(4),
branch varchar(20), photo blob(50));
then, total size will be 15 + 4 + 20 +50 = 89 bytes

2. also, calculate the primary and secondary extents. That
means we have to calculate the memory size required for
that table(relation), i.e., for tr_deb relation. This is
called primary extent.
3. Then, finally, we have to calculate(actually predict)
the secondary extent. Let us understand in this way:
suppose, our table "tr_deb" may be expanded in near future,
if students get admitted, then, we have to store their
address, phone number, etc. Again, we can decompose the
composite attributes into component attributes(sub-
attributes) and calculate their size(primary and secondary
extent)

How to define an anonymous block?

1070

---

How do I uninstall oracle 11g?

1037

---

How to write a query with a left outer join in oracle?

998

---

Explain an exception and its types?

1008

---

How to retrieve values from data fields in record variables?

1029

---

How to find out what oracle odbc drivers are installed?

976

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1894

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1626

---

Where is the export dump file located?

1078

---

How to use null as conditions in oracle?

999

---

What are the limitations oracle database 10g xe?

974

---

What are the oracle built-in data types?

1003

---

What is a view and how is it different from a table?

967

---

What is ADDM Advisor in Oracle?

1111

---