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

Which component is responsible for db2 startup and shutdown?

0 Answers  


What is copy pending and check pending in db2?

0 Answers  


How to see the structure of db2 table??

4 Answers   IBM,


how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,


How do I connect my db2 database to ibm?

0 Answers  


Explain various types of locks in db2?

0 Answers  


in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,


Name the lockable units in DB2?

0 Answers  


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,


What is filter factor?

2 Answers  


Highlight all the advantages that are attached to a package.

0 Answers  


How will fetch last 5 rows from table in db2

6 Answers  


Categories