TYBCOM Sem 5 Computer Question Paper November 2023 with Solution | Mumbai University

TYBCOM Sem 5 Computer Question Paper
November 2023

[Duration: 2 ½ Hours] [Max Marks: 75]

Note : All questions are compulsory

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

a) A group of cell is called a domain – False
b) Absolute cell referencing uses two $ signs – True
c) A function must have at least one argument – False

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

d) The statement used to perform queries on tables begin with ________
1) Select
2) Search

e) The function used to join the word is ________
1) Concat ()
2) Merge()
3) Join()
4) Move()

f) To indicate that there should be 6 integers and 2 decimal position we use ________
1) Decimal (6,2)
2) Decimal (8,2)
3) Decimal (2,6)
4) Decimal (2,8)

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

g) Dial up connection requires a modem and a phone call – True
h) More than one file can be attached with an email – True
i) Protocol is not necessary for data communication – False
j) OSI is a network Protocol – False
k) Meta search engine creates its database of information – False
l) One cable is used in Bus topology – True
m) Wireless connection use Radio and infrared signals – True
n) A metropolitan area network can connect several LANs – True
o) Internet explorer is a web browser – True

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

p) Of the following __________ is not a protocol
a) TCP
b) IP
c) FTP
d) OSI

q) SMTP means ________.
a) Some mail transport point
b) Single mail transfer protocol
c) Simple Mail Transfer Protocol
d) None of these

r) In which of the following data is transmitted using lively beam of light
a) Fiber Optic Cable
b) Coaxial Cable
c) Twisted pair cable
d) Satellite

s) The way in which computer are arranged physically is called
a) Network
b) Bridge
c) Router
d) Topology

t) __________ is the central device used star topology
a) Router
b) Bridge
c) Hub
d) Modem

u) In _________ maximum number of cables used
a) Bus
b) Star
c) Ring
d) Mesh

v) The large collection of websites available on the internet is _________
a) URL
b) WWW
c) Blog
d) Email

w) _________ Allow user to search simultaneously on several search engine
a) Server
b) Browser
c) Meta Search engine
d) Google

Q.2 A) Attempt any one sub questions from a) & b) in Data Communication ,Networking and Internet (8 Marks)

a) Explain the different uses of Internet.
b) Define Topology. Explain Bus topology.

Q.2 B) Attempt any one sub questions from c) & d) in Data Communication Networking and
Internet (7 Marks)

c) Explain Blog and Search Engine.
d) What is hacking and explain any three types of hackers.

Q.3 A) Answer any one sub question from a) and b) in My SQL (8 Marks)

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 key),
first name (FNAME, character(15),
Last name (LNAME, character(15),
Date of birth(DOB,date),
marks in HSC(HSC MARK,Integer),
gender (GEN Boolean),

Q.3 B) Answer any one sub question from c) and d) in My SQL (7 Marks)

c) There exists a table called Emp containing the columns EMP Number ENO, integcr,
Primary Key), Name (NAME, character var: able width 20), Date of birth (DOB, Date),
Gender (GENDER, character width 1) and Department (Dept, character variable width 4).

Write MySQL statements for the following.

i) Display the structure of the table.
ii) 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 l001.
v) Change the Department of emp with Empno 1004 to Admin
vi) Rename the table Emp to Empoyee

d) Explain the following inbuilt function in My SQL

1) NOW ()
2 TIME ()
3) CURDATE ()
4) DAYNAME ()
5) ROUND ()
6) SQRT
7) ABS ()

Q.4 A) Answer any one sub question from a) and b) in My SQL (8 Marks)

a) There exist a table TAX containing columns Pan Number (PAN, Integer), name
(NAME, variable character), City (CITY character), Taxable Income(INC,Integer)
and Income Tax(ITAX,Integer)

Write MySQL queries for the following

i) Display Pan Number, Name and Income Tax
ii) Display Pan Number, Name and Income Tax where taxable Income is more than the Average Taxable
iii) 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
highest Income Tax
v) Display all the rows where name contains ‘B’

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

i) Display flight number, destination name and amount collected for the stop over Dubai.
ii) Display flight number, destination name and stop over name where amount collected is above average amount collected.
iii) 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

Q.4 B) Answer any one sub question from c) and d) in My SQL (7 Marks)

c) There exist a table STAFF with columns Employee ID (E_ D, integer), employer name (ENAME, character), department ID (DID, integer) manager id (MGID, integer), salary (SAL,nùmeric) and hiring date (HDATE, date)

Write MySQL queries for the following:

i) Display all the tows from this table
ii) Display the name and hiring date of all the. employees who do not have manager
iii) 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

i) Display all the rows where the grade is B
ii) Display seat number, name and marks of students whose marks are equal to to
lowest marks
iii) Display seat number, marks and grade of students whose marks are above average
marks
iv) Display gender, minimum marks and maximum marks of students grouped by
grades

Q.5 A) Answer any one 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
1	Name	Age	City	Sales
2	Anita	41	Mumbai	320000
3	Anish	24	Delhi	200000
4	Rita	35	Surat	205000
5	Rushabh	42	Chennai	302000
6	Alex	50	Mumbai	540000
7	Eliza	44	Pune	320000
8	Mahesh	27	Mumbai	501000
9	Neeta	32	Nashik	520000

Write the steps to

1) Sort the data in the ascending order of Name
2) Calculate subtotal of sales for each city.

b) 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.

	A	B	C	D
1	Name	Amount	S.I	C.I
2	Ravish	500000
3	Dev	250000
4	Aabha	190000
5	Annie	560000
6	Number of years (n)	10
7	Rate of Interest (r%)	8

Given that, Simple Interest (S.I) =(p*n*r)/ 100
Compound Interest (C.I) =p*(1+ r/100)ⁿ– p

Q.5 B) Answer any one sub question from c) and d) in MS- EXCEL (7 Marks)

c) Answer the following using spreadsheet giving the runs scored by batsman in 5 matches.

98	A	B	C	D	E	F	G	H
1	Name	Match1	Match2	Match3	Match4	Match5	TOTAL	AVG
2	Sachin	76	78	98	54	115
3	Ganguly	45	56	54	45	12
4	Kapil	36	85	56	89	65
5	Dravid	59	45	54	25	78
6	Kumble	45	25	12	14	58
7
8	Highest Score
9	Lowest Score

Write steps to Calculate

1) Total and Average score in column G and H.
2) Match-wise calculate the Highest and the lowest score in row 8 and 9.

d) Explain the following built in functions in MS-EXCEL

1) IPMT ()
2) ROUNDOWN ()
3) SORT ()
4) COUNT ()
5) FLOOR ()
6) PV ()
7) MOD ()

TYBCOM Sem 5 Computer Question Paper November 2023 – PDF

TYBCOM Sem 5 All Question Paper November 2023

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

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

Tips to score good marks in TYBCOM Exam

1. 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.
2. 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.
3. Remain arranged: Plan a study schedule and stick to it. Take time to rest and refresh during breaks.
4. Regularly review your notes: Regularly reviewing back your notes will help you keep the content in your memory.
5. 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.
6. 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.
7. 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.
8. Arrive early on exam day: Arrive early on the day of the exam to give yourself time to settle your worries and mentally prepare.
9. 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.
10. 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.