Oracle Views

Oracle views: interview questions

<<Previous  Next>>    

What is the content view and stacked view?       In a window that is displayed, the content view occupies the entire content pane............ Read answer Explain the different types of canvas views.       There are three types of canvas views:- 1.Stacked Canvas Views 2.Content Canvas Views.............. Read answer Explain the significance of OR REPLACE, FORCE and NOFORCE while creating view.       The syntax for creating a view is: CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view_name [alias[, alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint] ] [WITH READ ONLY].................. Read answer List out advantages of Views. Using Views, user’s access to the entire content of table can be restricted by allowing accessing only Views with only required columns of the table.................. Read answer List out the guidelines to create a View. The view’s column names are same as the table’s column name. New column names has to be explicitly listed in the CREATE View............... Read answer Also read Difference between a View and Materialized View View is created joining a single or multiple tables. It is an abstract of the data distributed in different tables........... Oracle views What is the content view and stacked view?, Explain the different types of canvas views, Explain the significance of OR REPLACE, FORCE and NOFORCE while creating view............. Explain how to view existing locks on the database. A number of data locks need to be monitored, in order to maintain a good performance level for all sessions, along with the time for which they last............. <<Previous  Next>>