SQL Quiz 8 Copy

Question 1 of 15

1. Question

What is used to retrieve data from multiple tables?

Concat
Join
Add
find

Question 2 of 15

2. Question

Which of the following are valid SQL joins

inner join
full join
left join
right join

Question 3 of 15

3. Question

Which of the following is the functionality of inner join

creates a new table (not physical) by combining rows that have matching values in two or more tables
returns all rows from the left table, and the matching rows from the right table
all records from the right table , and the matching records from the left table
returns all records when there is a match in left (table1) or right (table2) table records

Question 4 of 15

4. Question

Which of the following is the functionality of left join

creates a new table (not physical) by combining rows that have matching values in two or more tables
returns all rows from the left table, and the matching rows from the right table
all records from the right table , and the matching records from the left table
returns all records when there is a match in left (table1) or right (table2) table records

Question 5 of 15

5. Question

Which of the following is the functionality of right join

creates a new table (not physical) by combining rows that have matching values in two or more tables
returns all rows from the left table, and the matching rows from the right table
all records from the right table , and the matching records from the left table
returns all records when there is a match in left (table1) or right (table2) table records

Question 6 of 15

6. Question

Which of the following is the functionality of full join

creates a new table (not physical) by combining rows that have matching values in two or more tables
returns all rows from the left table, and the matching rows from the right table
all records from the right table , and the matching records from the left table
returns all records when there is a match in left or right table records

Question 7 of 15

7. Question

Which join returns all records from the right table, and the matching records from the left table

left join
right join
outer join
inner join

Question 8 of 15

8. Question

Which of the following is not an outer join?

left join
right join
full join
cartesian join

Question 9 of 15

9. Question

Cartesian join fetches the common values from multiple tables

True
False

Question 10 of 15

10. Question

What is not the type of join?

Cross join
inner join
intersection join
right outer join

Question 11 of 15

11. Question

The output of cartesian join and full outer join is same

True
False

Question 12 of 15

12. Question

Left outer join output and right outer join output is different

True
False

Question 13 of 15

13. Question

Which statement is used to rename a table?

Rename
Drop
Update
Delete

Question 14 of 15

14. Question

What is the correct Syntax of join?

Select * from table_1 Join table_2;
Select a.* from table_1 a,table_2 b where a.column1=b.column2;
Select * from table1 union table2;
Select join from table1 join table 2 where column1=column2;

Question 15 of 15

15. Question

What is true about cartesian join?

all records from the right table, and the matching records from the left table
all records from the left table, and the matching records from the right table
there is a join for each row of one table to every row of another table.
none of the above

Quiz Summary

Information

Results