BCom TY BCom Sem 5 BCom Sem 5 (2012 2015) Oct 2015 Computer Question Paper - Mumbai University | munotes

Loading PDF...

Older exam Oct 2015 - Computer Semester-end · BCom sem 5 (2012 2015) → Newer exam Oct 2015 - Business Eco III 1 Semester-end · BCom sem 5 (2012 2015) →

Questions asked in this paper

(1) All questions carry equal marks and are compulsory. (2) Figures to the right indicate maximum marks for the questions

(1) All questions carry equal marks and are compulsory. (2) Figures to the right indicate maximum marks for the questions
(1) (A) Attempt any one sub-questions from a, b, c in MS-Excel (True/False)
(a) can contain maximum three worksheets
(b) A function can have another function as its argument
(c) Once subtotal is added to the list, it cannot be removed
sub-question fr University
indicate th aT (il
(i at the (iv)
(f) decimal
(B) the (10, 3) DECIMAL At
(h r optic cab o in ata Com Name
to transmit date. wit
acts as a in one
(m) OS! model is network in a Star topology
(n) logs are used on provides fast e physical layer
(0) An IP address to block the inte er internet access (iv)
(D) is contains a set of sites
any five a search engine numbers separated
Send is a com pata C b
ere individual Al of th ra
Peer to Peer mputers ese
(r (iii) Network utars or nodes share the process! 8)
(il) Client/Server processing storage of
(s (i) Bus topolog (iv) None of th rbased Network ata with th
) The medium (ii) the nodes are (B) Atte
) (il) P nique ad P uter | ) All of th
(a) one Ring Text is called of these \
(B) Explain the in Name S rom a, b ext Ci
any one different typ and IP Text
(A (e) are the from orking and Inte
) ttempt Hacking types of (Data Comm met):
rite MySQL b-questions f ackers. ons? @ Networking an
width 2 eger, should o create egers and 2 variable lumns Bill N
any ( ENDER Quantity (ary
Explain sub-questic should not , Boolean), D , Student n followin
v) il nctions e) and r with
(ii) sion (DIV, chart following co (7)
(ili) D the Roll Number (AC r) and Name (S
(iv) Il the rows w f lectures att LL, integer ures attend AME, char
(v) y the here end ) as the fi ed (L acter)
2014 @ 15 University Question Papers
(A) Attempt any one sub-question from a, b In MySQL:
(a) There exists a table CUSTOM containing the columns Customer number (NO, integer), Customer
Name (CNAME, character), Balance due (BALA, numeric) and date of transaction (DT, date)
Write MySQL statements to: (8)
Display the customer number, minimum balance due and total of balances due grouped by
Display the customer number, maximum balance due and number of balances due grouped by
(iii) Display all the rows where the balance due is less than average balance due
(iv) Display all the rows where the name ends with ‘A’
(v) Display the customer number, balance due and date of transaction for date of transaction before
(b) There ny LIBRARY havi { the book
(BKNAME, character), Type of book value of the
book (VALU, numeric) and Date of Publication (DP, cate). Write MySQL queries for the following. (8)
all the rows from this table where the value of the book is below the average book value
(If) Display the columns books number, Name of the books and Date of Publication from this table
the value of the book is equal to the highest book
Display Type of book and average value of the books from this table grouped as per
(Iv) Display the Book Number, Value of the book and ‘scrap value’ which is 5% of the value of the
book from this table
(v) all the rows where the value of the book is above 1000
(B) Attempt any one sub-questions from c, d in MySQL: (7)
(c) There exists a table DEPT containing columns Employee number (ENO, integer). Employee name
(ENAME, character), Salary (SAL, numeric), There exists another table COMPANY containing the
columns Employee number (ENO, integer), Gender (GEN, character) and date of joining (DOJ, date)
Write MySQL statement to:
Employee Number, Employee Name and Date of Joining from these tables for employees
whose salary is above 35,000
(ii) Employee number, Employee name, Gender and date of joining from these tables for
employees whose salary is joining is after June 2013
(ili) Display all the from the table DEPT whose salary is below average salary
(iv) Display the name and salary from the table DEPT where the salary is either 30,0C0 or 40,CO0
There exists a table SALARY containing the columns Employee number integer), Employee
name (E_NAME, character), Taxable income (INC, numeric) and Income tax numeric)
Write MySQL queries for the following:
(i) employee number, employee name and the taxable income
(ii) Display employee name, Income tax and 5% of the Income tax as ‘Surcharge’ for all the
(ili) Display all the rows where the taxable income is above 5,00,000
(iv) Display employee number, employee name and income tax in the descending order of income
(v) Display the employee number, employee name and taxable income of the employees whose
name is ‘PATEL’
(vi) Display all the rows from this table where the employee name contain ‘S’
Display all the rows from this table where the income tax is between 50,000 and 1,00,000
Attempt any one sub-question from a, b in MS-EXCEL:
(a) The following data has been entered in a worksheet
Based on these values, write steps to (1) Arrange the data in the descending order of Name and further
in the ascending order of Department. (2) Arrange the data in the alphabetic order of Department and
further in the descending order of salary
b) following spreadsheet write the steps to obtain the fees classwise. (8)

Read from the scan above, so a character or two may differ. The scan is the original.

Report or request

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Related Resources

BCom Notes BCom Syllabus

Something wrong with this paper? Report it.

Connected Papers

BCom / Ty Bcom · 237 papers

Browse all →

Questions? Email contact@munotes.in

Done!