String Functions

Q1. Display each pet's name in UPPERCASE and its species in lowercase.

Q2. Format the output so it reads like a sentence: "[pet name] is owned by [owner]".

Q3. Create a short code for each pet consisting of the first 3 letters of its species in uppercase followed by the last 3 letters of pet's name.

Q4. Find the length of each pet's name and display only those pets whose names have more than 5 characters.

Q6. Display the event remarks after removing any leading or trailing spaces.

Numeric Functions

Q7. Display the rounded fee to 2 decimal places and truncated fee to 2 decimal places ,if the fee is Rs 125.6789

Q8. Assign pets into 2 alternate checkup groups(group1 or group2) based on whether their birth year is even or odd (using MOD).

Q9. Display the square root of each pet's birth year rounded to 2 decimal places.

Q10. Check the sign of the difference between 1995 and pet's birth year using SIGN().

Q11. Round the birth year of all pets to the nearest tens place (e.g., 1993 becomes 1990).

Q12. Calculate 2 raised to the power of the length of the pet's name .

Date & Time Functions

Q13. Select the current date, current time, and current timestamp in a single query.

Q14. Extract the birth year, birth month, and birth day for all pets.

Q15. Find all pets that were born in the month of May (Month 5).

Q16. Find all events that occurred in or after the year 1995.

Q17. Extract only the date part from a NOW() system call.

Q18. Demonstrate the difference between NOW() and SYSDATE() by running them with a delay using SLEEP().