SQL Server Interview Question and Answer Set 1

SQL Server Interview Question and Answer Set1

What are the four main query statements?

The main four query statements are:-
(a) SELECT 

(b) INSERT

(c) DELECT 

(d) UPDATE

 

What command do we use to rename a DB?

SP_RENAMEDB 'OLDNAME','NEWNAME'

alter database <databasename>
modify name=<newdatabasename>

What are functions?

Functions - the tasks or actions that software is intended to perform.

 

What is web server?

Web Servers are computers on the internet that host websites, serving web pages to the viewers upon request.

  

Which command using Query Analyzer will give you the version of SQL server and operating system?

Select @@version