which one will take 1st priority in case of insert statement and select statem

which one will take 1st priority in case of insert statement
and select statement???

Question Posted / priyadarsini.indira

2 Answers
5524 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which one will take 1st priority in case of insert statement and select statement???..

Answer / chigicherla mallikarjuna

select statement will take first priority

Is This Answer Correct ?

10 Yes

0 No

which one will take 1st priority in case of insert statement and select statement???..

Answer / sandeep

I think that depends on locking system we choose. if we
implement high data availability then select statement will
wait for the completeion of insert or update statement. I
dont remember those locking systems rite now.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More SQL Server Interview Questions

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers RND Soft, Wipro,

why we use cursor?

4 Answers CarrizalSoft Technologies, Melstar, TCS,

Explain datetime2 data type in sal server 2008?

0 Answers

What is blocking and how would you troubleshoot it?

2 Answers

What is nonclustered index on computed columns?

0 Answers

What happens if date-only values are provided as date and time literals?

0 Answers

What is the difference between sdf and mdf?