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

How many triggers can be applied to a table?

0 Answers  

What packages are available to pl/sql developers?

0 Answers  

Define join and name different types of joins?

0 Answers  

What is referential integrity ?

3 Answers   BirlaSoft,

What is the maximum rows in csv?

0 Answers  




Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

what is oltp (online transaction processing)? : Sql dba

0 Answers  

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

What is the reports view in oracle sql developer?

0 Answers  

how to select unique records from a table? : Sql dba

0 Answers  

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

Does pl/sql support create command?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories