Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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 4512

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

1 2377

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

3 2874

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?)

1014

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,

1233

what is isolation level at dead lock?

Verizon,

1310

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

Verizon,

1 3201

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

993

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

916

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

IBM,

2 3463

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

1114

Working with TLogs

993

How you trouble shoot when any job fails

1016

How to trouble shoot if unable to connect SQL Server

1079

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

1151







Un-Answered Questions { SQL Server }

How to enter unicode character string literals in ms sql server?

138


What are different types of roles provided by ssrs?

25


What do you understand by a view? What does the with check option clause for a view do?

147


Explain user defined functions?

147


What are acid properties of transaction?

144






Can a table have 2 primary keys?

107


What are “lost updates”?

142


What is trigger explain with program?

105


what is hash nonclustered index

130


What is sqlservr.exe - process - sql server (sqlex?press)?

126


Is it possible to have clustered index on separate drive from original table location?

144


What is difference between unique and primary key?

106


What is the report model project?

23


What are dml (data manipulation language) statements in ms sql server?

144


What is t-sql script to take database offline – take database online.

137