Once you create a view, where would information

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

When a view is created, system information about the view is stored in SYSIBM.SYSVIEWS.

(Continued on next question...)

Other Job Interview Questions

• What are the three lock types?
• What technique is used to retrieve data from more than one table in a single SQL statement?
• How do you define a correlated name ?
• Explain the use of the WHERE clause?
• What is meant by repeatable read?
• What will the FREE command do to a plan?
• How to define the data items to receive the fetch items for the SQL?
• What information is held in SYSIBM.SYSCOPY?
• What is the cascade rule and how does it relate to deletions made with a subselect ?
• Where is the output of EXPLAN stored?
• More...