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
- Display all the records of table student.
- Display Roll Number, Name and Class of table Student
- Display records of students of class X.
- Display details of Sumit.
- Display records of student paying fees less than 3000.
- Display fee of Amit
- Display Class and percentage of Pushkar.
- Delete record of Amit
- Display the structure of table student
- Insert the following record in table student
5, "Suman", 'X', 3000, 70
SOLUTIONS
Ans 1. 79
Ans 2.
- Select * from student;
- Select RollNo, Name , Class from student;
- Select * from student where class = 'X';
- Select * from student where Name = 'Sumit';
- Select * from students where fee < 3000;
- Select fee from student where name = "Amit";
- Select class, percentage from student where name = "Pushkar"
- Delete from student where name = "Amit"
- Desc student;
- Insert into student values(5, "Suman", "X", 3000, 70);
No comments:
Post a Comment