BCom TY BCom Sem 5 2022 2023 Nov 2023 B. COM COMPUTER SYSTEMS APPLICATIONS PAPERS I Question Paper - Mumbai University | munotes

Loading PDF...

Older exam Nov 2023 - BUSINESS ECONOMICS PAPER V Semester-end · 2022 2023 → Newer exam Nov 2023 - B. COM 75 25 FINANCIAL ACCOUNTING AUDITING PAPER VII MANAGEMENT ACCOUNTING Semester-end · 2022 2023 →

Questions asked in this paper

Q1 Attempt any Two sub questions from a),b) & c) in MS-Excel (True or False ) display #### it means that it contains invalid data default cell reference is an absolutes cell reference c Every formula must begins with $ sign B Attempt any Two sub questions from d),e) and f) in My SQL 2 d make changes in the structure of the existing table we e save the transaction we use f A data base contains one or more C Attempt any Six sub questions from and o) in Data 6 Communication ,Networking and Internet ( True or False ) k Google.com is a search engine 1 of a node bring down the entire network in a star topology m A blog is a digital diary n Acyber crime means cheating through computer or internet o address can contains 7 layers D Attempt any Five sub questions from and w) in Data 5 Communication ,Networking and Internet p Each web page has a unique address called 2 marks
- a) Bridges b) URL c) Email d) None of these q is used to create Web pages
- a) Only Text b) Only Images c) Code d) Both text and s The fastest transmission media is t The exchange of information between computers is governed by a set of rules called u A joins multiple computers together to form a single network vIn topology all nodes are connected directly to the central system w on the web page that signals a connection to another webpage is called
Q2 A Attempt any one sub questions from a) & b) in Data Communication ,Networking g a Explain briefly the topologies Star and Ring used in networking Write short notes oni) LAN ii) WAN B Attempt any one sub questions from c) & d) in Data Communication ,Networking 4 c What is OSI model? Explain the three layer of OSI model 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 Write MySQL statement to create a table called sales_details having the columns Customer id(Cid, integer, Primary key, Not Null ), Name (CName character with variable width 30 no (OrderNo name(Item_name of order(DOA date) Write MySQL statement to create a table called STUDENTS Columns in the table: Admission number (Adm_no Integer Primary key),first name character(15), Last name (Lname character(15)),Date of birth(Dob date), marks in HSC(Hsc_Marks Integer), gender (Gender Enum),Admission no. should be B Answer any one sub question from c) and d) in My SQL 7 There exists a table called Student containing the columns Roll Number (RNO, integer, Primary Key), Name (NAME, character variable width 20), Date of birth (DOB, Date), Gender (GENDER, character width 1) and Division (DIVISION, Write MySQL statements for the following 8 marks
- i) Display the structure of the table student
- ii) Display all the information from the table student Add a new column Mobile Number (MOB, integer) at the end of the table Student
- iv) Delete the row where roll number of the student is 96
- v) Change the Divison of students with roll number 95 to Div B
- vi) Update Mobile number 8652007978 of student whose rollno is 10
- vii) Rename the table Student as Student_Info Explain the following built in function in My SQL
Q4 A Answer any one sub question from a) and b) in My SQL There exists a table LIBRARY containing accession number (ASNO, integer), book name(BNAME, character), author's name (AUTHOR, character) and number of pages (NUM, Integer). There exists another table BOOKS containing columns student number (SNO, integer), accession number (ASNO, integer) and date of issue (DOI, Write MySQL queries for the following: 4 1) Display the book name, author name, student number and date of issue for LIBRARY having more than 150 pages using both the tables 8 marks
- ii) Display the book name, accession number and date of issue for all the books using both the tables
- iii) Display book name, author name and number of pages from the table LIBRARY for those books where the number of pages is above the average number of pages
- iv) Display student number, accession number and date of issue for student number 101 from the table BOOKS b There exists a table CUSTOMER containing the following columns: customer number and date of transaction (DT, date) Write MySQL statements to
Q1 Display the customer number, maximum balance due and total of balances due grouped by customer number
- ii) Display the customer number, minimum balance due and number of balances due grouped by customer number
- iii) Display all the rows where the balance due is more than average balance due
- iv) Display all the rows where the name starts with ‘R’
- v) Display the customer number, balance due and date of transaction for date of B Answer any one sub question from c) and d) in My SQL 7 There exists a table called BANK containing columns bank account number (BAN, integer) , name of the depositor (DNAME), Amount deposited (ADEP) and date of Write My SQL statements for the following:
Q1 Display the bank account number, name of the depositor, number of amount deposited and minimum amount deposited group account number wise c i) Display the bank account number, name of the depositor maximum amount deposited and total of amount deposited grouped account number wise for bank Display the bank account number, name of the depositor, and date of deposit in decending order of date of deposit
- iv) Display all information of bank account numbers 3 to 7 There exists a table COMPANY containing the columns employee number (ENO, integer) employee name (ENAME, character) salary (SAL, 5 integer and 2 decimal) and income tax (ITAX, numeric) Write MySQL queries for the following:
- i) Display employee number, employer name and salary
- ii) Display employee name, income tax and 2% of the Income-Tax as ‘Exemption’ for all the employees iti) Display all the rows where the salary is above 2 lacs
- iv) Display employee number employer name and income tax in descending order of
- v) Display employee number, employer name and salary of the employees whose name is Shyam v1) Display all the rows where the employee name contains ‘a’ vil) Display all the rows from this table where the income tax is between 20000 and
Q5 A Answer any one sub question from a) and b) in MS- EXCEL The following data has been entered in a worksheet Write the steps to obtain The Total Amount, Discount Amount and Net Amount in columns D, E and F The following data has been entered in a worksheet Write the steps to do the following: Arrange the data in alphabetical order of employee name 2 Obtain the department wise subtotal of Salary B Answer any one sub question from c) and d) in MS- EXCEL 7 Consider the following worksheet showing the cost of machinery find the depreciation using WDV (Written Down Value) Method Explain the following built-in functions in MS-EXCEL 8 marks
Q5 COUNT () () 7. SQRT()

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!