|
|
Section-II |
|
|
34. |
Write a
function swap2List(arr,n) in Python, that would accept a list arr of n
numbers. The functions should modify the content of the List in such a way
that the elements, which are multiples of 5 swap with the value present in
very next position in the array. example if the
list arr contains: [1, 15, 7, 18, 20, 14] then after rearrangement the list should contain [1, 7, 18, 20, 14,
15] |
3 |
|
35. |
Write a function in Python that counts the number of “Me” or “My”
words present in a text file “STORY.TXT”. If the “STORY.TXT” contents are as
follows: My best word
is all right. My friend
is going to meet him. The
output of the function should be: Count of Me/My in file: 3 OR Write a function AMCount() in Python, which should read each
character of a text file STORY.TXT, should count and display the occurrences
of alphabets A and M (including small cases a and m too). Example: If
the file content is as follows: More apple
and mango trees have to be grown The AMCount() function should display the output
as: A or a: 4 M or m :2 |
3 |
|
36. |
Consider the table Books
given below. Write outputs of following SQL Commands for (i) to (iii) Book_Id Book_Name Author_Name Publishers Price Qty 1001 The Human J
P Singh TDH 550 10 1002 Ninety Nine W P Ram EPB 700 5 1003 Fast Cook Lata Kapoor Sagar 650 2 1004 Vidur H P
Nayak Hillman 250 7 1005 Officer K Prakash EPB 370 11 (i) SELECT
AVG(Price) FROM Book WHERE Qty>5; (ii)
SELECT Book_Name, Publishers From Book WHERE
Publishers like ‘T%’; (iii)
SELECT Book_Id FROM Book WHERE Price between 400
and 650; |
3 |
|
37. |
Write a function in Python PUSH(Arr), where Arr is a list
of numbers. From
this list push all numbers divisible by 5 into a stack
implemented by using
a list. Display
the stack if it
has at least one element, otherwise display appropriate error message. OR Write a function in
Python POP(Arr), where Arr is a stack implemented by a list of numbers. The
function returns the value deleted from the stack. |
3 |
|
|
Section-III |
|
|
38. |
Rehan
Consultants are setting up a secured network for their office campus at
Ahmedabad for their web-based activities. They have planning to have
connectivity between 3 Blocks and the head office situated in Delhi. Answer
the questions (i) to (v) after going through the building positions in the
campus and other details. Which are as: BLOCK-1 BLOCK-2 Head Office Delhi BLOCK-3 Ahmedabad Distance
between various buildings Block-1 to Block-2 120
m Block-1 to Block-3 45
m Block-3
to Block-2 65 m
Ahemdabad campus to Head office 1100
km Delhi Number of
Computers Block-1 40 Block-2 150 Block-3 30 Head office Delhi 20 (i) Suggest the
most suitable place (i.e., Block) to install the server of this office campus
with a suitable reason. (ii)
Suggest a cable layout of connection between the
blocks inside the campus. (iii)
Suggest the placement of following devices with justification (a)
Repeater (b) Hub/Switch (iv)
Organization is planning to connect high speed
link with its head office situated in Delhi using a wired connection. Which
of the following cables will be
most suitable for this job? 1. Optical fibre 2. Ethernet cable 3. Co-axial cable (v) Which
hardware device will
you suggest to be installed by company to protect
and control the internet used within the campus? |
5 |
|
39. |
Write SQL
commands for the queries (i) to (v) based on a table PRODUCT and CUSTOMER. |
5 |
|
|
|
PRODUCT |
|
|
|||
|
|
|
|
|
||||
|
PID |
CNAME |
PRODUCTNAME |
PRICE |
||||
|
111 |
SONY |
TV |
50000 |
||||
|
222 |
NOKIA |
MOBILE |
35000 |
||||
|
333 |
ONIDA |
TV |
25000 |
||||
|
444 |
SONY |
MOBILE |
42000 |
||||
|
555 |
BLACKBERRY |
MOBILE |
58000 |
||||
|
666 |
DELL |
LAPTOP |
65000 |
||||
|
(i) To show all the
product name of SONY company from product
table (ii) To display the
PID, PRODUCTNAME and CNAME of all products whose price between 25000 to 60000. (iii) To display PID,
PRICE and CUSOMTER_NAME from tables Product and Customer. (iv)
To increase the price of product MOBILE by 500 in
table PRODUCT. (v) To display
the PRODUCTNAME and QTY_ORDER from tables Product
and Customer where quantity orders are more than 10. |
|||||||
|
40. |
A binary file “Book.dat”
has structure [BookNo, Book_Name, Author, Price]. i. Write a user
defined function CreateFile() to input data for a record and add to
“Book.dat” . ii. Write a
function CountRec(Author) in Python which accepts the Author name as parameter and count and return number
of books by the given
Author are stored in the binary file “Book.dat” OR A binary file
“STUDENT.DAT” has structure (admission_number, Name, Percentage). Write
a function countrec() in Python that would read
contents of the file “STUDENT.DAT” and display
the details of those students whose percentage is
above 75. Also display number of students scoring above 75%. |
5 |
|||||
