BCom TY BCom Sem 5 BCom Sem 5 (2016 2017) May 2017 ATKT COMPUTER 2nd 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 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 constant interest rate
   • (B) Attempt sub-questions from (d), (e),(f) in MySQL 2
   • (d) To opena database CLASS the statement is
   • (e) SELECT * FROM salary LIMIT 4,2; displays
   • 1) allrows — 4) 4th and 5th rows
   • (f) To indicate that there should be 6 integers and 2 decimal
   • 4) DECIMAL(2,8)
   • (C) Attempt any six. sub-questions from in Data Communications, Networking and Internet. (True/False) 6
   • (g) Message is not a component of data communication
   • (h) InLAN there may be more than one server
   • (i) It is easy to add/remove a node in star topology
   • (j) OSI is.a network protocol
   • (k) Each URL consists of three parts AND is a Boolean operator is Search Engine White hat are hackers who break computer security for non-harmful reasons like to test the security of the system
   • (D) Attempt any five sub-questions from in Data Communications, Networking and Internet. (Multiple Choice) is also called Data Transmission 5
   • 4) None of these
   • (q) The fastest transmission media is
   • (r) form of HTTP is is a device using which we can segment a large network
   • 1)Hub 3)switch
   • (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) username 3)subdomainname 4) None of these
   • (w) _ ----------- allows user to search simultaneously on several search engines
   • 1) Server 2) Boolean 3) Meta search engine 4) none of these
2. Q2 (A) Answer sub-question from (a), (b) in Data Communications, Networking and Internet 8 marks
   • (a) networking? Explain different types of Networks
   • (b) Write short notes on (i) Bridges (ii) routers
   • (B) Answer any one sub-question from (c), (d) in Data Communications, Networking and Internet 7
   • (d) hacking and types of hackers
3. Q3 (A) Answer anyone sub-question from (a) in MySQL 8 marks
   • (a). Write MySQL statement to create a table called ADMISSION having the columns Name of Student (SNAME, character with variable width 15 columns, should not be empty), Gender (MALE, Boolean), Date of Birth (DOB, date, should not be empty), Fees Paid (FEES, having 6 integers and 2 decimal places, positive)
   • (b) Write statement to create a table called ECHARGE containing information of customers using electricity provided by XYZ company having Name(CNAME, character with variable width 20, not empty), Customer Address(CADR, of fixed width 12, containing default entry
   • (B) Answer any sub-question from (c), (d) in MySQL 7
   • (c) Explain the following built-in functions in MySQL
   • 1)TRIM () ) 3) 4) DATE()
   • 5) 6) DAYNAME() 7) POW()
   • Q.P. Code : 09303
   • (d) There 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 roll number is 126 the name of the column RN to RNO
   • iv)Increase the marks obtained in SY by 5 for all the students
   • v) Change the subject offered by the roll number 120 to ‘COMPUTER’
   • vi) Add a new column division (DIVI character width 1) to this table after the
   • vii) Rename the table TYCLASS to TYBCOMCLASS
4. Q4 (A) Answer anyone sub-question from (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
   • ii) Display Station Number, Station Name whose Amount Collected is below the
   • iii) Display Station Name, maximum Amount and total Amount Collected from stations grouped by Station Names
   • iv) Display Station Number, Station Name whose Amount Collected is equal to the Highest Amount Collected
   • v) Display all the rows from this table in the ascending order of amount
   • (b) There exists a table TRAVEL containing columns Passenger Number (PNO, integer, primary key), Passenger Name (PNAME, char(20)) and Age of Passenger (AGE, integer). There exists another table JOURNEY containing (CITY, char(15)), Fare(FARE, decimal(6,2)) and Date of Travel (DTR, date) Write MySQL statements for the following
   • i) Display Passenger Number, Passenger’s Name and Fare for those having Destination City ‘PUNE’ using both the tables
   • ii) Display Passenger Number, Destination City and Date of Travel for those whose Date of Travel is after May 15, 2017 using both the tables
   • iii) Display Passenger Number, Fare from the table JOURNEY for those passengers whose Fare is equal to the highest Fare
   • iv) Display. Passenger Number, Fare and Date of Travel from the table JOURNEY for those who want to travel in the month of MAY
   • v) Display all the rows from the table TRAVEL where the passenger’s name
   • Q.P. Code : 09303
5. Q4 (B) Answer anyone sub-question 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, name of the employee and Salary where the Salary is above the average Salary
   • iv) Display all the rows from this table where the employee number is divisible
   • (d) There exists containing Number (ACNO, integer, primary key), Book Name (BNAME, character), Number of copies (NCOPY, integer), Value of the book ( Value, integer) and Date of Write MySQL queries for the following
   • i) Display all the rows from this table
   • ii) Display all the rows from this table in alphabetical order of book name
   • iii) Display the columns Account number, Book name and Date of Publication from this table
   • iv) Display the structure of the table BOOKS
   • v) Display the rows from this table where the date of Publication is after March
   • vi) Display all the rows from this table in the descending order of Value of the
   • vii) Display all the rows from this table where the first letter in the Book Name
   • (A) Answer any sub-question from (a), (b) in MS-EXCEL 8
   • (a) The following data has been entered in a worksheet Write steps to do the following:
   • i) Arrange data in the descending order of age and further in the ascending order of Salary
   • ii) Arrange the data in the alphabetic order of L Name and further in the descending order of F Name
   • (b) For the following spreadsheet obtain the Pivot table showing total Salary and average Salary Gender wise in column
6. Q5 (B) Answer sub-question from (c), (d) in MS-EXCEL 7 marks
   • (c) The following data has been entered ina worksheet Write the steps to obtain
   • i) TOTAL marks in column F
   • ii) AVERAGE marks as average of best three in column G
   • iii) HIGHEST marks subject wise in cells B7, C7, D7 and E7 respectively the following built in functions in MS-EXCEL
   • 1. FV() 3. ROUNDUP( ) 4

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