Can I use LOCK TABLE on a view ?
No. To lock a view, take lock on the underlying tables.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is an Oracle view ? 18.07.08
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view...Can a view be updated/inserted/deleted? If Yes - under what conditions? 16.05.08
A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is n...If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone? 01.04.08
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same...What is lock escalation ? 14.03.08
Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has aquired more locks than specified in NUMLKTS. Locks should be taken on obje...How does DB2 determine what lock-size to use? 14.03.08
There are three methods to determine the lock-size. They are: 1. Based on the lock-size given while creating the tablespace 2. Programmer can direct the DB2...What is Declaration Generator(DCLGEN) 09.03.08
DCLGEN is a facility that is used to generate SQL statements that describe a table or view. These table or view descriptions are then used to check the validity...What is view? Different types of view. 06.03.07
View - A view is a virtual table containing fields from one or more tables. A virtual table that does not contain any data, but instead provides an application-...What is the difference between view and materialized view? 04.08.06
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized View...What is lock escalation? 15.06.06
Lock escalation is the process of converting a lot of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a m...What is a view? How it is related to data independence? 08.03.06
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying bas...