SQL Joins mcqs Quiz

After Simple Quiz and MCQs on Stored Procedures.Try for this simpel Quiz.

SQL JOINS

1.___________can be specified in the FROM clause only. Inner joins Outer joins Cross joins None of above 2.The_______________returns a number of rows equal to the product of all rows in all the tables being joined. Outer join Inner join Cartesian product Self Join 3._________return rows only when there is at least one row from both tables that matches the join condition. Inner joins Outer joins Self Join Left outer join 4.___________return all rows from at least one of the tables or views mentioned in the FROM clause, as long as those rows meet any WHERE or HAVING search conditions. Cartesian Product Inner Join Self Join Outer joins 5.To retain the nonmatching information by including nonmatching rows in the results of a join, use a _________. full outer join left outer join right outer join Any of above 6.________ is simple sql join condition which uses the equal sign as the comparison operator. SQL Equi Join SQL Non equi join Cross Join None of above 7._________is a sql join condition which makes use of some comparison operator other than the equal sign like >, <, >=, <= . Cross Join SQL Equi Join SQL Non equi join None of above. 8.A ___________that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. self join cross join outer join inner join 9.In self join ______ helps the query processor determine whether columns should present data from the right or left version of the table. where clause from clause table alias All of above 10.Which of the following Joins won’t work in SQL Server but only supports in Oracle. Cross Join Equi Join Self join Natural joins

http://www.highrankdirectory.com/blogs_diaries/garden_and_home/