BCom TY BCom Sem 5 BCom Sem 5 (2015 2016) April 2016 ATKT COMPUTER Question Paper - Mumbai University | munotes

Questions asked in this paper

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

1. Q1 Attempt any two sub-questions from (e).( in MysQu which helps to uniquely identify each row of the tableis 2 marks
2. Q1 Primary 2) Foreign 3) Main 4) None of these indicate that the values in the column are
3. Q1 Not Nul! 2) Unsigned 3) No Signed 4) Not Signed
   • (C) _ Attempt any six sub-questions from (0) in Data Communications, Networking and Internet. (True/False) 6
   • (h) Atoken Passing system is not used in Ring Topology In LAN at least computer ‘has to be a file server that acts as server and peer There are seven layers in-OS! model
   • (m) Yahoo.com is a search engine
   • (n) The Boolean search can simultaneously search through many search
   • (0) Internet Explorer is a web browser,
   • (D) Attempt sub-questions from (w) in Data Communications, Networking and Internet. (Multiple Choice) 5
   • (p) nota component of data communication
   • (q) rules for exchanging data between the computers are called
4. Q1 Server 2) Protocol 3) Domains 4) None of these
   • (r) Terminators are usedin topology
5. Q1 Star 2) Ring 3) Bus 4) All of these
   • (s) The acronym UTP : @ The — layer of OSI model provides the services like FTP,
6. Q3 Both Text and Image 4) None-of these
   • (v) are examples of ?
   • (w) The protocol to fetch e-mail from a remote mail-box into your computer is
7. Q2 (A) Answer any one sub-question from (a) ,(b) in Data Communications,
   • (a) Explain Bus and Ring Topology
   • (B) Answer any one sub-question from (c) ,(d) in Data Communications, (
   • (c) Whatis Electronic mail? State the advantages and importance of Electronic
   • (d) Write anote on Twisted-Pair and Co-axial cable in data communication
   • (A) Answer any one sub-question from (a), (b) in MySQL
   • (a) Write MySQL statement to create a table called LIBRARY having the following columns Serial Number(SR_NO; integer, distinct, should increase by 1 automatically), Book Name( BNAME, character with variable width 25 columns), Author Name( AUTHOR, character with variable width 15 columns) and Book Price( PRICE, 5 integers and 2 decimals, positive)
   • (b) Write MySQL statement to create a table called CONSUMER having the columns Consumer distinct integer), Consumer Name(CNAME, character with variable width 15 columns, should not be empty), Type of Connection( TYPE, character with variable width 10 ‘ columns, with default entry ‘Industrial’) and Units Consumed( UNITS,
   • (B) Answer any one sub-question from (c), (d) in MySQL Explain the following built-in functions in MySQL 7
   • (d) There exists a table called ESAL having the following ‘ (ENAME, character variable width 25 columns), Date of Birth( DOB, date) and Salary( SAL, 5 integer and 2 decimals), Write MySQL statements for the following
   • i) Display the structure of the table ESAL
   • ii) Increase the salary of all employees by 2000,
   • iii) Change the size of the column SAL to 6 integers and 2 decimals
   • iv) Rename the column DOB to DBT
   • v) Change the name of the employee numbér 175 to ‘VIVEK JAIN’.
   • vi) Delete the row where employee
   • vii) Delete the table ESAL,
8. Q4 (A) Answer any one sub-questiow from (a), (b) in MySQL 8 marks
   • (a) There exists a table EMP centaining columns Employee number character) and Basic Salary (BSAL, Numeric). There exists another table ‘ Contribution Numeric) and Bonus (BONUS, numeric) Write MySQL for the following
   • i) Display the Employee number, Employee name, Contribution and Bonus for employees having Bonus more than 5000 using both the 4 il) Display tne Employee name, Department, and Contribution for all the Empioyees having Contribution below 500 using both the tables
   • iii) Display Employee name, Department and Basic Salary from the table EMP for those employees having Basic Salary below the average
   • iv) Display Employee number and Bonus in the ascending order of Employee number from the table INCENT,
   • v) Display Employee name, Department and Basic Salary for Employee whose name begins with ‘M’ from the table EMP,
   • (b) There exists a table TAX containing columns Permanent Account Number Write MySQL queries for the following
   • i) Display the city, maximum and minimum, Taxable income, grouped
   • ii) Display the city, total of the income tax and total number of income tax payers, grouped by city < iii) Display all the rows where the income tax is below the
   • iv) Display the Permanent Account Number, Income Tax and 10% of the income tax as ‘Surcharge’
   • v) Display the rows from this table where the name does not contain
   • (B) Answer anyone sub-question from (d) in MySQL. (7
   • (c) There table EXAM containing columns seat (SEAT_NO, character), Name (SNAME, character), Gender (GENDER, character) and marks (MARK, numeric). Write MySQL queries for the following Display the seat number, name and marks of students whose marks are equal to the highest marks
   • ii) Display the seat number, gender and marks of students whose marks are above the average marks
   • iii) Display the gender, minimum marks and maximum marks of the students grouped by gender
   • iv) Display all the rows where the gender
   • (d) Thereisa table DEPOSIT containing the columns account number and period of deposit (P_DEP, numeric) Write MySQL queries for the following: Display the account number and amount deposited iit) Display the total number of deposits and maximum amount
   • iii) Display name in capital letters, year of deposit and the
   • iv) Display all the rows in the ascending order of amount deposited ; v) Display all the rows where the customer name begins with ‘B’
   • vi) all the rows where the date of deposit is before March 15, vif) Display the customer name and amount deposited where the amount deposited is either 1,00,000 or 3,00,000 Qs. (A) Answer anyone sub-question from (a), (b) in MS-EXCEL (8)
   • (a) Consider the following worksheet showing the cost of machinery, rate of depreciation and its life in years. Using reducing balance method, explain the procedure to display Year Wise depreciation and till the life of
   • (b) Consider the following worksheet showing the Sales of 4 persons Write steps to find for all the salesmen : Ci) Tax as 12.36% of the Sales in
   • (ii) Discount as 6.5% of the Sales in D (iif). Net Amount as in column
   • (iv) Profit as 8.5% of the net amount in column F
   • (B) ‘Answer any one (c), (d) in MS-EXCEL 7
   • (c) For the following worksheet find the Days Present and the proportionate Salary in columns D and that there are 25 working days in the
   • (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.