Advance SQL Concepts Introduction Test
This Test will cover Inner Join, Outer join, Cross join, SQL View, Sequence etc.
Q What type of join is used when you have to combine each row from the first table with each row of the second table ?
Q Which type of JOIN returns a table with the matched data of two tables then remaining rows of the right table and null for the left table's columns?
Q. What type of JOIN is used when you have to include rows that do not have matching values?
Q.What type of JOIN is used when you have to return rows that do have matching values?
Q.The following SQL Query is which type of join :
SELECT * from Student, Student_info where Student.id = Student_info.id
Q. How many tables can be joined using SQL JOIN ?
Q Select a incorrect statement from the following.
Q. SQL View is used to restrict data access.
Q. Which keyword is used with CREATE view statement to create View even if the table does not exist?
Q A table can also join to itself known as __________ Join.