Without Book Interview Questions and Answers | Online Test | Moct Test
Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Institute Training Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

SQL Interview Questions and Answers

Ques 11. SPOOL

Ans. SPOOL command creates a print file of the report.

Is it helpful? Add Comment View Comments
Ques 12. JOIN
Ans. JOIN is the form of SELECT command that combines info from two or more tables.
Types of Joins are Simple (Equijoin & Non-Equijoin), Outer & Self join.
Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause.
Non-Equijoin returns rows from two or more tables based upon a relationship other than the equality condition in the WHERE clause.
Outer Join combines two or more tables returning those rows from one table that have no direct match in the other table.
Self Join joins a table to itself as though it were two separate tables.
Is it helpful? Add Comment View Comments
Ques 13. Union
Ans. Union is the product of two or more tables.
Is it helpful? Add Comment View Comments
Ques 14. Intersect
Ans. Intersect is the product of two tables listing only the matching rows.
Is it helpful? Add Comment View Comments
Ques 15. Minus
Ans. Minus is the product of two tables listing only the non-matching rows.
Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2017 WithoutBook