Sem-2 Practical Practice Question1
Sem-2 Practical Practice Question1 Q.1 Write a program to create structure of employee with membersEmpid, EmpName, Qualification and EmpSalary by taking input of 5 employees display the employee whose qualification is “MBA” and salary greater than 20000. Solution. #include stdio.h> #include string.h> #define SIZE 5 // Define structure struct employee { int empid; char empname[50]; […]
Sem-2 Practical Practice Question Set-3
Sem-2 Practical Practice Question Set-3 Q.1 Write a program to create structure of employee with membersEmpid, EmpName, Qualification and EmpSalary by taking input of 5 employees display the employee whose qualification is “MBA” and salary greater than 20000. Q.2 Write a python program to print sum of N numbers using UDF. Q.3 Create following tables […]
Sem-2 Practical Practice Question3
Sem-2 Practical Practice Question3 Q.3 Create following tables with proper constraints and insert at least 5 records in each.dealer(dno, dname)item(item_id, item_name)order(ono, item_id, dno, order_date, amount)Perform following tasks:1. Display order detail with dealer name.2. Display total amount of each dealer.3. Display order date, dealer name whose amount is more than 600000.4. Display ordered detail item wise […]
Sem-2 Practical Practice Question2
Sem-2 Practical Practice Question2 Q.2 Write a python program to find average of numbers in a list. SOLUTION :- # Ask the user how many numbers they want to enter count = int(input(“How many numbers do you want to enter? “)) # Initialize an empty list numbers = [] # Take inputs one by one […]
Sem-2 Practical Practice Question1
Sem-2 Practical Practice Question1 Write a C program that creates structure student with sid, sname, sem,per(%). Take input of 5 students and display those student’s name who has achieved more than 70%. SOLUTION #include stdio.h> #include string.h> #define SIZE 5 // Define the student structure struct student { int sid; char sname[50]; int sem; float […]
Sem-2 Practical Practice Question Set-2
Sem-2 Practical Practice Question Set-2 Q.1 Write a c program that creates structure student withsid,sname,sem,per(%). Take input of 5 students and display those student’s name who has achieved more than 70%. Q.2 Write a python program to find average of numbers in a list. Q.3 Create following tables with proper constraints and insert at least […]
Sem-2 Practical Practice Question
PRACTICAL (206)_E PRACTICE PAPER -1 Q1 Write a C Program that creates structure Cricketer withcid, cname and total runs of 10 matches.(1) Input details of 5 Cricketers.(2) Display those cricketer’s name who have scored more than 500 runs. Q.2 Write a python program that performs the following:Ex. Inputted String : Hello Technocrates(1) Print all characters […]
Sem-2 Practical Practice Question3
Sem-2 Practical Practice Question3 Create following tables and apply appropriate constraints.Student (Rno, Studname, DOB)Subject (Sub code, Sub name)Result (Rno, Sub_ code, Marks)Create above tables with following constraints:1. Declare primary key and foreign keys in corresponding tables2. Marks must be between 0 and 100Insert 5 records in each table. SOLUTION. ✅ SQL Script to Create Tables […]
Sem-2 Practical Practice Question2
Sem-2 Practical Practice Question2 Write a python program that performs the following:Ex. Inputted String : Hello Technocrates(1) Print all characters by skipping 1 character (Output: HloTcncae)(2) Print entire string reverse (Output: setarconhceT olleH)(3) Print length of the String (Output: 18) Solution. # Input input_str = input(“Enter a string: “) # (1) Print all characters by […]
Sem-2 Practical Practice Question1
Sem-2 Practical Practice Question Write a C Program that creates structure Cricketer with cid, cname and total runs of 10 matches. (1) Input details of 5 Cricketers. (2) Display those cricketer’s name who have scored more than 500 runs Solution. #include stdio.h> #include string.h> #define NUM_CRICKETERS 5 #define NUM_MATCHES 10 // Define the Cricketer structure […]