TYBCOM Sem 5 Computer Question Paper 2022 (November) with Solution | Mumbai University

TYBCOM Sem 5 Computer Question Paper 2022 (November)

Q.1 A) Attempt any Two sub questions from a),b) & c) MS-Excel (True or False) (2 marks)

1. If a cell display MN it means ‘that it contains invalid data – False
2. The default cell reference is an absolutes cell reference – False
3. Every formula must begins with $ sign – False

Q.1 B) Attempt any Two sub questions from d), e) and f) in SQL (Multiple Choice) (2 marks)

d)To make changes in the structure of the existing table we use ______.

1) Alter
2) Update
3) Set
4) Create

e) To save the transaction we use ________.

1) Commit
2) Rollback
3) Select
4) Cancel

f) A data base contains one or more ________.

1) Rows 
2) Tables
3) Columns
4) Databases

Q.1 C) Attempt any Six sub questions from g),h),i),j),k),l),m),n), and o) in Data Communication ,Networking and Internet (True or false) (6 marks)

g) HTTP is a protocol on the internet – True

h) A bus topology uses a single cable – True

i) A fiber optic cable carries data using Electric current – False

j) MAN is spread over many countries – False

k) Google. com is a search engine – True

l) Failure of a node bring down the entire network in a star topology – True

m) A blog is a digital diary – True

n) A cyber crime means cheating through computer or Internet – True

o) An email address can contains 7 layers – False

Q.1 D) Attempt any Five sub questions- from p),q),r),s),t),l),u),v), and w) in Data Communication ,Networking and Internet (Multiple Choice) (5 Marks)

p) Each web page has a unique address called a _________.

a) Bridges 
b) URL 
c) Email
d) None of these

q) _________ is used to create Web pages.

a) HTTP
b) HTML
c) SMTP 
d) FTP

r) A hyperlink can appear as _______.

a) Only Text 
b) Only Images 
c) Code
d) Both text and Images

s) The fastest transmission media is ________

a) Twisted pair
b) Fiber Optics 
c) Co-axial
d) Wireless

t) The exchange of information between-computers is governed by a set of rules called ________

a) Media
b) Protocol
c) Channel 
d) Sender

u) A  ___________ joins^–multiple computers together to form a single network

a) Bridge 
b) Switch
c) Hub 
d) Router

v) In __________ topology all nodes are connected directly to the central system

a) Bug
b) Ring
c) Star
d) Mesh

w) A place on the web page that signals a connection to another webpage is called _______

a) Protocol 
b) Blog
c) Link
d) Google

Q.2 A) Attempt anyone sub questions from a) & b) in Data communication ,Networking and Internet (8 marks)

1. Explain briefly the topologies Star and Ring used in networking.
2. Write short notes on
   • LAN
   • WAN

Q.2 B) Attempt anyone sub questions from c) & d) in Data-Communication ,Networking and Internet (7 marks)

c) What is OSI model? Explain the three layer of OSI model.
d) What is hacking and explain any three types of hackers

Q.3 A) Answer anyone sub question from a) and b) in My SQL. (8 marks)

a) 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 columns),
order no (OrderNo Integer),
Item name(Item_name character 20),
quantity ordered(Qty_order Integer),
unit price(Unit_price Integer),
date of order(DOA date).

b) Write MySQL statement to create a table called STUDENTS Columns in the table:
Admission number (Adrn_no Integer Primary key),
first name b(Fname Character(15),
Last name (Lname character(‘ 5));
Date of birtb(Dob date),
marks in HSC(Hsc_Marks_integer),
gender (Gender Enum),
Admission no. should be automatically generated every time you enter a record

Q.3 B) Answer anyone sub question from c) and d) in My SQL. (7 marks)

c) There exists a table called Student containing the columns :
Roll Number (RHO, integer, Primary Key),
Name (NAME, character variable width 20),
Date of birth (DOB, Date),
Gender (GENDER, character width:1) and
Division (DIVISION, character variable width 4)

Write MySQL statements for the following.

1. Display the structure of the table student.
2. Display all the information from the table student.
3. Add a new column Mobile Number (MOB, integer) at the end of the table Student
4. Delete the row where roll number of the student is 96.
5. Change the Division of students with roll number 95 to Div B.
6. Update Mobile number 8652007978 of student whose rollrio is 10.
7. Rename the table Student as Student .Info.

d) Explain the following built in function in My SQL:

1)LEFT ()
2) RIGHT()
3) MID ()
4) NOW ()
5) POW ()
6)LENGTH ()
7) CONCAT ()

Q.4 A) Answer anyone sub question from a) and b) in My SQL (8 marks)

a) 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 (DOT, date)

Write MySQL queries for the following:

i) Display the book name,, author name, student number and date of issue for LIBRARY haying more than 150 pages using both the tables

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 . (CNO, integer), customer name (Q.1.1-11viE, character), balance due (BD, numeric) and date of transaction (DT, date)

Write MySQL statements to

