Scribd
Upload
6 views1 page

PL-SQL Chapter 3 Practical Questions (Without Answers)

Uploaded by

jhap53106
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views1 page

PL-SQL Chapter 3 Practical Questions (Without Answers)

Uploaded by

jhap53106
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

PL/SQL Chapter 3 Practical Questions (Without Answers)

1. Write a PL/SQL program to check whether a given number is even or odd.

2. Write a PL/SQL program to determine the grade of a student based on marks


using IF-ELSIF.

3. Write a PL/SQL program to check whether a given year is a leap year.

4. Write a PL/SQL program using CASE to display the name of the day based on day
number (1 to 7).

5. Write a PL/SQL program to calculate the factorial of a number using FOR LOOP.

6. Write a PL/SQL program to reverse a number using WHILE LOOP.

7. Write a PL/SQL program to display the first 10 natural numbers using LOOP.

8. Write a PL/SQL program to calculate the sum of digits of a given number.

9. Write a PL/SQL program to check whether a given number is prime or not.

10. Write a PL/SQL program to find the sum of first N natural numbers using FOR
LOOP.

You might also like