Can I use LOCK TABLE on a view?



Can I use LOCK TABLE on a view?..

Answer / s

You can use LOCK TABLE on any table. View is not a
physical object.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is the function of buffer manager?

1 Answers  


What is runstats utility in db2?

0 Answers  


Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,


what is db2 restart?

0 Answers  


Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,


how can we find nth max salary from A table

5 Answers   IBM,


What is explain plan in db2?

0 Answers  


What is PRIME TABLE and what are the uses of it

1 Answers  


5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  


Is db2 a database?

0 Answers  


What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 Answers  


Categories