Question
Write a function search () to search a record in a binary file according to the student number entered by the user. Also display the message “Record not found” in case record not found in the file.
✓
Answer
Get the step-by-step solution for this question inside the Vidyadip app.
Get the answer in the appNeed a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Write the different types of plagiarism.
Write a program to create list of the random number and show the normal code and efficient code for buble sort. The program should implement through
functions.
functions.
Write a python program using function to accept a list as parameter and return the sum of all the list elements.
Xcelencia Edu Services Ltd. is an educational organization. It is planning to set up its India campus at Hyderabad with its head office at Delhi. The Hyderabad campus has four main buildings - ADMIN, SCIENCE, BUSINESS and MEDIA.
You as a network expert have to suggest the best network related solutions for their problems raised in (a) to (d), keeping in mind the distances between the buildings and other given parameters.
Shortest Distances between various buildings:
| ADMIN to SCIENCE | 65 M |
| ADMIN to BUSINESS | 100 m |
| ADMIN to ARTS | 60 M |
| SCIENCE to BUSINESS | 75 M |
| SCIENCE to ARTS | 60 M |
| BUSINESS to ARTS | 50 M |
| DELHI Head Office to HYDERABAD Campus | 1600 KM |
Number of Computers installed at various building are as follows:
| ADMIN | 100 |
| SCIENCE | 85 |
| BUSINESS | 40 |
| ARTS | 12 |
| DELHI Head Office | 20 |
(a) Suggest the most appropriate location of the server inside the HYDERABAD campus (out of the 4 buildings), to get the best connectivity for maximum no. of computers. Justify your answer.
(b) Suggest and draw the cable layout to efficiently connect various buildings ‘within the HYDERABAD campus for connecting the computers.
(c) Which hardware device will you suggest to be procured by the company to be installed to protect and control the internet uses within the campus?
(d) Which of the following will you suggest to establish the online face-to-face communication between the people in the Admin Office of HYDERABAD campus and DELHI Head Office?
(a) E-mail (b) Text Chat (c) Video Conferencing (d) Cable TV
Write a program which will find all such numbers which are divisible by 7 but are not multiples of 5, between 2000 and 2500 (both included). The numbers obtained should be printed in a comma-separated sequence on a single line.
Write a menu driven python program using function to do the following: 1. Reverse a Number, 2. Check whether a number is Palindrome or not and 3. To check whether it is Armstrong or not and 4 to exit. Program should continue till the user says 'no'
Write a function delrecord() to delete the record form the binary file “student”. The record should be deleted on the basis of student number.
How to Delete Indices, Rows or Columns From a Pandas Data Frame?
Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables.
Table: VEHICLE
| Code | VTYPE | PERKM |
| 101 | VOLVO BUS | 160 |
| 102 | AC DELUXE BUS | 150 |
| 103 | ORDINARY BUS | 90 |
| 105 | SUV | 40 |
| 104 | CAR | 20 |
Note:
•PERKM is Freight Charges per kilometer
•VTYPE is Vehicle Type
| NO | NAME | TDATE | KM | CODE | NOP |
| 101 | Janish Kin | 2015-11-13 | 200 | 101 | 32 |
| 103 | Vedika sahai | 2016-04-21 | 100 | 103 | 45 |
| 105 | Tarun Ram | 2016-03-23 | 350 | 102 | 42 |
| 102 | John Fen | 2016-02-13 | 90 | 102 | 40 |
| 107 | AhmedKhan | 2015-01-10 | 75 | 104 | 2 |
| 104 | Raveena | 2015-05-28 | 80 | 105 | 4 |
| 106 | Kripal Anya | 2016-02-06 | 200 | 101 | 25 |
Note:
•NO is Traveller Number
•KM is Kilometer travelled
•NOP is number of travellers travelled in vehicle
•TDATE is Travel Date
(i) To display NO, NAME, TDATE from the table TRAVEL in descending order of NO.
(ii) To display the NAME of all the travellers from the table TRAVEL who are travelling by vehicle with code 101 or 102.
(iii) To display the NO and NAME of those travellers from the table TRAVEL who travelled between ‘2015-12-31 ’and ‘2015-04-01 ’.
(iv) To display all the details from table TRAVEL for the travellers, who have travelled distance more than 100 KM in ascending order of NOP.
(v) SELECT COUNT (*), CODE FROM TRAVEL GROUP BY CODE HAVING COUNT(*)>1;
(vi) SELECT DISTINCT CODE FROM TRAVEL;
(vii) SELECT A.CODE,NAME,VTYPE FROM TRAVEL A,VEHICLE B WHERE A.CODE=B. CODE AND KM <90;
(viii) SELECT NAME,KM*PERKM FROM TRAVEL A, VEHICLE B WHERE A.CODE=B.CODE AND A.CODE=‘105 ’;
Write definition of a function MSEARCH(STATES) to display all the state names from a list of STATES, which are starting with alphabet M.
For example:
If the list STATES contains
The following should get displayed
MP
MH
MZ