1. How to reduce this fragmentation in Clustered index at depth 4(in general for all depth rows)
Don't bother trying. The highest level is the root, which is only a single page.
2. How to reduce frag for NC which too are at 100%
Same way you do for a clustered index. Alter index ... rebuild or Alter index .. reorganize
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass