wt is view ? wht r the restrictions for view ?

Answer Posted / anjireddy vintha

view is a logical object which is derived from parent
table. view will be deleted automatically when patent table
is deleted.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the number of rows in db2 tables?

697


What do you mean by commit and rollback?

680


Differentiate between cs and rr isolation levels? Where do you specify them?

671


What is the use of value function?

728


What is difference between isnull and coalesce?

689






What is explain plan in db2?

673


What is the maximum number of columns in a db2 table?

828


What is the syntax for creating a table in the db2 database?

720


Explain dclgen.

808


What is the maximum size of a char data type in db2?

672


How can you find out the # of rows updated after an update statement?

732


How can you count the number of rows from a table tab?

722


Define check constraint.

721


Name the various locking levels available?

707


What is deadlock in db2?

677