Search
Write a PL/SQL program to find area and perimeter of rectangle.
Consider a relation Employee with following attributes:
Name Null Type
-------------------------------- ----------------------- -------------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(3)
AGE NUMBER(3)
ESAL NUMBER(10)
a. List minimum , maximum , average salaries of employee.
b. What is the difference between maximum and minimum salaries of employees in the organization?
c. Display all employee names and salary whose salary is greater than minimum salary of the company and job title starts with ‘M’.
d. Display total salary spent for each job category.
e. Display lowest paid employee details under each manager.
create table emp with attributes (eid number,ename varchar2(10),age number,salary number);
a. Count number of employee names from employee table.
b. Display the Sum of age employee table.
c. Find grouped salaries of employees (group by clause).
d. Find salaries of employee in Ascending Order (order by clause).
e. Find salaries of employee in Descending Order.
Create table EMP with the following description :Name TypeEMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10)JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(3)AGE NUMBER(3) ESAL NUMBER
a. Get the description EMP table.
b. List all employees details.
c. List all employee names and their salaries, whose salary lies between 1500/- and 3500/- both inclusive.
d. List all employee names and their and their manager whose manager is 7902 or 7566 0r 7789.
e. List all employees who belongs to the department 10 or 20.
Write the code for the following problem using either C or C++. If there are 8 cars with its car number {11,10,34,56,68,89,65,78} parked in a parking area, then you are looking for a car number 68 by checking every car sequentially from the beginning.
IPL Match Details
Write a program that reads all the match outcomes and summarizes the information of all the matches.
Points are given to the teams based on the outcome of the match.
A win earns a team 3 points. A draw earns 1. A loss earns 0.
The following information is expected:
MP: Matches Played
W: Matches Won
D: Matches Drawn (Tied)
L: Matches Lost
P: Points. The team information should be displayed in descending order of points. Constraints: Names of teams may contain spaces but will be less than 24 characters
100 >= N >= 0.
input:6
CSK;RR;loss
RR;DD;draw
MI;KKR;win
KKR;RR;loss
CSK;DD;draw
MI;DD;draw
output:Team: RR, Matches Played: 3, Won: 2, Lost: 0, Draw: 1, Points: 7
Team: MI, Matches Played: 2, Won: 1, Lost: 0, Draw: 1, Points: 4
Team: DD, Matches Played: 3, Won: 0, Lost: 0, Draw: 3, Points: 3
Team: CSK, Matches Played: 2, Won: 0, Lost: 1, Draw: 1, Points: 1
Team: KKR, Matches Played: 2, Won: 0, Lost: 2, Draw: 0, Points: 0
Add two polynomials: Given two polynomials A and B, write a program that adds the given two polynomials A and B.
input:
4
0 5
1 0
2 10
3 6
4
0 -5
1 0
2 -10
3 -6
output:0
Write a program to find the hypotenuse H of a right-angled triangle of sides A and B.
Note: Pythagoras theorem states that, for a right-angled triangle. Hypotenuse2 = A2 + B2
Input
The first line is an integer, A.
The second line is an integer, B.
Output
The output should be an integer.
Explanation
In the given example, the first side A = 3, and the second side B = 4. To calculate the hypotenuse we use Pythagoras theorem.
According to Pythagoras theorem, hypotenuse2 = 32 + 42
Therefore, the hypotenuse value is 5.
So, the output should be 5.
Sample Input 1
3
4
Sample Output 1
5
Sample Input 2
12
5
Sample Output 2
13
#339914 on Dec 2023