Ravi Coaching Centre

12/08/2018

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.

17/03/2018

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

26/02/2018

This video will provide help for class xi and xii informatics practices students to find output.

14/11/2017

28/10/2017

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

06/08/2017

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

28/05/2017

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

07/05/2017

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.

05/04/2017

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