What is the meaning of + sign in a condition like where consumer.consumer _id = orders.consumer _id(+);

Options
- indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as in the result set.
- indicates that, if a consumer _id value in the consumer table exists in the orders table, all fields in the orders table will display as in the result set.
- indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as default value in the result set.
- indicates that, if a consumer _id value in the consumer table exists in the orders table, all fields in the orders table will display as default value in the result set.


CORRECT ANSWER : indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as in the result set.

Discussion Board
Wrong answer

IT will display all data from customers table orders table data will be displayed as NULL.

Ashutosh 08-26-2017 05:07 AM

Left Outer join

indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all data in the consumer table will display as in the result set. (Macthing+unmatched records form orders data will dispaly)

Dinesh 03-22-2017 03:10 AM

confusing wording

Some of these answers don't make sense to me. I think there may be a word missing from the first two. Shouldn't they end with: "...will display as NULL in the result set"?

Doug 01-13-2017 11:34 AM

left outer join

I thought that it would be all data from consumer even though there is no id in orders

john 01-29-2015 11:35 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement