1. Engineering
  2. Computer Science
  3. find row size for the student table and the space...

Question: find row size for the student table and the space...

Question details

Find row size for the student table and the space required for the entire table. Assuming a 80% fill factor estimate primary data files. Ignore storage requirements for indexes , views and constraints.

Expected step answers are

  • Number of rows in a page
  • total number of pages required for the table
  • Total Table size in KB or MB
  • Total file size in Kb or MB

The student table has following 3 columns.

Student Table:

Id BIGINT not null

Name NCHAR(20) not Null

Branch NVARCHAR (64) null

The table contains : 100000 rows .

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution