DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?
where can we use index and subscript ? with example ?
Mention the location where the output received from explain statement is stored.
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
How does coalesce work?
What is meant by repeatable read?
what is cursor stability?
What is auditing?
how can we retrieve the 100 records of the file ?
When Can you be sure that a query will return only one row?
What is a page?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
wht displays the number of times a query modified ?