BCom TY BCom Sem 5 2023 2024 Nov 2024 COMPUTER SYSTEMS AND APPLICATIONS PAPER I Question Paper - Mumbai University | munotes

Loading PDF...

Older exam Nov 2024 - DIRECTB AND INDIRECT TAXES PAPER I Semester-end · 2023 2024 →

Newer exam None yet: this is the latest New papers land after each exam season.

Questions asked in this paper

Q1 Attempt any Two sub questions from a),b) & c) in MS-Excel (True or False ) group of cell is called a domain function must have at least one argument B Attempt any Two sub questions from d),e) and f) in My SQL 2 d_ The statement used to perform queries on tables begin e The function used to join the word is 2 marks
Q1 2) 3) 4) Move() f To indicate that there should be 6 integers and 2 decimal position we use Attempt any Six sub questions from and 0) in Data Communication ,Networking and Internet ( True or False ) g Dial up connection requires a modem and a phone call h More than one file can be attached with an email i Protocol is not necessary for data communication k Meta search engine creates its database of information 1 One cable is used in Bus topology Wireless connection use Radio and infrared signals n A metropolitan area network can connect several LANs o Internet explorer is a web browser Attempt any Five sub questions from and w) in Data Communication ,Networking and Internet p Of the following is not a protocol
- a) Some mail b) Single Mail c) Simple Mail Transfer d) None of transport point transfer protocol Protocol these r of the following data is transmitted using lively beam of light s The way in which computer are arranged physically is called t is the central device used star topology u In maximum number of cables used The large collection of websites available on the internet is Allow user to search simultaneously on several search engine
Q2 A Attempt any one sub questions from a) & b) in Data Communication ,Networking and g a Explain the different uses of Internet Topology. Explain Bus topology B Attempt any one sub questions from c) & d) in Data Communication ,Networking and 4 c Explain Blog and Search Engine d What is hacking and explain any three types of hackers
Q3 A Answer any one sub question from a) and b) in My SQL a Write MySQL statement to create a Table name: UNIT_SALES Salesman Id(SID, Integer Primary Key , Not Null ), Product name(PName Variable length of character 30), no. of units to be supplied(Qty_units Integer),date of supply (DOS, Date), store no (S_No integer) b Write MySQL statement to create a table called CLASS contains Columns in the table: Admission number (ADM_NO , Integer, Primary name (FNAME, character(15), Last name (LNAME, character(15)),Date of birth(DOB,date), marks in HSC(HSC_MARK gender (GEN ,Boolean), B Answer any one sub question from c) and d) in My SQL 7 c There exists a table called Emp containing the columns EMP Number ENO, integer, Primary Key), Name (NAME, character variable width 20), Date of birth (DOB, Date), Gender (GENDER, character width 1) and Department (Dept, character variable width Write MySQL statements for the following 8 marks
- i) Display the structure of the table Display all the information from the table
- ii) Add a new column Salary( Sal , decimal(7,2) at the end of the table
- iv) Delete the row where Emp number of the emp is 1001
- v) Change the Department of emp with Empno 1004 to Admin
- vi) Rename the table Emp to Empoyee Explain the following inbuilt function in My SQL
Q1 NOWQ 2 TIME() 3) 4)
Q4 Answer any one sub question from a) and b) in My SQL There exist a table TAX containing columns Pan Number (PAN, Integer), name and Income Integer) Write MySQL queries for the following 8 marks
Q1 Display Pan Number , Name and Income Tax iit) Display Pan Number , Name and Income Tax where taxable Income is more than the Average Taxable
- ii) Display City, maximum and minimum Taxable income group by city
- iv) Display Pan Number , Name and taxable Income where income tax is equal to the
- v) Display all the rows where name contains ‘B’ There exist a table FLIGHT having columns flight number (FNO, integer), destination name (DEST, character), Stopover name (STOP, character), and amount of the ticket(AMT, integer) Write MySQL queries for the following
Q1 Display flight number, destination name and amount collected for the stopover
- ii) Display flight number, destination name and stop over name where amount collected is above average amount collected Display all the rows from the table in ascending order of stop over and descending order of amount collected
- iv) Display flight number and destination name group according to stop over names B Answer any one sub question from c) and d) in My SQL 7 c There exist a table STAFF with columns Employee ID (E_ID, integer), employer name (ENAME, character), department ID (DID, integer) manager id (MGID, integer), salary (SAL, numeric) and hiring date (HDATE, date) Write MySQL queries for the following:
Q1 Display all the rows from this table
- ii) Display the name and hiring date of all the employees who do not have manager Display employer name as employee name (EMPNAME) from the table
- iv) Display employee ID, department ID and salary of the employees whose manager ID is 102 or 105
- v) Display the employee ID employee name and salary of the employees whose salary is greater than 15000 d_ There exist a table examination containing columns exam seat number (ESNO, integer), name of the student(SNAME, variable character), gender (GEN, character), marks (MKS, numeric) and grade (GRADE, character) Write MySQL queries for the following
Q1 Display all the rows where the grade is B Display seat number, name and marks of students whose marks are equal to to
- iii) Display seat number, marks and grade of students whose marks are above average
- iv) Display gender, minimum marks and maximum marks of students grouped by
Q5 A Answer any one sub question from a) and b) in MS- EXCEL a The following data has been entered in a worksheet Write the steps to 8 marks
Q1 Sort the data in the ascending order of Name
Q2 Calculate subtotal of sales for each city following spread sheet contains the amounts invested, the rate of interest and the period of investment in years. Write the steps to obtain the simple and compound interest in columns C and D Given that, Simple Interest =(p*n*r)/100 B Answer any one sub question from c) and d) in MS- EXCEL 7 c Answer the following using spreadsheet giving the runs scored by batsman in 5 Write the steps to
Q1 Total and Average score in column G and H
Q2 Match-wise calculate the Highest and the lowest score in row 8 and Explain the following built in functions in MS-EXCEL 9 marks

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

Report or request

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Related Resources

BCom Notes BCom Syllabus

Something wrong with this paper? Report it.

Connected Papers

BCom / Ty Bcom · 237 papers

Browse all →

Questions? Email contact@munotes.in

Done!