DBMS-Object-Relational Database

DBMS-Object-Relational Database
61. In intra-operation parallelism,
  • the execution of a single query is done in parallel on multiple CPUs using shared-nothing parallel architecture technique.
  • multiple transactions are executed in parallel, one by each (CPU).
  • we parallelise the execution of each individual operation of a task, such as sorting, projection, join and so on.
  • the different operations in a query expression are executed in parallel.
Show Answer
62. In inter-operation parallelism.
  • the execution of a single query is done in parallel on multiple CPUs using shared-nothing parallell architecture technique.
  • multiple transactions are executed in parallel, one by each (CPU).
  • we parallelise the execution of each individual jopeation of a task, such a sorting, projection, join and so on.
  • the diferent operations in a query expression are executed in parallel.
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test