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 |
What is the function of buffer manager?
What is runstats utility in db2?
Which component is responsible for processing sql statements and selecting access paths?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
what is db2 restart?
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.
how can we find nth max salary from A table
What is explain plan in db2?
What is PRIME TABLE and what are the uses of it
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?
Is db2 a database?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?