Ravi Coaching Centre

Q.28. What is the use of check constraint in MySQL? Explain using an example.
Ans: Check constraint checks for the validity or condition of a given field..
Example..
create table student
(Age int check (age>4));

Above example will check whether the age entered is more than 4 or not..and allows an entry only if the condition is true.

Q.27. Name the keyword used to (i) assign a value as no data (ii) avoid duplicate rows in SQL query.
Ans: (I) NULL (ii) UNIQUE

Q.25. Identify the errors and write corrected code after underlining errors:

Q.24. What will be the value of j and k after the ex*****on of following code:

int i=10,j=12;
if(i

CBSE results declared....100% result for all of my students...congrates to them...

Q.23. How may times, the following loop will execute?
int x=1, y=5;
x=x%y;
while(x>=0)
{
x++;
}
Ans. Infinite times.
Tip: if a number divided by another number, its remainder can never be negative, thus "x=x%y" will always results to 0 or more than 0 and because of this value of x in while loop, loop will always remains true and this loop will never end.

New batches starting....register those who want to and those who can give information to others....kindly share..