I have deleted my old wordpress database after backup it with a plugin "UpdraftPlus" but I keep the wp-content folder in the same old location which include all my attached files (PDF, Video, Audio, images) is it possible to restore the database in the same location? so I can reserve all my absolute links published in my posts.
Yes it is possible, one simple way is to delete wp-config.php and add wp-config-sample.php then open the site in the browser, it ask you to install the wordpress. So, install a fresh wordpress.
After that open your phpmyadmin, select the database which wordpress created for you, then check all tables of this database then select DROP, and confirm the action.
Now you have a wordpress site without database, after this go to import tab and select your old database, it took some time to revive your old db depending on the db size.