BCom TY BCom Sem 6 2022 2023 May 2023 COMPUTER SYSTEM APPPLICATIONS PAPER I Question Paper - Mumbai University | munotes

Loading PDF...

Older exam Apr 2023 - BUSINESS ECONOMICS VI Semester-end · 2022 2023 →

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 ) a which we enter the data is called an active cell formula can obtain references to other cell c formula are generally calculated from right to left B Attempt any Two sub questions from d),e) and f) in My SQL. (Multiple Choice ) 2 d To make changes in the data already entered in the table we used 2 marks
Q1 Alter Table and Set — 3). Select 4).Create e The clause is used to not save the transaction f To Open a database Class the statement C Attempt any Six sub questions from and in Data 6 Communication ,Networking and Internet ( True or False ) g One cable is used In BUS topology h_ Web pages are created using HTML j is a digital diary k In OSI model there are 7 layers 1 Protocol is not necessary for data communication m_ The opening page of a website is called its home page n Google is a Meta search engine o Hot spot are available on public spaces D Attempt any Five sub questions from and w) in Data 5 Communication ,Networking and Internet The part before the @ symbol in an Email address is
- a) Domainname b) User name c) The subdomain d) protocol q In topology all the nodes are connected with a single cable r The network spanning a single organization is s Which of the following is not a topology t Which of the following is not wire based media u is the central device used in star topology v TCP stands for Transmission Protocol The dial up account is the internet access account Attempt any one sub questions from a) & b) in Data Communication ,Networking and a Write short note on 1) Bus Topology 2) Star Topology various types of Computer Networks B Attempt any one sub questions from c) & d) in Data Communication ,Networking and 7 c Explain HUB and SWITCH used in networking d_ Explain the different use of internet
Q3 A Answer any one sub question from a) and b) in My SQL a Write statement in MySQL to create a table called DONATION containing columns integer with width 20),Amount(AMT Date(DT ,Date) which should not be empty b Write statement in MySQL to create a table called ACCOUNT containing columns with width 25),Gender (GEN,Boolean),types of account(TYPE, Character with width B Answer any one sub question from c) and d) in My SQL 7 c Explain the following in built function in My SQL d There exist called SALARY containing the column Employee integer, primary key), Name(ENAME, character) of birth(DOB ,date),Gender(GEN, character with width 1) and salary (SAL,5 integer and 2 Write MYSQI statement for the following 8 marks
- i) Display the structure of the table SALARY
- ii) Adda new column date of joining (DOJ,Date ) at the end of the table
- iii) Rename the column DOB to DBT
- iv) Change the size of the column SAL to 6 integer and 2 decimal
- v) Increase the salary of all employee by 1000
- vi) Delete the row where employee no is 48 vil) Rename the table SALARY as SAL
Q4 A Answer any one sub question from a) and b) in My SQL a There exist a table called RAIL containing the column Station name (SNO, integer), Station Name (SNAME, character), Amount collected (AMT, Numeric) Write MySQL statement for the following 8 marks
- i) Display station number, station name, and amount collected
- ii) Display station number, station name whose amount collected is below the average
- iii) Display station number, maximum and total amount collected from station grouped by station name
- iv) Display station number whose amount collected is equal to the highest amount
- v) Display all the rows from this table in the ascending order of amount collected There exist a table called BOOKS containing the column Accession number (ASNUM, Character) and number of pages (NUM, integer), There exist another table ISSUE containing the column student number (SNUM, integer), Accession number (ASNUM, integer, primary key) and date of issue (DOI, date) Write MySQL statement for the following
- i) Display book name, author name, and date of issue for books having more than 300 pages using both the tables
- ii) Display book name, student number, accession number and date of issue for books issued before September 1,2016. using both the tables
- iii) Display book name, author name and number of pages from the table BOOKS for those books where the number of pages is equal to the average number of pages
- iv) Display book name, student number, accession number in the alphabetical order of books name from the table BOOKS
- v) Display student Number, accession number and date of issue for all the rows from the table ISSUE where students number is between 21 and 30 B Answer any one sub question from c) and d) in My SQL 7 c There exist a table SPECIALIZATION with columns roll number (RNO, integer), name of the student (SNAME, Character), subject offered ( SUB, character) and marks obtained in TY BCom examination (MARKS, integer) write MySQL queries for the following:
Q1 Display all the rows in ascending order of roll numbers and descending order of it) Display all the rows from the table
- iii) Display all the rows where the subject offered is advertising
- iv) Display all the rows which contains ‘sa’ anywhere in the name of the student
- v) Display roll number and name of the student in alphabetical order of the names There exist a table EXAMINATION containing columns exam seat number (ESNO, integer), name of the student(SNAME, 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
- ii) Display seat number, name and marks of students whose marks are equal to to ili) 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 grade
Q5 A Answer any one sub question from a) and b) in MS- EXCEL following data has been entered in a worksheet Write step to 8 marks
Q1 Create a pivotal table showing the highest salary department wise in column E department wise in column H The 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 (S.D =(p*n*r)/100 Where P = Amount , R = rate of interest of years B Answer the following using spreadsheet 7 c Consider the following worksheet in MS- EXCEL Write step to find
Q1 HRA as 25% of basic or 10,000 whichever is less in column C
Q2 110% of basic rounded to the nearest integer in column D
Q3 Total as Basic + HRA +DA in column E
Q4 Tax as 33.33% of Total in column F d_ Explain the following function in MS- EXCEL

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!