Once you create a view, where would information about the
view be stored?



Once you create a view, where would information about the view be stored?..

Answer / s

The CREATE statment is stored in the SYSIBM.SYSVIEWS

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,


What are the disadvantages of using VARCHAR?

3 Answers  


What is reorg in database?

1 Answers  


how to resolve -811

2 Answers   IBM,


EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  


define clustering index.

1 Answers  


What is reorg and runstats in db2?

1 Answers  


What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,


What is the difference between CS and RR isolation levels?

1 Answers  


how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


Categories