Multiple choice technology programming languages

Which will be the best method to handle DB transactions if number of connections are limited?

  1. SetTransObject()

  2. SetTrans()

  3. SetDBTrans()

  4. SetLimitTrans()

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SetTrans() pools database connections by sharing a single connection among multiple Datawindows, releasing it after each transaction. This is efficient when connections are limited. SetTransObject() maintains a dedicated connection per Datawindow, which is more efficient for frequent database access but uses more connections.