1. Display the customer number, Maximum balance due and total of balances due grouped by customer number ‘
2. Display the customer number,: minimum balance due od number of balances due grouped by customer number
3. Display all the rows where the balance due is more than average baiaii due,
4. Display all the rows where the name starts with ‘R.’
5. Display the customer number, balance due and date of transaction for date of transaction before 20 July 2022

Q.4 B) Answer anyone sub question from c) and d) in My. SQL (7 marks)

c) There exists a table called BANK containing columns bank account number (BAN, integer) , name of the depositor (DNAME), Amount deposited (ADEP) and date of deposit (DOD)

Write My SQL statements for the following:

1. Display the bank account number, name of the depositor, number of amount deposited and minimum amount deposited group account number wise
2. Display the bank account number, name of the depositor’ maximum amount deposited and total of amount deposited grouped account number wise for bank account no.123
3. Display the bank account number, name of the depositor, and date of deposit “in descending order of date of deposit
4. Display all information of bank account numbers 3 to 7

d) 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:

1. Display employee number, employer name and salary
2. Display employee name, income tax and 2% of the Income-Tax as ‘Exemption’ for all the employees d
3. Display all the rows where the salary is above 2 lacs
4. Display employee number employer name and income tax in descending order of employee number
5. Display employee number, employer name and salary of the employees whose name is Shyam
6. Display all the rows where the employee name contains ‘a’
7. Display all the rows from this table where the income tax is between 20000 and 50000

Q.5 A) Answer anyone sub question from a) and b) in MS – EXCEL (8 marks)

a) The following data has been entered in a worksheet.

	A	B	C	D	E	F
1	Product	Unit Price	QTY Sold	Total Amount	Discount	Net Amount
2	A	6000	102
3	B	8500	2
4	C	400	15
5	D	8050	14
6
7
8	Rate of Discount	5%

Write the steps to obtain:

The Total Amount Discount Amount and Net Amount in columns D,E and F respectively.

	A	B	C	D
	Emp No	Emp Name	Department	Salary
1	555	Virat	HR	24000
2	665	Sachin	ADMIN	15600
3	450	Sahil.	HR	34500
4	255	Rahul	SALES	23500
5	125	Anish	HR	35900
6	488	Rupali	ADMIN	60000

Write the steps to do the^–following:-

1) Arrange the data in alphabetical order of employee name.
2) Obtain the department wise subtotal of Salary.

Q.5 B) Answer anyone sub question from c) and d) in EXCEL (7 marks)

c) Consider the following worksheet showing the cost of machinery find the depreciation using WDV (Written Down Value) Method.

	A	B	C	D	E	F
1	Cost	50000		Years	Depreciation	WDV
2	Dep. Rate (%)	10		1
3	No. of Years	5		2
4				3
5				4
6				5

d) Explain the following built in functions in MS – Excel

1. PMT ()
2. RATE ()
3. MOD ()
4. ROUND ()
5. COUNT ()
6. SUM ()
7. SQRT ()

TYBCOM Sem 5 All Question Paper November 2022

• TYBCOM Sem 5 Direct Tax Question Paper November 2022
• TYBCOM Sem 5 Economics Question Paper November 2022
• TYBCOM Sem 5 Commerce Question Paper November 2022
• TYBCOM Sem 5 Financial Accounting Question Paper November 2022
• TYBCOM Sem 5 Cost Accounting Question Paper November 2022
• TYBCOM Sem 5 Export Marketing Question Paper November 2022
• TYBCOM Sem 5 Computer Question Paper November 2022

Related Posts :
FYBCOM Subjects
SYBCOM Subjects
TYBCOM Subjects
FYBCOM Syllabus
SYBCOM Syllabus
TYBCOM Syllabus

Tips to score good marks in TYBCOM Exam

1. Don’t wait until the last minute to start studying: begin early. You’ll have more time to learn the topic and solve questions, the earlier you start.
2. Remain arranged: Plan a study schedule and stick to it. Take time to rest and refresh during breaks.
3. Regularly review your notes: Regularly reviewing back your notes will help you keep the content in your memory.
4. Practice, practice, practice: By working through sample problems and completing sample tests, you can identify your areas of weakness and become familiar with the exam’s format.
5. Ask for assistance if you need it: If you’re having trouble with the subject, don’t be shy to ask for assistance. You can seek advice from your teacher, a classmate, or a tutor.
6. Get a good night’s sleep: The night before the exam, be sure to get lots of rest. A mind that has got enough sleep is better prepared to memorize and recall information.
7. Arrive early on exam day: Arrive early on the day of the exam to give yourself time to settle your worries and mentally prepare.
8. Stay focused during the exam: Avoid being distracted during the exam by remaining focused. Take a deep breath and return your attention to the activity at hand if you realize that your mind is roaming.
9. Don’t waste too much time on any one question: keep an eye on the time. If you start to struggle, leave it and return to it later.
10. Review your exam after you’re done: After you’re finished, review your paper for a while. By doing this, you’ll be able to correct any mistakes you may have made and provide any answers you’re not sure about.