which one is not the view feature..? ( choose one)
restrict data access
easy maintainance of complex queries
fast access
data independence
When 'select * from ' is given, oracle server checks for..
control files
redo log files
user_views data dictionary view
base table
data type of 'text' column stored in user_view column...
varchar2()
long
char()
lob()
simple view definition contains functions.....
True
False
which one is not the view feature..?
easy maintainance for complex queries
Which one is useful to check whether the columns in a join view can be updated...?
user_views
all_views
user_updatable_columns
dba_views
Which one is correct statement about inline views....?
inline view is a schema object
is a subquery used in where clause
inline view can't have group functions
none of the above
'ORDER BY' clause can be used in the creation of a view..?
The maximum columns that can present in a view..?
999
1000
1001
limit is only for tables....
How to change the definition of a view in a simple way..?
drop the view and create a new one
use CREATE OR REPLACE syntax
use ALTER VIEW syntax
use UPDATE sytax