BCom TY BCom Sem 5 BCom Sem 5 (2018 2019) Oct 2019 COMPUTER SYSTEM APLLICATION Question Paper - Mumbai University | munotes

Questions asked in this paper

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

1. Q2 (A) Answer any two. sub-question from (a), (b), (c) in MySQL
   • (a) Write MySQL statement to create a table called DONATION Name (DNAME, character with variable width 20 columns), Amount Donated (DAMT, integer) and Date of Donation (DT, date) 5
   • (b) There exists a table called DEPOSIT containing the columns Deposit character with width 10 columns), Amount (AMT, integer) and Date of Registration (DRT, date) Write MySQL statements for the following 5
   • i) Display the structure of the table DEPOSIT
   • ii) Enter the following one row of data in this table
   • iii) Increase amount by 25000 where deposit code is “SAVINGS”
   • iv) Change the size of the Column DCODE to 30 columns
   • v) Delete the column DRT
   • (c) There exists a table called STUDENT containing columns Roll Number (RNO, integer, primary key), Student Name (SNAME, character) and Date of Birth (DOB, date). There exists another table EXAM containing the Roll Number (RNO, integer), Class (CLASS, character) and Total Marks (TOT, integer) Write MySQL queries for the following 5
   • i) Display Roll Number, Student Name and Total Marks of all the students using both the tables
   • ii) Display Student Name, Date of Birth and Total Marks of all the students whose total marks are 400 or more using both the tables
   • iii) Display all the rows from the table STUDENT Paper Subject Code: 22920 Systems and Applications Answer anyone sub-question from (d), (e) in MS-EXCEL
   • (d) the following built in functions in MS-EXCEL 5
2. Q2 RATE() 3. ABS()
   • (e) The following data has been entered in a worksheet. Write steps to 5
   • i) Find total and average marks of in-column F and G
   • ii) Find the maximum average marks obtained in cell G7
3. Q3 (A) Answer any two. sub-questions from (c) in MySQL
   • (a) the following built-in functions in MySQL. 5
4. Q5 MONTH()
   • (b) There exists a table NCAR containing columns Registration Number (REGNO, character), Model of the Car (MAKE, character), Date of Purchase (DOP, date) and Value of the Car (Value, numeric) Write MySQL queries for the following 5
   • i) Display all the rows from this table where Value of the Car is above
   • ii) Display the Model of the Car labeled as ‘Make of the Car’ and Value of the Car labeled as ‘Price of the Car’ from this table
   • iii) Display the Registration Number, Model of the Car and Value of the Car purchased after March 22, 2015 from this table
   • iv) Display all the rows from this table in the descending order of
   • v) Display all the rows from this table where the second letter in the Model of the Car is ‘O’ There exists a table RAIL having the columns Station Number (SNO, (5) Write MySQL statements for the following
   • i) Display Station Number and Amount Collected from this table
   • ii) Display Station Number and Amount collected from this table where Amount Collected is equal to the Highest Amount Collected
   • iii) Display Station Name, maximum Amount and total Amount Collected from stations grouped by Station Names Paper Subject Code: 22920 Systems and Applications Answer anyone sub-question from (d), (e) in MS-EXCEL
   • (d) The following data has been entered in a worksheet: Based on these values, write steps to Arrange the data in the descending order of Name and further in the ascending order of n the following worksheet the cost of machinery is entered in ce 5
   • (e) the following worksheet th f machinery i din cell A4 and its estimated life in years is entered in cell A8 Write the steps to obtain the year wise depreciation and WDV in columns D where depreciation is computed using reducing 5
5. Q4 (A) Attempt any sub-questions from (a), (b),(c) in MS-EXCEL and - are called as date separators 2 marks
   • (b) Aformula may start with any symbol displays #### it means that it contains invalid data
   • (B) Attempt any sub-questions from (qd), (e),(f), (g),(h),(i) in 4
   • (d) that the values in the column are positive we use
6. Q1 Not Null 2) Unsigned 3) No Signed 4) Not
   • (e) Insert command is used
7. Q2 Into 3) To 4) From
   • (f) In MySQL, the operator LIKE "%A%" finds match for a string
8. Q1 Starting with A 2) ending with A 3) mixing with % 4) Containing A Paper Subject Code: 22920 Systems and Applications
   • (g) table statement to change the name of the column, we use
   • (h) When one query is written within another query it is termed asa
9. Q1 Sub query 2)Netquery 3) master query 4) None of these
   • (i) To arrange the data in alphabetical order is used
10. Q1 Sort by by 3) Order by 4) Limit
    • (C) Attempt any four sub-questions from (j), Communications, Networking and Internet. (True/False)
    • (j) In a data communication process, the sending device can only be a
    • (k) LAN network is larger MAN network
    • (1) In client-server architecture, all resources are controlled by the
    • (m) Fiber optic cable uses light to transmit data
    • (n) HTMLis used to create web pages
    • (D) Attempt any five sub-questions from (p),(q),(r),(s),(t),(u),(v),(w) in Data Communications, Networking and Internet. (Multiple 5
    • (p) is also called Data Transmission
11. Q3 Data Communication 4) None of these
    • (q) The exchange of information between computers is governed by a set of rules called topology all the nodes are connected with a single
12. Q1 BUS 2) Ring 4) All of these
    • (s) is the main function of the Network layer
13. Q3 segmentation and reassembly 4) routing
    • (t) Each web page has a unique address
    • (u) Ahyperlink can appear as
14. Q1 2) image only 3) both image and text 4) none of these Common protocol of the internet is
    • (w) — The symbol must appear in an email address

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