Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



SQL Server Interview Questions
Questions Answers Views Company eMail

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 8086

What is the maximun sixes of .mdf in sql server 2005

1 3597

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 5025

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1875

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

Verizon,

2093

what is isolation level at dead lock?

Verizon,

2151

what r steps to we need to fallow b4 kill the process?

Verizon,

1 5408

If the job running very slow what is the action you do

1893

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1805

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

IBM,

2 5620

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2069

Working with TLogs

1832

How you trouble shoot when any job fails

1937

How to trouble shoot if unable to connect SQL Server

1992

If user is owning any SQL Objects, can we drop that user

2076


Un-Answered Questions { SQL Server }

Explain about sql server login?

1086


What is resource db in sql server?

1024


Explain what are commit and rollback in sql?

931


What are the types of indexing?

1082


Explain indexing and what are the advantages of it?

1028


What is difference between getdate and sysdatetime in sql server 2008?

1047


What does it mean to normalize data?

940


how to create a scrollable cursor with the scroll option? : Sql server database administration

1092


What happens if null values are involved in boolean operations?

987


What type of locking occurs during the snapshot generation? : sql server replication

1332


What is the difference between a primary key and a unique key? Are they the same?

1077


What is the purpose of indexing?

1044


Explain the microsoft sql server delete command? : SQL Server Architecture

1084


Do comments need to go in a special place in sql server 2005?

858


How do I create a stored procedure in sql server?

1034