| 10g: Views [message #120255] |
Wed, 18 May 2005 10:32 |
myoraclejob
Messages: 14
Registered: May 2005
Location: New York
|
Junior Member |
|
|
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.
Wrong Answers: B, D, F
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
