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)

What is system tablespace?

1097

---

What are the different types of trigger and explain its various uses and functions?

1093

---

What is the usage of save points in oracle database?

964

---

What is the implicit cursor in oracle?

1105

---

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

4366

---

State and explain the different types of data models?

944

---

How to drop an index?

959

---

Explain oracle left join with an example?

1011

---

How to define a sub function?

1129

---

What is the purpose of save points in oracle database?

1118

---

Explain the use of record option in exp command.

1006

---

How to start your 10g xe server from command line?

1073

---

How to insert a new row into a table in oracle?

1165

---

Explain do view contain data?

1011

---

What the is the diff between local index and global index. give some example.

1638

---