What is check constraint. Explain with example.
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between Primary key and unique index?
difference between group clause and order clause
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What is ALTER ?
What is the reason behind not using select * in embedded sql programs?
What are the prerogatives?
Once you create a view, where would information about the view be stored?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is the use of COMMAREA ?Minimum how much data we can pass from it?