1. Create a SQL Server Linked Server Using Transact-SQL.
2. Create a SQL Server Linked Server Using SQL Server Management Studio.
3. Display information about existing Linked Servers using command.
4. Perform CRUD operations using Linked Server.
5. Drop a Linked Server using Transact-SQL.
   
6. Does indexes always improve database performance? justify Ans.
   
7. Create a clustered index for any one column.
   
8. Create a nonclustered index for any one column.
   
9. Create a nonclustered index for two column.
   
10. Rename an index using the system stored procedure sp_rename.
    
11. Removes one or more indexes from the current database.
    
12. Create a job that insert data in every minute.
    
13. Create job for delete data at once in current day.
    
14. Create job for taking backup of database every month.
    
15. Create job with two schedule:
1. First schedule can insert data at every 4 minute(s) between 11AM to 11:30AM
2. Second can update data at every 2 minute(s) between 12:01PM to 12:30PM.

Note:

1. Upload screenshots containing query and its output in either jpg or png format.
2. Name of screenshot file name must be Question No. i.e. 1.jpg or 1.png.
3. Optional questions are not required to submit.