How would you create view objects to retrieve a form of jobs and table of Employees for each job?

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

How would you create view objects to retrieve a form of jobs and table of Employees for each job?

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

How would you create view objects to retrieve a form of jobs and table of Employees for each job?

A.
Create a read-only view object based on the query SELECT Employees. FIRST NAME,
Employees . 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 SELECT Employees.FIRST_NAME. Employees
.LAST_NAME, Jobs, JOB TITLE from EMPLOYEES Employees, JOBS Jobs WHERE
Employees.JOB_TXTLE=Jobs.JOB_TlTLE.

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

Explanation:
http://docs.oracle.com/cd/E12839_01/web.1111/b31974/bcadvvo.htm



Leave a Reply 2

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


Abdullah

Abdullah

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.