BCom TY BCom Sem 5 BCom Sem 5 (2019 2020) Oct 2020 COMPUTER SYSTEM APPLICATION PAPER I 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 anytwo_ sub-questions from (a), (b),(c) in spreadsheet 2 marks
   • (a) Shift key is used to select a non-contiguous range
   • (b) There are two types of cell references
   • (c) is adynamic summary of the data
   • (B) Attempt sub-questions from (d), (e),(f) in MySQL 2
   • (d) Toindicate that there should integers and 2 decimal positions we use
   • (e) When one query is written within another query itis termed
   • (f) In MySQL, the operator LIKE "%R" finds match for
   • i) Ending with Starting with iii) Containing R iv) Containing R%
   • (C) Attempt any six sub-questions from in Data Communications, Networking and Internet. (True/False) 6
   • (g) The data transmission can take place without a protocol server architecture, all resources are controlled by the server
   • (i) Inring topology failure of one node will not affect the functioning of the
   • (j) | Coaxial cable can be used over longer distances than twisted cable
   • (k) Abridge is using which we can larger network into two
   • (1). IP addresses are easier to remember Face book is asearch engine Emails cannot be sent with attachments
   • (D) Attempt any five. sub-questions from (p),(q),(r),(s),(t),(u),(v),(w) in Data Communications, Networking and Internet. (Multiple Choice) spans a number of cities and countries 5
   • i) LAN ii) MAN iii)WAN iv) None of these
   • (q) The transmission medium that carries the message is referred to as the topology are connected with a single cable
   • i)Bus ii) Ring iii) Star iv) None of these
   • (s). POP stands for
   • iii) Post Operate Protocol iv) None of these As the data packet moves from upper layers to lower layers, headers activity of updating a blog is called
   • (v) is a meta search engine
   • (w) AnIP address is made up of bits
2. Q2 (A) Answer any from (a), (b) in Data Communications, Networking and Internet 8 marks
   • (a) Explain i) MAN ii) WAN
   • (b) Write on Bridge and Router
   • (B) Answer any sub-question from (c),(d) in Data Communications, Networking and Internet 7
   • (c) electronic mail? State advantages and importance of e-mail
   • (d) Write short notes on sniffing and spoofing
3. Q3 (A) Answer any one_ sub-question from (a), (b) in MySQL 8 marks
   • (a) Write MySQL statement to create a table called PAYROLL having the columns character with variable width 25 columns, should not be empty), Date of Joining (DOJ, Date) and Salary (SALARY, width of 9 including 2 decimals, default value
   • (b) Write MySQL statement to create a table called ABFOUNDATION having (DNAME, character with width 20 columns), Donor Email Address (DEmail, character with variable width 15 columns), Amount Donated (DAMT, integer, not negative), Date of Donation (DT, Date)
   • (B) Answer any sub-question from in MySQL 7
   • (c) Explain the following built-in functions in MySQL
   • (d) There exists.a table FLIPKART having the columns Customer Number (CNO, character), Total Cost (TCOST, integer) and Date of Purchase (PURDT, date) Write MySQL statements for the following
   • i) Display the structure of the table FLIPKART
   • ii) Enter the following one row of data in this table
   • iii) Delete the row where Customer number is 950
   • iv) Add anew column Discount (DISC, integer) at the end of the table FLIPKART
   • v) Change the Product Name to NOKIA for Customer name “Ramesh Shah”
   • vi) Change the size of the column CNAME to 25 columns
   • vii) Rename the table FLIPKART as FLIPCART
4. Q4 (A) Answer any one_ sub-question from (a), (b) in MySQL 8 marks
   • (a) There exists a table GOAIR having the columns Flight Number (FNO, integer), Write MySQL statements for the following
   • i) Display Flight Number, Destination Name and Fare Amount from this table
   • ii) Display Flight Number and Fare Amount for the records where Fare Amount is below the average Fare Amount
   • iii) Display PRN Number, Destination Name forthe records where Fare Amount is equal to the Highest Fare Amount
   • iv) Display Destination Name, maximum Fare Amount and total Fare Amount from the table for each Destination Name
   • v) Display all the rows from this table in the descending order of Fare Amount
   • (b) There exists a table ABPCOLLEGE containing columns Roll Number (RNO, There exists another table RESULT containing columns Roll Number (RNO, (PERCENTAGE, integer) and. Grade (GRADE, character) Write MySQL statements for the following
   • i) Display Name, Class, Total marks and Grade student with Total Marks more than 560 using both the tables
   • ii) Display Name, Class and Grade of students getting “O” Grade using both the
   • iii) Display Roll number and Total marks of students who have scored more than average using table RESULT
   • iv) Display Roll Number and Name of students whose Roll Number is divisible
   • v) Display all the records from the table ABPCOLLEGE of the class “T.Y.B.COM.”
5. Q4 (B) Answer anyone sub-question from in MySQL 7 marks
   • (c). There exist a table called BATAS containing columns Employee Name (ENAME, character), Department Name (DEPT, character), Date of Joining (DOJ, date), Salary (SALARY, numeric) and Age (AGE, integer) Write MySQL statements for the following:
   • i) Display Department Name, total salary and average Salary for each
   • ii) Display Date of Joining, minimum and maximum of the Salary as per date of
   • iii) Display all the rows where the Salary is equal to maximum Salary
   • iv) Display Employee Name, Department Name and Salary where Age is more
   • (d) There exists a table TAX having the columns Permanent Account Number (PAN, integer) and Income Tax (ITAX, integer) Write MySQL queries for the following
   • i) Display all the rows from this table where the first letter in the Name is ‘U’
   • ii) Display all the rows from this table in the descending order of Taxable
   • iii) Display the columns Permanent Account number, Name and Income Tax from this table
   • iv) Display Permanent Account number, Name and Taxable Income from this table where Income Tax is more than 200000
   • v) Display all the rows from this table
   • vi) Display the total Income Tax collected from this table and label it as TOTAL
   • vii) Display Name, City and Taxable Income of the Employee whose name is
6. Q5 (A) Answer from (a), (b) in MS-EXCEL 8 marks
   • (a) The following data has been entered in a worksheet Write the steps to create a Pivot table showing the average salary and maximum salary department wise in column G
   • (b). In the following worksheet the cost of machinery is entered in cell B2, number of years is entered in B3 of depreciation is entered in cell B4 Write steps to obtain the year wise depreciation DEP and written down value WDV in columns E and F respectively where depreciation is computed using 8
7. Q5 (B) Answer from (c) , (d) in MS-EXCEL 7 marks
   • (c) The following data has been entered in a worksheet: Write the steps to calculate
   • i) Commission at the rate of 15%
   • ii) Additional Commission at the rate of 20% or Rs.5000 whichever is
   • (d) the following built in functions in MS-EXCEL
   • 1.PV() 2. 4.SUM()
   • 5.MIN () 7. ROUNDDOWN()

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