C_THR92_2305 Exam Dumps | You are creating a query that lists employee information such as name, address, and dependent information.

<< Prev Question Next Question >>

Question 10/39

You are creating a query that lists employee information such as name, address, and dependent
information. The query uses Personal Information as the driving table and joins the Dependents and
Address tables. You notice many employees are missing from the result set.

What are the reasons?

A. Personal Information is joined to both the Dependents table and the Address table with a left join.

B. Personal Information is joined to both the Dependents table and the Address table with an inner join.

C. Personal Information is joined to Address table with a left join and the Address table is joined to the
Dependents table with a left join.

D. Personal Information is joined to Dependents table with a left join and the Dependents table is joined
to the Address table with a left join.

Question 10/39

LEAVE A REPLY

Download PDF File