BCom TY BCom Tybcom Others 2014-15 Computer Year Question Paper - Mumbai University | munotes

Questions asked in this paper

• (2) Figures to the right indicate maximum marks for the questions

1. Q1 Attempt any sub-questions from a, b, in MS-Excel (Truc/False) @)
   • (a) A workbook can contain maximum three worksheets
   • (b) A function can have another function as its argument
   • (c) Once subtotal is added to the list, it cannot be removed. B Attempt any fwo sub-questions from MySQL (Multiple Choice) 2
   • (d) To cancel the transaction and not save it we use
   • (1), COMMIT
   • (3) ROLLBACK
   • (4) RETURN To indicate that there should be 7 integers and 3 decimal positions
   • (2) DECIMAL(10,3) To select a database INCOME the statement
   • (2) OPEN INCOME
   • (3) USE INCOME
   • (4) CHOOSE INCOME C Attempt any six sub-questions from g, h, i, j, k, 1, m, n, in Data Communication, Networking and Internet (True/False)
   • (g) Fiber optic cables use light to transmit data
   • (h) In LAN network computers must be located in one room
   • (i) that acts as a server and a client is peer
   • (j) Failure of a node, brings down the entire network in a star topology
   • (k) The lowest layer in OSI model is the physical layer
   • (m) Blogs are used to block sites address contains a set of 4 numbers separated by dots Yahoo.com is a search engine Attempt any five and (Multiple Communication, js a component of Data Communication. —
   • (3) Protocol All of these A network where individual computers or nodes share the processing and
   • (q) storage of data with the server
   • (1) ‘Peer to Peer Network :
   • (4) None of these
   • (r) In topology all the nodes are connected with a single cable,
   • (1) Bus
   • (3) Star
   • (4) None of these The medium of transmission can be
   • (2) Twisted pair cable and Co-axial cable
   • (3) Optic fibre
   • (t) protocol to fetch e-mail from a remote mail-box into your Each web page has a unique address called
   • (2) Protocol
   • (4) None of these
   • (w) Text that links with the other text is called
   • (1) Hyper Text
   • (2) Ring Text
   • (3) Loop Text
   • (4)' Text 2.A Attempt any one sub-question from a, b (Data Communication, Networking
   • (a) Explain Domain Name System and IP address. 8
   • (b) Explain the different types of networks B Attempt any one sub-question from c,d (Data Communication, Networking and
   • (c) What are the various types of internet connections? x 7
   • (d) Explain Hacking and types of hackers. | 3.A Attempt any one sub-question from a,b in MySQL 7
   • (a) Write MySQL statement to create a table BILL having the following (PRNAME, character with variable width 15 columns), Quantity( QTY, integer, positive) and Amount( AMT, 6 integers decimals, should 8
   • (b) Write MySQL to create a table called ADMISSION having the following columns Roll Number (RNO, integer, should be increased by | automatically), Student name ( NAME, character with variable width 25 columns), Gender( GENDER, Boolean), Date of birth( DOB, Date) and Fees paid( FEES, 5 integers and 2 decimals, should not 8 Attempt any one sub-question from c,d in MySQL 8
   • (c) Explain the functions in MySQL. 7
   • (1) ROUND(Q)
   • (4) UPPER()
   • (6) MID() ving the following There exists a table called COLLEGE CLASS: character), Division (DIV, character) and Roll Number (ROLL, integer) as the first column of the table tures attended by 2 for all the students
   • (ii) Increase the number iC
   • (ii) Delete all the the table
   • (iv) Display the the table
   • (v) Delete the column OLLEGE
   • (vi) Rename the table as NC ]
   • (vii). Delete the table NCOLLEGE
2. Q4 Attempt any one sub-question from 4, b 1D
   • (a) There exists a CUSTOM character) Balance due(BALA, date of transaction(DT, date) the customer and
   • (ii) the customer number, maximum balance due and number of balances due grouped by number
   • (iii) Display all the rows where the balance due is less than average
   • (iv) Display all the rows where the name ends with 'A’
   • (v) Display the customer number, balance due and date of transaction for date of transaction before July 25, 2013. (
   • (b) There exists a table LIBRARY having the columns Book Number (BKNO, integer), Name of the book (BKNAME, character), Type of book (TYFE, of copies(NOC, integer), value of the book (VALU, numeric) and Date of Publication (DP, date). Write MySQL queries for the following 8
   • (i) Display all the rows from this table where the value of the book is below the average book value
   • (ii) Display the columns Book number, Name of the book and Date of Publication from this table where the value of the book is equal to the highest book value
   • (iii) . Display Type of book and average value of the books from this as per type
   • (iv) Display the Book Number, Value of the book and ‘scrap value’ which is 5% of the value of the book from this table
   • (v) all the rows where the value of the book is above 1000 Attempt any one sub-question from c, d in MySQL
   • (c) There exists a table DEPT containing columns Employee number (ENO, There exists another table COMPANY containing the columns Employee number (ENO, integer), Gender (GEN, character) and date of joining (DOJ, Write MySQL statements to 7
   • (i) Display Employee Number, Employee Name and Date of Joining from these tables for employees whose salary is above
   • (ii) Display Employee number, Employee name, Gender and date of joining from these tables for employees whose date of joining is after June 15, 2013 Display all the rows from the table DEPT whose salary is below
   • (iv) Display the salary from the table DEPT where the salary is either 30,000 or 40,000
   • (d) There exists a table SALARY containing the columns Employee number Write MySQL queries for the following :— 7
   • (i) Display employee number, employee name arid the taxable
   • (ii) Display employee name, Income tax and 5% of the Income tax as ‘Surcharge’ for all the employees
   • (iii) Display all the rows where the taxable income is above 5,00,000
   • (iv) Display employee number, employee name and income tax in in the descending order of income tax
   • (v) Display the employee number, employee name and taxable income of the employees whose name is
   • (vi) Display all the rows from this table where the employee name
   • (vii) Display all the rows from this table where the income tax is from 4, d in a worksheet >A The data has been entere Based on these values, write steps to 1) Arrange the data in the order of Name and further in the ascending order of Department. 2) the data in the alphabetic order of Department and further in the din order of salary the following spreadsheet write the steps to obtain the Subtotals the fees class wise B Attempt any one sub-question from c, d in MS-EXCEL
   • (c) Answer the following using MS-EXCEL For the above spreadsheet write the steps to obtain the Total marks in 6 subjec! column.H and the Average marks, as the Average of the best five subjects f sh student in column I ) Explain the following built-in functions in MS-EXCEL
   • (6) MOD()

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