What are the advantages of using CASE statement?

  1. Combines multiple scans

  2. Reduce number of calls to the database

  3. Performs many small scans as compared to one large scan

  4. Makes more smaller calls to the database as compared to one large call


Correct Option: A,B

Find more quizzes: