Compare a subselect to a join?

Question Posted / guest

Compare a subselect to a join?..

join is more efficeint, Subselect can be written as a join.

Is This Answer Correct ?

0 Yes

0 No

More DB2 Interview Questions

How do I import a csv file into db2?

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

How do you stop a db2 database in linux?

Explain the contention situations caused by locks?

How to find the maximum value in a column in the db2 database?

What are the isolation levels possible ?

What is cursor stability?

what are the max. & min. no. of partitions allowed in a partition tablespace?

How to solve S0C7 abend with out using DISPlay in 10 mins?

Can you tell me how can you find out the # of rows updated after an update statement?

How is the SUBSTR keyword used in sql?

Why do we need reorg in db2?

For more DB2 Interview Questions Click Here