Look at the above picture and choose the correct answer:
A. SELECT * FROM TableA t1 INNER JOIN TableB t2 ON t1.ID = t2.ID
B. SELECT * FROM TableA t1 LEFT JOIN TableB t2 ON t1.ID = t2.ID
C. SELECT * FROM TableA t1 RIGHT JOIN TableB t2 ON t1.ID = t2.ID
D. SELECT * FROM TableA t1, TableB t2 WHERE t1.ID = t2.ID
E. Both A and D
F. None of the above
Answers: [E]
Friday, September 28, 2012
Join quiz 1
at 10:50 PM
Labels: SQL Server 2005, SQL Server 2008, SQL Server Test, T-SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment