How many sub queries can you combine together ?
Answers were Sorted based on User's Feedback
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is an intent lock?
What is db2 isolation?
What is the maximum length of sqlca?
How to run db2 command in windows?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is cursor in dbms?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is lock escalation?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How do you define a correlated name?