PrepAway - Latest Free Exam Questions & Answers

Which join predicate should you use?

You are a database developer. You plan to design a database solution by using SQL Server 2008.
You have a database that contains a table and a table-valued function. The table valued function accepts the primary key from the table as a parameter.
You plan to write a query that joins the table to the results of the table-valued function.
You need to ensure that only rows from the table that produce a result set from the table-valued function are returned.
Which join predicate should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
CROSS APPLY

B.
OUTER APPLY

C.
INNER JOIN

D.
LEFT OUTER JOIN


Leave a Reply