Question:Consider the following two tables:
1.  customers( customer_id, customer_name)
2.  branch ( branch_id, branch_name )
What will be the output if the following query is executed:

    Select *, branch_name from customers, branch 

A It will return the fields customer_id, customer_name, branch_name with a cartesian join 
B It will return the fields customer_id, customer_name, branch_id, branch_name with a cartesian join 
C It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name with a cartesian join 
D It will return an empty set since the two tables do not have any common field name 
E It will return an error since * should be for queries involving one table only 

+ Answer
C 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description