How would you create view objects to retrieve all information on Jobs and Employees in one table?

Consider the business components entity objects included in the following diagram:

How would you create view objects to retrieve all information on Jobs and Employees in one table?

Consider the business components entity objects included in the following diagram:

How would you create view objects to retrieve all information on Jobs and Employees in one table?

A.
Create a read-only view object based on the query SELECT Employees. FIRST NAME,
Enployees . LAST__NAME, Jobs, JOB_TITLE from EMPLOYEES Employees, JOBS Jobs
WHERE Employees. JOB_ID=Jobs. JOB_ID.

B.
Create a view object based on the Employees and Jobs entity objects and define the join type
and association used to reference the Jobs entity.

C.
Create a default view object based on the Employees entity object and a default view object
based on the Jobs entity object, and create a view link between the two view objects.

D.
Create a view object based on the query FIRST NAME, Employees . LAST__NAME, Jobs,
JOB_TITLE from EMPLOYEES Employees, JOBS Jobs WHERE Employees. JOB_ID=Jobs.
JOB_Title.

E.
Create a default view object based on the Employees entity object and a default based on the
Jobs entity object. In the Employees view object, create a view references the Jobs view object.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


achilles

achilles

Answers: B
Create a view object based on the Employees and Jobs entity objects and define the join type and association used to reference the Jobs entity.

Max

Max

How about ‘C’?