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 partitioned table in Oracle?

1271

---

Please explain oracle data types with examples?

1132

---

What is redo log?

1116

---

How to select an oracle system id (sid)?

1123

---

What is columnar storage what is the advantage?

1121

---

How oracle handles dead locks?

1131

---

Explain the use of constraints option in exp command.

1083

---

What is oracle datasource?

1041

---

What is the relation of a user account and a schema in oracle?

1126

---

What is recovery manager(rman) backup in Oracle?

1232

---

What is a select query statement in oracle?

1030

---

What is tns name?

1029

---

What is oracle analytical function?

1233

---

what are archived logs?

2261

---

How to define an anonymous procedure without variables?

1196

---