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

Is stored procedure faster than query?

0 Answers  

How do I access sql anywhere database?

0 Answers  

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

What is the difference between delete, truncate and drop command?

0 Answers  

Define commit?

0 Answers  




Why do we create views in sql?

0 Answers  

What are the types of operators available in sql?

0 Answers  

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

how can we find the select statement is indexed or not?

3 Answers   CTS,

What is replication id?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories