Q: Consider the table below:How many rows were fetched after performing a full outer join?
SELECT * FROM table_A
FULL OUTER JOIN table_B
ON table_A.A=table_B.A;
A: 5
Q: Choose the query that matches the below image.
A: Select [List] from [Table A] Afull outer join [Table B] Bon A.value=B.valuewhere A.value is nullor B.value is null
Q: Which of the join operations do not preserve non matched tuples?
A: Inner join
Q: What type of join is needed when you wish to include rows that do not have matching values?
A: Outer join
Q: How many join types in join condition?
A: 5
Q: Which operations are allowed in a join view?
A: All of the mentioned
Q: Consider the below tables:Table 1: FoodsTable 2: CompanyHow many rows are fetched when the below query is executed?
SELECT *
FROM
Company a
LEFT OUTER JOIN
Foods b
ON a.company_id = b.company_id
WHERE a.company_id IS NULL
OR b.company_id IS NULL
ORDER BY company_name;
A: 1
Q: In SQL the statement select * from R, S is equivalent to
A: Select * from R cross join S
Q: In which case would you use a FULL OUTER JOIN?
A: You want all records (both matched and unmatched) from both tables.
Q: Which are the join types in join condition?
A: All of the mentioned