3i Infotech Placement: Sample Questions 42 - 43 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 42


Describe in Detail


What is difference between process and thread?


Table of Difference between Process and Thread
Heavy weightLight weight
Has its own memory space.Use memory of the process they belong to
Inter process communication is slow as processes have different memory address.Inter thread communication is fast as threads of the same process share the same memory address.
Context switching between the process is more expensive.Context switching between threads of the same process is less expensive.
Processes don՚t share the memory with other process- consider privacy and securityThreads share the memory with other threads of the same process- consider privacy and security

Question 43


Write in Short

Short Answer▾

Why can a “group by” or “order by” clause be expensive to process?


  • GROUP BY, ORDER BY is executed by the Oracle engine. At the end, this leads to overhead, because whole data has to be rearranged again.
  • Group by: Combines all the similar rows and displays only the distinct data. Combining and displaying distinct data is an overhead.
  • Order by: Sorts the data either in ascending order or in descending order. Sorting the data is an overhead.
  • Processing of “group by” or “order by” clause requires creation of Temporary tables to process the results of the query, depending on the size of the result set can prove to be expensive.

Developed by: