News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Advertisement

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;
  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

  1. It will return the fields customer_id, customer_name, branch_name

  2. It will return the fields customer_id, customer_name, branch_id, branch_name

  3. It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name

  4. It will return an empty set since the two tables do not have any common field name

  5. It will return an error since * is used alone for one table only

Answer: Answer is c
comments powered by Disqus
Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;