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)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is raw datatype?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What are the logical operations?
How to define a sub function?
How many types of synonyms in Oracle?
What are the built-in functions used for sending Parameters to forms ?
What are the different oracle database objects?
Why do we need integrity constraints in a database?
definition of cluster and non-clustered index?
Why we use bulk collect in oracle?
What are the roles of dba?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to convert a string to a date in oracle database?
How to define a data field as not null?
In which language oracle has been developed?
