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 many memory layers are in the oracle shared pool?

1177

---

How to export data with a field delimiter?

1037

---

What is a server parameter file in oracle?

1055

---

What is meant by joins? List out the types of joins.

1024

---

What is null value in oracle?

1097

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2207

---

What is the database name in oracle?

1018

---

What is Java Pool in Oracle?

1165

---

How to experiment a data lock in oracle?

1054

---

How to create a new table by selecting rows from another table?

1081

---

Describe varray?

1056

---

How to start an oracle instance?

1016

---

What is set verify off in oracle?

1096

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1012

---

Can we commit inside a function in oracle?

962

---