Key topics for Intermediate second year vocational Computer Science include the following

Paper I Object Oriented Programming and Java

Important topics

Object oriented concepts class object inheritance polymorphism

Java basics data types operators

Control statements loops

Arrays strings exception handling

File handling java io

Applets and event handling

Important questions to practice

Write a class to swap two numbers using method overloading

Explain inheritance with example code

Create a java program to handle exceptions

Write program to count vowels in a string

Paper II Relational Database Management Systems

Important topics

Database concepts tables keys normalization

SQL queries select where group by having

Joins inner outer cross

Transactions and integrity constraints

Important questions to practice

Write SQL to create a table and insert records

Retrieve records with conditions using where clause

Explain normalization with example

Write queries using join to connect two tables

Paper III Data Communications and Computer Networks

Important topics

Network basics types of networks LAN MAN WAN

OSI and TCP IP model

Protocols HTTP FTP SMTP

Network devices router switch hub

Wireless network basics

Important questions to practice

Define network and explain types

Explain OSI model layers

Difference between TCP IP and OSI

Describe functions of router and switch

Tips for exam preparation

Theory

Make short notes on key points of each topic

Write definitions and diagrams for networking

Learn SQL queries by writing many examples

Practical

Practice java programs multiple times

Try SQL commands with sample database

Understand how network layers work with examples

Quick list of most important questions

Explain OOP principles with examples in Java

Write a Java program to demonstrate polymorphism

Create SQL queries to display records from a student table

Explain normalization and list its types

Define network and explain OSI model layers with functions

What is a join in SQL explain with example

Compare TCP IP model and OSI model

Describe types of networks with advantages and disadvantages