1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

In a Distributed Database System Can we execute two queries
simultaneously ? Justify ?

Question Posted / swapna

Answers were Sorted based on User's Feedback



In a Distributed Database System Can we execute two queries simultaneously ? Justify ?..

Answer / swapna

As Distributed database system based on 2 phase commit,one
query is independent of 2 nd query so of course we can run.

Is This Answer Correct ?    6 Yes 1 No

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?..

Answer / vishal

Yes It is possible only when commit is applied for two different tables, but when the same table is used on diff environemnt then It is not possible.

Is This Answer Correct ?    0 Yes 0 No

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?..

Answer / g sivanagaraju

No, server will do only one operation at a time

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What's the procedure?

0 Answers  

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

what is single byte over head in oracle..?

0 Answers  

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

real time applications of nullif?

3 Answers  




how will u find statistics of a database objects?

2 Answers   iFlex,

How do you go back in sql?

0 Answers  

define data blocks ? : Sql dba

0 Answers  

What does the file extension accdb stand for?

0 Answers  

How to return more than one value from a function?

11 Answers   Satyam,

what is column? : Sql dba

0 Answers  

Types of backups ?

3 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories