Multiple choice technology programming languages

How can you UPDATE a table without using UPDATE? (Select 2)

  1. By Using a Self Join.

  2. By Using a Nested Join.

  3. By using a Volatile Temporary Table.

  4. By using a View.
Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

A self-join can update a table by joining it to itself and setting values based on correlated data. A view can also be used indirectly - some databases allow updating through simple views, or you can use INSTEAD OF triggers to perform updates through views. Nested joins don't perform updates, and volatile tables are temporary storage, not update mechanisms.

Keep practicing — related questions