BCom TY BCom Sem 5 BCom Sem 5 (2012 2015) 2015 Computer System 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 two sub-questions from (a), (b),(c) in Spreadsheet 2 marks
   • (b) Formulas must begin with an equality sign,
   • (c) PPMT function returns the interest payment for a given period for an investment based on periodic constant payments and a vonstant interest rate
   • (B) Attempt any two sub-questions from (d), in MySQL 2
   • (d) To open a database CLASS the Statement is
   • (e) In MySQL, SELECT *FROM: 4,2:
   • 1) all rows 2) rows: _ 3) 4th row twice 4) 4th and Sth rows
   • (f) that should integers and 2 decimal
   • 1) DECIMAL(8,2) 2) 3) DECIMAL(2,6)
   • 4) DECIMAL(2,8)
   • (C) Attempt any from in Data Communications, Networking and Internet 6
   • (g) Message is nota component of data communication,
   • (h) — In LAN: there'may than one server easy-to add/remove anode in star topology, Bach URE consists of three parts White hatate hackers who computer security for non-harmful reasons like to test the Security of thé system, Attempt anysfive from (5) Communications, Networking and Internet. (Multiple Choice) The fastest transmission media
   • Q. P. Code : 0930:
   • (r) form of HTTP is is a device using which we can segment a large network into smaller
   • (t) In ----------- topology all nodes are connected directly to a central system,
   • (u) The part before the @ symbol in an email address is ----------------,
   • 1) The Domain name 2) user name 3) subdomainname 4) None of
   • (w) _ ----------- allows user to search simultaneously on
   • 1) Server 2) Boolean search. search engine 4) none of these
2. Q2 (A) Answer sub-question from in Data Communications,
   • (a) Whatis networking?-Explain different types of
   • (b) short (ii)
   • (B) Answer any one sub-question from (c), (7 Explain hacking and types of
3. Q3 (A) Answer anyone from (a) , MySQL (8
   • (a) MySQL statement to table called ADMISSION having the columns Name of Student (SNAME, ‘character with variable width 15 columns, should Gender Boolean), Date of Birth (DOB, date, should not Fees Paid (FEES; integers and 2 decimal places, positive) : Write MySQL statement to create a table called ECHARGE customers using electricity provided by XYZ company having With variable width 20, not empty), Customer ‘character of fixed width 12, containing default entry anyone ~sub-question from (c), (d) in MySQL (7 the following built-in functions in MySQL
   • Q. P. Code : 09303
   • (d) exists a table called TYCLASS having the following columns Roll number (RN, integer), Name of the student (SNAME, character variable width 20), Subject offered (OPT, character width 10) and Marks obtained in SY(MKSY, Write MySQL Statements for the following
   • i) Display the structure of the table TYCLASS,
   • ii)To delete the row from the table TYCLASS where rol] number is 126, lii)Change the name of the column RN to RNO, the marks obtained in SY by 5 forall the students, Vv) Change the subject offered by the roll number 120 to ‘COMPUTER’
   • vi) Add a new column division (DIVI character width 1) to this table
   • vii) Rename the table TYCLASS to TYBCOMCLASS,
4. Q4 (A) Answer anyone sub-question from (a), (b) in MySQL 8 marks
   • (a) There exists a table RAIL having the columns Station Number (SNO, integer), Write MySQL statements for the following
   • i) Display Station Number, Station name and Amount Collected from this table, li) Display Station Number, Station Amount Collected is below the Display Station Name, maximum Amount and total Amount Collected from Stations grouped by Station Names
   • iv) Display Station whose Amount Collected is equal to the Highest Amount Vv) Display all. the rows-from. the. ascending order of amount There exists a table TRAVEL containing colunins Passenger Number (PNO, primary~ key); (PNAME, char(20)) and Age of There table JOURNEY containing decimal(6,2)) and Date of Trave} (DTR, date), Write MySQL for the following Display Passenger Passenger’s Name and Fare for those having Destination using both the tables, Number, Destination City and Date of Travel for those BS Whose Date of after May 15, 2017 using both the tables Number, Fare from the table JOURNEY for those equal to the highest Fare, Display “Passenger Number, Fare and Date of Travel from the table JOURNEY for want to travel in the month of the rows from the table TRAVEL where the name
   • Q. P. Code : 09303
5. Q4 (B) Answer from (c), (d) in MySQL 7 marks
   • (c) There exists a table OFFICE containing columns employee number (ENO, Integer), name of the employee (ENAME, character), department name (DEPT, and date of deduction (DEDDT, date), Write MySQL queries for the following
   • i) Display the department name, maximum Salary and minimum of Salary grouped as per department
   • ii) Display the department name, average provident fund amount and total of the provident fund amount grouped as per department
   • iii) Display the employee number, of the employee and Salary where the Salary is above the average Salary
   • iv) Display all the rows from this table where
   • (d) There exists a table BOOKS containing columns Number (ACNO, integer, primary key), Book. Name. (BNAME, character), Number of copies of the Value, integer) and Date of Write MySQL queries for the
   • i) the rows table:
   • ii) Display rows from alphabetical-ordér of book name
   • iii) Display the columns Account number, Book and Date of Publication
   • iv):Display. of thetableBOOKS, Display therows from this table where the date of Publication is after March Display this descending order of Value of the Display all the rows from this table where the first letter in the Book Name one from (a), (b) in MS-EXCEL (8)
   • Q. P. Code : 09303 Write steps to da the following:
   • i) Arrange data in the descending order of age and further in the order of Salary. =
   • ii) Arrange the data in the alphabetic order of and further in the descending order of F Name.
   • (b) For the following spreadsheet obtain the Showing total Salary and
6. Q5 (B) Answer any in The entered worksheet Write to obtain’ 7 marks
   • i) TOTAL marks in column F)
   • ii) AVERAGE marks as average of best three in column G, ili) HIGHEST marks:subject wise in cells B7, C7, D7 and E7 respectively, Explain the following builtin functions in MS-EXCEL

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