BCom TY BCom Sem 5 BCom Sem 5 (2018 2019) Oct 2019 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 USE 2) DESCRIBE 3) SELECT 4) CREATE
   • (e) Two tables can be joined with the help of
2. Q1 ROLL BACK 2) COMBINE 3) 4) GROUP BY
   • (f) used to perform queries on table begins with
   • (C) Attempt any sub-questions from in Data Communications, Networking and Internet. (True/False) 6
   • (g) Anetwork can be used to share hardware and software
   • (h) Blogs are used to block Internet sites
   • (i) server based network individual computers or nodes share the processing and storage of data with the server
   • (j) Coaxial cable uses light to transmit data
   • (1) Ahub-sends signals to all devices on the network More than one device can have the same IP address on the Internet
   • (n) Acentral hub is required in bus topology
   • (D) Attempt any five sub-questions from in Data Communications, Networking and Internet. (Multiple Choice) 5
   • (p) is used as a source of light in ---------- transmission media
   • (r) topology requires a central controller or hub
3. Q1 Bus 2) Ring 3) Star 4) All of these
   • (s) protocols of FTP, SMTP & HTTP are contained in the layer of TCP Paper Subject Code: 23020 Computer Systems and Applications
   • Q. P. Code: 25112
   • (t) Therules for exchanging data between computers are called
   • (u) protocol is used to send email
   • (v) Domain name is used for commercial organizations
   • (w) The full form of ADSL is Digital Subscriber Line
4. Q1 Asymmetric 2) Asymptotic
5. Q3 Assembly 4) Applied
6. Q2 (A) Answer from (a), (b) in Data Communications, Networking and Internet 8 marks
   • (a) Write short notes on (i) Hub (ii) Router
   • (b) What is computer network? Explain its advantages
   • (B) Answer from (c), (d) in Data Communications, Networking and Internet 7
   • (c) Explain cybercrime & types of cybercrimes in brief
   • (d) Write short notes on (i) Search Engine (ii) Email
7. Q3 (A) Answer sub-question from in MySQL 8 marks
   • (a) Write MySQL statement to create a table called STORE having the following columns Item number (ITEMNO, unique integers should be incremented by 1 automatically), Item Name (INAME, character with variable width 20 columns), Quantity in Balance (QTY_BAL, Numeric, positive) and Unit Price (UPRICE, 5 integers and 2 decimals)
   • (b) Write MySQL statement to create a table called DONATION having the columns character with variable width 25 columns, should not be empty), Gender (GEN, Boolean), Amount Donated (DAMT, 5 integers and 2 decimal places) and Date of Donation (DDT, Date)
   • (B) Answer any sub-question from (c), (d) in MySQL 7
   • (c). Explain the following built-in functions in MySQL Paper Subject Code: 23020 Computer Systems and Applications
   • Q. P. Code: 25112
   • (d) There exists a table called STUDENT having the following columns Roll Class (CLASS, character width 15), Division (DIVI, character width 1) and Total Marks Obtained (TOTAL, integer) Write MySQL statements for the following
   • i) Display the structure of the table STUDENT
   • ii) Insert one row of data in the table having Roll Number 104, Student Name Class ‘F.Y.B.COM’, Division ‘G’, Total marks obtained 540
   • iii) Change the size of the column SNAME from Variable character (10) to
   • iv) Add a new column Gender (Gender, Character with variable width 1) before
   • v) For Roll Number 10, change the Students Name to ‘Dharmendra Shah’
   • vi) Delete the column DIVI from this table
   • vii) Rename the table STUDENT as
8. Q4 (A) Answer anyone sub-question from (a), (b) in MySQL 8 marks
   • (a) There exists a table CUSTOMER having the columns Customer Number (Amount, 6 integer and 2 decimals) and date of transaction (DT, Date), City Write MySQL queries for the following
   • i) Display customer number, amount due and city from this table
   • ii) Display customer number, customer name and amount due where amount due is more than the average amount due
   • iii) Display city, maximum and total amount due grouped by city
   • iv) Display all the rows where amount due is equal to the lowest amount due
   • v) Display the first five rows from this table
   • (b) There exists a table Employee containing columns Employee Number (ENO, Boolean) and Designation (Desg, Character). There exists another table PAY containing the columns Employee Number (ENO, integer, primary key), Basic Pay (BPAY, 5 integer and 2 decimal places) and Date of Join (DOJ, Date) Write MySQL queries for the following
   • i) Display employee number, employee name, gender and basic pay of those employees having basic pay more than Rs.8000 using both the tables
   • ii) Display employee number, employee name, designation, and date of joining for those employees whose name begins with ‘S’ using both the tables
   • iii) Display employee number, basic pay form the table PAY for those employees whose basic pay is above the average basic pay
   • iv) Display employee number, employee name and designation in the alphabetical order of employee name from the table employee
   • v) Display employee number, employee name and designation from the table employee where employee number is less than 50 Paper Subject Code: 23020 Computer Systems and Applications
   • Q. P. Code: 25112
9. Q4 (B) Answer anyone sub-question from (c), (d) in MySQL 7 marks
   • (c) There exists a table RAILWAYS containing columns Station Number Collected (AMT, numeric). Write MySQL queries for the following
   • i) Display the station number, maximum and minimum amount collected grouped as per station number
   • ii) Display the station number and total amount collected grouped as per station
   • iii) Display all the rows where the amount collected is equal to the maximum
   • iv) Display the station name, date and amount from this table
   • (d) There exists a table ADMISSION containing columns Roll Number (SNO, integer), Students Name (NAME, character), Date of Birth (DOB, date), Class Write MySQL queries for the following
   • i) Display all the rows from this table where name contains
   • ii) Display all the rows from this table where class is “T.Y.B.Com.”
   • iii) Display the student name in upper case and label it as ‘Name of the Student’ from this table
   • iv) Display the number of female students from this table
   • v) Display all the rows from this table in the descending order of roll numbers
   • vi) Display all the rows from this table where roll number is divisible by 7
   • vii) Display students name, date of birth and class from this table
10. Q5 (A) Answer any sub-question from (a) , (b) in MS-EXCEL 8 marks
    • (a) Answer the following using MS-EXCEL Given the worksheet Write steps to do the following:
    • i) Arrange data in the alphabetic order of Department and further in the order
    • ii) Arrange the data in the alphabetic order of NAME and further in the ascending order of SALARY Paper Subject Code: 23020 Computer Systems and Applications
    • Q. P. Code: 25112
    • (b) For the following spreadsheet obtain the Subtotals of the Fees Course wise NAME COURSE MOBILE NO. | FEES
11. Q5 (B) Answer anyone sub-question from (c), MS-EXCEL 7 marks
    • (c) For the following spreadsheet Write the steps to obtain
    • i) SIMPLE INTEREST in column B where simple interest= (P*N*R)/100
    • ii) COMPOUND INTEREST in column C where compound interest =P*(1+R/100) “N where P is AMOUNT, R is RATE and N is YEARS
    • iii) GAIN= COMPOUND INTEREST - SIMPLE INTEREST in column D
    • (d) — Explain the following built in functions in MS-EXCEL

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