Compare a subselect to a join?

COBOL SQL Interview Questions

(Continued from previous question...)

Compare a subselect to a join?

Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a temporary work area for inner selects results while processing the outer select.

(Continued on next question...)

Other Interview Questions

• Which RDMS objects can you change with the SQL ALTER statements?
• What is an object?
• What is a NULL value? What are the pros and cons of using NULLS ?
• Where in a table are added column located ?
• What keyword does an SQL SELECT statement use for a string search?
• Describe the elements of the SELECT query syntax?
• What are foreign keys?
• What are correlated subqueries?
• How would you retrieve row from a DB2 table in embedded SQL?
• What is a tuple?
• More...