Hi @Ramdas Thatte ,
> restoring database in standby mode
The standby file allows a database to be brought up for read-only access between transaction log restores and can be used with either warm standby server situations or special recovery situations in which it is useful to inspect the database between log restores.
> When it is restored with move database files correctly get moved to proper location but sys.database_files.physical_name has the original path.
MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name'. Specifies that the data or log file whose logical name is specified by logical_file_name_in_backup should be moved by restoring it to the location specified by operating_system_file_name.
Refer to MS document RESTORE Statements - Arguments (Transact-SQL) and the blog StandBy option while restoring database to get more information.
If the response is helpful, please click "Accept Answer" and upvote it, thank you.