Which three statements about the EMP_DEPT view are true?

Exhibit:
View the Exhibit that displays a part of the Enterprise Manager Database Control page. Which three statements about the EMP_DEPT view are true? (Choose three.)

Exhibit:


View the Exhibit that displays a part of the Enterprise Manager Database Control page. Which three statements about the EMP_DEPT view are true? (Choose three.)

A.
You must specify aliases for the columns of the EMP_DEPT view.

B.
The EMP_DEPT view does not occupy storage space in the HR schema.

C.
The EMP_DEPT view is allocated space in the default tablespace of the SYS user.

D.
You can add a column to the view that is not an expression or does not belong to the base tables.

E.
You can access all the data in the EMPLOYEES and DEPARTMENTS tables, if you can access the EMP_DEPT view.

F.
When you select data from the EMP_DEPT view, the data is retrieved from the EMPLOYEES and DEPARTMENTS tables.

G.
You can restrict user access to the data in the EMPLOYEES and DEPARTMENTS tables by providing access through the EMP_DEPT view.



Leave a Reply 0

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