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

Oracle Merge Statement Delta Detection

The MERGE Syntax by Ajay Nerumati Delta Detection in Oracle SQL Posted on  8. October 2016 Delta detection is a common task in every Data Warehouse. It compares new data from a source system with the last versions in the Data Warehouse to find out whether a new version has to be created. There are several ways to implement this in Oracle. Your source system delivers a full extraction every night, and you have to load only the changed rows into your Core Data Warehouse? You receive incremental loads from another source system every few minutes, but only a few columns are loaded into the Data Warehouse. In all these situations, you need a delta detection mechanism to identify the rows that have to be inserted or updated in your Data Warehouse tables. In this blog post, I want to show different methods in Oracle SQL that provide the subset of rows of a source table that were changed since the last load. All these methods are set-based, i.e. they can be executed in one SQL sta...
199 comments
Read more

FOREIGN KEY

Pre-requisits : General understanding of integrity constraints. Constrains are used to prevent invalid data into the table. Integrity constrains are business rules enforced on the data in a table. The enforced rules trigger whenever a row is inserted, updated, or deleted from that table and prevent data that does not meet the set rules. FOREIGN KEY :  Establishes and enforces a relationship between two tables or to the same table itself. The foreign key or referential integrity constraint, designates a column or combination of columns as a foreign key and establishes a relationship between a primary key or a unique key in the same table or a different table.  In the example below   Emp_child  table's deptno   has been defined as the foreign key ; it references the deptno column of the Dept_parent table. Implementation: Step 1 Create parent table DEPT_PARENT as follows: Create table DEPT_PARENT ( Deptno n...
79 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 comment
Read more