Question

Read the table Student Carefully and perform the following actions on it: 10

Roll_No Name Percent Result

101 Amit 22 Fail

102 Reena 67 Pass

103 Bhavesh 56 Pass

104 Seema 87 Pass
1 Write command to create the table Student with the following Attributes.
2. Write the output of :

i) Select * from Student where Roll_No=101 or name=”Bhavesh” ;

ii) Select Roll_No, Result from Student ;

3. Show all the records of the table.

4. Show those records where Percent is greater than 60.

5. Display records in the Ascending order of Name.

6. Increase by 5% in all the Rows of Percent by Update command.

7. Delete the record where Roll_no is 101.

8. Delete all the records of the table.

9. Insert a record in the table. ( 105, Ramesh, 77, Pass )​

Answer 1

Answer:

9focus.... Wait , let me find a way...what I can do....let her answer...others will be reported