SQL Server Interview Questions
Questions Answers Views Company eMail

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 3153

one table has four field id,name,design,salary. i have to find maximum salary .

6 5862

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 9649

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 3908

How to find the date and time of last updated table?

Teledata,

6 7820

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 22350

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 7754

What value could be assigned to Varchar Type?

3 4693

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 4471

What types of integrity are enforced by a foreign-key constraint

1 3610

What are the main control-of-flow T-SQL constructs?

1 4156

What are the two virtual tables SQL Server maintains for triggers?

3 7279

What does the INSTEAD OF trigger do?

3 6420

What are explicit and implicit transactions?

BirlaSoft,

4 20484

What are the two types of concurrency?

4 6615


Un-Answered Questions { SQL Server }

Write a SQL queries on Self Join and Inner Join.

621


How do I install only the client tools of sql server 2000?

557


Do you know what is sql service broker?

543


How many types of stored procedures are there in sql server?

564


What are built in functions?

584






How to concatenate two character strings together?

576


Can a table have 2 primary keys?

515


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

650


what is bit datatype? : Sql server database administration

510


Some queries related to SQL

597


Can a database be shrunk to 0 bytes, if not, why?

645


Explain Capacity planning to create a database? and how to monitor it?

3763


Characterize join and name diverse sorts of joins?

533


What is difference in performance between insert top (n) into table and using top with insert?

543


What does set rowcount do?

518