Skip to main content

Unix and pl/sql problem statements

 

1 Shell Program to Swap Two Numbers

 2 Shell Program to Add Two Numbers

3 Shell Program to Find the Biggest of Two Numbers

4 Shell program to Find the Biggest of Three Numbers

5 Shell Program to Find the Area and Circumference of a Circle

6 Shell Program to Find the whether the given Number is Positive, Negative and Zero

7 Shell Program to Find the whether the given Number is Even or Odd

8 Shell Program to Find the whether the given Year is Leap Year or Not

9 Shell Program to Convert Fahrenheit to Celsius and Celsius to Fahrenheit

10 Shell Program to Find the Quotient and Remainder of two Numbers

11 Shell Program to check whether a number is divisible by 5

12 Shell Program to find the sum and average of four integers

13 Shell Program to compute simple interest and compound interest

14 Shell Program to calculate the sum of digits(without using loop)

15 Shell Program to Print the first “N” Odd  Number

16 Shell Program to Print the first “N” Even  Number

17 Shell Program to Find the Factorial of a given Number

18 Shell Program to Find the Factorial of a given “N”  Number

19 Shell Program to find the GCD of numbers 

20 Shell Program to Compute Power of X

21 Shell Program to Find whether the given Number is Prime or Not

22 Shell Program to Find the First “N” Prime Number

23 Shell Program to Find whether the given Number is Armstrong Number or Not

24 Shell Program to reverse the digits of a number 

25 Shell Program to find the sum of the digits of a given number 

26 Shell Program to execute various UNIX commands using Case Statements

Comments

rishav said…
As always....a helping hand..thank you for these questions as it clears our Basics..
Thank You
July 5, 2021 at 11:56 PM
Naveen_Kumar_Tangudu said…
this question helps a lot to make use of what we learn.
keep sharing the knowledge
July 5, 2021 at 11:57 PM
Sowmya Reddy said…
Thank you.Questions are helpful for practicing..Keep going.
July 6, 2021 at 12:05 AM
ANKIT ANAND said…
Thankyou. These questions helped alot for practicing our basics.
July 6, 2021 at 12:13 AM
Prateek Kumar said…
Thanks, these question were very useful to get a grip on the commands..
July 6, 2021 at 3:15 AM
Post a Comment

Popular posts from this blog

PL / SQL practice programs

  PL / SQL  practice programs 1. Write a program to print the following format WELCOME TO PL/SQL PROGRAMMING   BEGIN   DBMS_OUTPUT.PUT_LINE('WELCOME   TO   PL/SQL   PROGRAMMING'); END; /   2. Write a program to print the numbers from 1 to 100   DECLARE N NUMBER(3):=1; V VARCHAR2(1000); BEGIN WHILE N <=1000 LOOP V:=V||''||N; N:=N+1; END LOOP; DBMS_OUTPUT.PUT_LINE(V); END; / 3. write a program to print the even numbers from 1 to 100 DECLARE N NUMBER(3):=0; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 4. Write a program to print the odd numbers from 1 to 100 DECLARE N NUMBER(3):=1; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 5. write a program for multiplication table DECLARE A NUMBER(2):=&A; B   NUMBER(2):=1; C   NUMBER(3); BEGIN WHILE B <
5 comments
Read more

RDBMS MINI PROJECT

  Capgemini class room training.   RDBMS MINI PROJECT ( SPRINT ) LIBRARY MANAGEMENT SYSTEM   Table of Contents Serial No. Topic Name Content Page No. 1.   Introduction 1.1 Setup checklist for mini project 3     1.2 Instructions 3 2.   Problem statement   2.1 Objective 4     2.2 Abstract of the project 4     2.3 Functional components of the project 4     2.4 Technology used 5 3.   Implementation in RDBMS LOT 3.1 Guidelines on the functionality to be built 6 4.   Evaluation 4.1 Evaluation 7     1.      Introduction This document outlines a mini project for the RDBMS LOT
1 comment
Read more

sample tables

  --sample tables DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; DROP TABLE DUMMY;   CREATE TABLE EMP        (EMPNO NUMBER(4) NOT NULL,         ENAME VARCHAR2(10),         JOB VARCHAR2(9),         MGR NUMBER(4),         HIREDATE DATE,         SAL NUMBER(7, 2),         COMM NUMBER(7, 2),         DEPTNO NUMBER(2));   INSERT INTO EMP VALUES         (7369, 'SMITH',   'CLERK',      7902,         TO_DATE('17-DEC-1980', 'DD-MON-YYYY'),   800, NULL, 20); INSERT INTO EMP VALUES         (7499, 'ALLEN',   'SALESMAN',   7698,         TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600,   300, 30); INSERT INTO EMP VALUES         (7521, 'WARD',    'SALESMAN',   7698,         TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250,   500, 30); INSERT INTO EMP VALUES         (7566, 'JONES',   'MANAGER',    7839,         TO_DATE('2-APR-1981', 'DD-MON-YYYY'),   2975, NULL,
Post a Comment
Read more