DBMS Lab Expriment-6 Full solution

 

Q1. Create a new column DoB in Student table. (Datatype will be date) 

Q2. Insert DoB for each Student in corresponding table using above instance of Student table. 

Q3. Find average of GPA round off to 2 decimal places. 

Q4. Find year of DoB of Student having less than 1000. 

Q5. Compute Age of each student. (Hint: take difference between year of sysdate and Student’s DoB) 

Q6. Display name of all Students in uppercase and name of college they applied in lower case. 

Q7. Find fourth alphabet of each student. (Hint: use substring)

 Q8. Find sID and sName of student whose sName has string length greater than 3. 

Q9. Find floor, ceiling and truncate (to one decimal place) value of average GPA. 

Q10. Display details of all students whose sID is even. 

Q11. Compute Square Root of 900 and 247 . 

Q12. Consider the string “Peter Piper picked a peck of pickled peppers. A peck of pickled peppers Peter Piper picked. If Peter Piper picked a peck of pickled peppers, Where the peck of pickled peppers Peter Piper picked?” Find 6th occurrence of string „pick‟. (Hint: use INSTR) 

Q13. Consider String „Satya Nadella‟ replace this using the key (Hint: use translate) a d e l N S t y 1 2 3 4 5 6 7 8 

Q14. Display sID, sname and DoB in this format „February 26, 2014‟ 

Q15. Convert the text ‟26/02/2014‟ to date. 

Q16. Compute on which date is next Saturday and last day of this month?

DBMS Lab Expriment-6 Full solution(Function Topic)

For Download - click Here