CFA Past Papers

What is a database? Give any two examples of database management software.

What is DOS? Name the two types of DOS commands.

What is a spreadsheet? Give one example.

What is a protocol? Name any two Internet protocols.

Define Open Source Software. Give two examples.

Explain the fundamental components of a computer system and their functions. [5]

Define computer memory. Explain memory hierarchy. [1+4]

What is computer software? Differentiate between a program and software. [1+4]

What is an Operating System (OS)? Explain different types of OS and give examples of Open-Source OS. [1+3+1]

What is a Database? Explain its main functions and types with examples. [1+3+1]

What is browsing? What is meant by home page of a website? Explain any three Internet protocols. [1+1+3]

Write short notes on any TWO: a) Multimedia Vs Hypermedia b) GUI Vs CUI c) Text Formatting Vs Paragraph Formatting [2.5+2.5]

Why do computer networks play a vital role in the 21st century? Explain the role of different transmission media in network design. Describe the functionalities of various network devices. [2+2+6]

a) Write functions and perform the following calculations in MS-Excel for the given data table (Dolakha: Target=4800, Production=6000; Lalitpur: Target=5000, Production=4500; Mustang: Target=5000, Production=5000): i) Calculate Achievement in percentage ii) Calculate average achievement iii) Assign grade: A+ for >100%, A for =100%, B for <100%. b) Explain the following DOS commands with syntax: i) How to protect files ii) RD vs DEL commands iii) Copying files between directories iv) TREE and LABEL commands v) Display file contents without opening [5+5]

a) What is the difference between Adobe ImageReady and Photoshop? What are the different selection tools available in Photoshop? [2+3] b) What is PowerPoint? What is its purpose? Differentiate between Slide Sorter view and Slide Show view of PowerPoint. [1+1+3]