Differentiate between cs and rr isolation levels? Where do you specify them?
No Answer is Posted For this Question
Be the First to Post Answer
What are the three DB2 date and time data types and their associated functions?
What is precompiler in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Explain various types of locks in db2?
What is a bind card?
What is a lock?
Mention the downsides of page level lock.
What is normalization and what are the five normal forms?
Explain packages.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is the difference between TYPE 1 index & TYPE 2 index