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

Questions asked in this paper

• 2) Figures to the right indicate maximum marks for a question

1. Q1 (A) Attempt any sub-questions from (a), (b),(c) in MS-EXCEL 2 marks
   • (a) Wecan the worksheets in a workbook
   • (b) the function, the interest rate is assumed to be constant
   • (c) When data is sorted some rows may be hidden
   • (B) Attempt any sub-questions from (d), (e),( in MySQL 2
   • (d) A Database contains one or
   • 1) Tables, 2) Databases
   • 3) Columns. 4) Rows
   • (e) view the names of databases the statement Is =
   • (f) To not save the transaction we use
   • (C) Attempt any sub-questions from (g),(h),(i in Data Communications, Networking and I t. (True/False) 6
   • (g) A metropolitan area network can ral LANs
   • (h) to Peer networks are designed for than 100 users
   • (i) aclient-server architecture all co ers are equal
   • (j) Data Communication can take wired media
   • (k) optic cables are cheaper then axial cables Blog is a digital diary
   • (m) IP addresses are easier to as compared to Domain.names i (0) SMTP are the used for sending and receivirig
   • (D) Attempt any sub-questions from in Data Com Networking and Internet, (Multiple Choice) 5
   • (p) used in OSI model is the central device used in star
   • (r) ~ topology all the nodes are connected to a single cable ) Bus 2) Ring 3) Star 4) None of these & Of the following {s nota protocol, stands for Transmission Protocol ably is the task of layer in
   • (u) Message segmentation and ing data between II form of URL
2. Q2 (A) Answer any from (a), (b) in Data Communications, (8) ey Networking and Internet
   • (a) Write anote on LAN and MAN. S
   • (b) Star and Bus topology
   • (B) Answer any sub-question from (c), (d) in Data <= Communications, Networking and 7
   • (c) the different uses of internet. ~>
   • (d) Search Engine and Meta Search Engine. ww
3. Q3 (A) Answer anyone sub-question from (a), (b) in 8 marks
   • (a) MySQL statement to create a table calle OSIT having the columns Deposit Number( DN, integer, ary key), Deposit Code(DCODE, character with variable 10 columns), Amount (AMT, width of 8 including 2 decimals and Date of Registration (DRT, date, should not pty)
   • (b) statement to create called MARGIN having Account holders Name( AN columns), Gender( GEN an) Margin Should not be y) and Date of account( DACC, Date),
   • B) Answer any of
   • (c) Explain the foll 0 (c), (d) in (7) 9
   • d) The ists a R ed COLLEGE having the followi the following e of Admission(DA, date), Write of 6 with 2 il) Change the s (CO,
   • iv) Change th the table wh ‘oll Number 57, Change the date of admi ere fees paid Monaz Mehta’ to} Ssion of the Student ave negative, une 10, 2015, Whose name is V) Insert one row of data in the table with Roll Number 715, Students Name ‘Hiral Jain’ and Date of Admission July 23, 2015
   • vi) Change the name of the column Roll Number to RNO,
   • vii) Rename the table COLLEGE as MARK
4. Q4 (A) Answer any from (a), (b) in MySQL 8 marks
   • (a) There exists a table ELECTRIC having the columns Consumer number (MNO, character), type of connection (TYPE, character) and Write MySQL queries for the following
   • i) Display Consumer name, meter number and bill amount where the bill amount is equal to or above the average bill amount
   • ii)Display the Consumer number, type of connection and bill amount where the bill amount is equal to the highest bill amount
   • iii)Display Type of connection, maximum bill amount and total bill x amount of such connections grouped according to Type
   • iv)Display consumer number, meter number and bill amount the consumer number is odd
   • v)Display all the rows in the ascending order of bill
   • (b) There exists a table TRAVEL containing columns cu number destination (DEST, character). There exists an table DETAILS containing the columns customer number ( amount quoted (QUOTE, integer)and date of travel Date) Write MySQL queries for the following Display Customer number, customer. and amount quoted for those having holiday destination using both the tables li) Display Customer number, estination and date of travel for those customers whege ate of travel is after October 15, 2015 using both the lif) Display Customer numb d amount quoted from the table DETAILS for those c ers where the amount quoted is equal to the highest amo
   • iv) Display amount quoted and date of travel from the table or those who want to travel in the month of Vv) Display from the table TRAVEL where the holiday
5. Q4 (B) sub-question from (c), (d) in MySQL ZN, Integer), name of the employee (NAME, character), department S name (DEPT, Character), provident fund amount (PF, numeric) and date of deduction (DEDDT, date). Write MySQL queries for the 7 marks
   • i) Display the department average of provident fund amount and minimum of the provident fund amount grouped as per it) Display ine fund amount grouped as per department. mber, name of the employee and
   • iii) where the amount is above average ti table where the employee number is
   • iv) Display @ h columns for emp!
   • (d) There exists employee name (EMP_NAM E, character), job character), Write MySQL queri (SAL, numeric), and hire date (H_DATE, queries for the
   • i) Display all the rows from this table
   • ii) Display the name and hire date of all employees who do not
   • iii) Display the employee name labeled as ‘Name of the Emplo salary labeled as ‘Monthly Salary’ from the table
   • iv) Display the employee id, job id and salary of manager id is 505 or 509. )
   • v) Display the employee id, employee name and of emplo whose the salary is 25,000 or more. cS yees
   • vi) Display all the rows in the descending date
   • vii) Display all the rows where the second in the employee , (b) in MS-EXCEL Ps to obtain i 5% of the Basic or 10,000 wht 5110% of the B ichever less asic rounded to the ne A column C TOTAL as eger in lv) TAX as 33 A+HRA in colum
   • (b) Answer the following using MS-EXCEL Write the steps to obtain the Total, Average, Highest and Lowest f month of January and for the month of February in
6. Q5 (B) Answer any one sub-question from (c), (d) in 7 marks
   • (c) Inthe following worksheet the cost of machinery is e A4 its estimated life in years is entered in cell A7 no Write the steps to year wise depreciation and WDV in columns C and D is computed using reducing
   • (d) Explain the built in functions in MS-EXCEL

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