Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 8

Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 8

Q1. Write the output of the following:

Select 76 + 75%4 from dual;

Q2. Write the queries of the following:

                                                Table : Student



  1. Display all the records of table student.
  2. Display Roll Number, Name and Class of table Student
  3. Display records of students of class X.
  4. Display details of Sumit.
  5. Display records of student paying fees less than 3000.
  6. Display fee of Amit
  7. Display Class and percentage of  Pushkar.
  8. Delete record of Amit
  9. Display the structure of table student
  10. Insert the following record in table student

              5, "Suman", 'X', 3000, 70


SOLUTIONS

Ans 1.  79
Ans 2.
  1. Select * from student;
  2. Select RollNo, Name , Class from student;
  3. Select * from student where class = 'X';
  4. Select * from student where Name = 'Sumit';
  5. Select * from students where fee < 3000;
  6. Select fee from student where name = "Amit";
  7. Select class, percentage from student where name = "Pushkar"
  8. Delete from student where name = "Amit"
  9. Desc student;
  10. Insert into student values(5, "Suman", "X", 3000, 70);

No comments:

Post a Comment

Most Recently Published

File Handling Test 6

 File Handling Test 6 Q1 . Do we need to use the close() function when we use 'with' statement to open a file? Q2. Which mode you wi...

CS - IP Assignment/Worksheet