SQL Server Interview Questions and Answers What is the maximum number of columns sorted using ORDER BY Clause in Select Clause? 16 columns. Category: SQL Server Date: 10/1/2010 12:32:08 PM Which NET-Libraries are not supported by named instances of SQL Server? Multiprotocol , Appletalk , or Banyan vines are the net Libraries supported by named instances. They.... Category: SQL Server Date: 10/1/2010 12:31:08 PM Which performance monitor counter is used to show the memory used by the process? The Performance Monitor Process: Working Set counter shows the amount ofmemory used by a process. Category: SQL Server Date: 10/1/2010 12:30:08 PM How many Logical tables are available in the triggers? Whenever the triggers are used there exists two logical tables viz. Deleted table and Inserted table.... Category: SQL Server Date: 10/1/2010 12:29:08 PM Which SQL Statement is used to show fragmentation information for data and indexes of the specified .... DBCC SHOWCONTIG. Category: SQL Server Date: 10/1/2010 12:28:08 PM When a table is create with a Primary Key, then what sort of integrity is maintained? Entity Integrity. As it defines the row as a unique entity for a particular table which is forced by.... Category: SQL Server Date: 10/1/2010 12:27:08 PM Which clauses are not supported by VIEW Creation Statement? While creating a VIEW one can not use ORDER By,COMPUTE BY,COMPUTE clauses. Also INTO Keyword and tem.... Category: SQL Server Date: 10/1/2010 12:26:08 PM Point out some disadvantages of CURSORS? 1. They Keep the network busy because of there roundtrip. 2. It is time consuming , so decreases th.... Category: SQL Server Date: 10/1/2010 12:25:08 PM What do you mean by Heap Table? These are the tables without clustered Indexes and possses one row in sys.partitions with index_id=.... Category: SQL Server Date: 10/1/2010 12:23:08 PM What is the maximum number of tables and views allowed in a FROM Clause? It has been ristricted to maximum of 16 tables and views. Category: SQL Server Date: 10/1/2010 12:22:08 PM How many conditions can be included under WHERE Clause in SELECT statement? No limit specified. Category: SQL Server Date: 10/1/2010 12:21:08 PM Are "" , 0, NULL one and the same thing in SQL Server? No, all the three are treated diffrently. "":- means empty string 0:- represents 0 value N.... Category: SQL Server Date: 10/1/2010 12:20:08 PM Write a query to select first 20 rows from a table having 100 rows? Select top 20 from table_name or Select * from table_name where count(*) <=20 Category: SQL Server Date: 10/1/2010 12:19:08 PM What does the DROP Table command do? DROP command will delete the data as well as destroy the structure of the table. Once applied the ta.... Category: SQL Server Date: 10/1/2010 12:18:08 PM What is the purpose of INSTEAD OF Trigger in SQL SERVER? INTEAD OF Triggers are the procedures whih are executed in place of a specific DML command which is .... Category: SQL Server Date: 10/1/2010 12:17:08 PM 1 2 3 4 5 6 7

Recent Answers How do you declare destructor in c#? kumar answered: by implementing finalize and dispose method What will be the result of this code Console.WriteLine(3/4 == 3.0/4.0); kumar answered: answer is 'false'