Computer Fundamentals and Applications TU Board 2020 question paper

Who is a database administrator? Explain the major roles and responsibilities of DBA.

Define operating system. Explain the open-source operating system.

What is an ergonomic keyboard? Explain the working mechanism of a keyboard.

Explain different types of computers on the basis of size and power.

What is DBMS? Explain the Relational database model with a suitable diagram.

Prepare a specification of a personal computer which you want to purchase.

Explain any five DOS commands with suitable examples..

Prepare the following spreadsheet:Student Marks RecordABCDEFGHIJHGHSNNameCFALogicMathSo TechEnglishTotalPerResultGradeRankRemarks1Ram4556544445??????2Sham5045534545??????3Hari4644454645?????? Conditions: a) Write an appropriate formula to find the total marks of each student. b) Write a formula to find out the percentage of each student. c) Result is "Passed" if the student scores at least 40% marks in each subject. d) Write a formula to calculate the grade of the student based on percentage:

• A for ≥90%
• B for ≥80%
• C for ≥70%
• D for ≥60%
• E for ≥40% e) Write a formula to find the rank of individual students who have passed. f) Write remarks based on the following conditions:
• "Excellent" for Grade A
• "Good" for Grade B
• "Fair" for Grade C
• "Moderate" for Grade D
• "Satisfactory" for Grade E

a) What is mail merge? Explain the major functions available in the Review tab of a Word document. b) What is Photoshop? Write the steps to create an MRP-sized photograph in JPEG format.

Define Computer Network. Explain the OSI model in detail.