AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Informa on Technology Tools and Network Basics
Assignment- DCA/ PGDCA
Note: A empt All ques ons.
Q.1 explain what is computer and its feature?
Q.2 what is memory unit and define how many types of memory used in
computer?
Q.3 explain any five input device and output device?
Q.4 write how many types of computers.
Q.5 Write the difference between RAM and ROM, LCD and LED?
Q.6 What is a computer virus and type of virus with Example?
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Windows and MS Office
Assignment- DCA/ PGDCA
Note: A empt any Ten ques ons.
Que.1 Write some main feature of ms-word. Ms-word
Que.2 What is the feature of word processor?
Que.3 Write difference between print and print preview.
Que.4 What do you mean by text forma ng?
Que.5 Write the shortcuts for the following:-
[Link]
2. Italic
3. Underline
4. All le er in uppercase
Que.6 Write the step to delete header and footer in the document.
Que.7 What is the mail merge and how to create it?
Que.8 What is the ms- excel func on? Explain any 10 func ons.
Que.9 What is mul tasking?
Q.10: What is opera ng system? Explain with its func ons.
Q.11: Write difference between GUI and CUI.
Q.12: Write any 5 internal DOS command and 5 external DOS command.
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Objects Oriented Programming With C++
Assignment- DCA/ PGDCA
Note: A empt All ques ons.
Q1) What do you understand by Object Oriented Programming (OOP)?
Write down its features.
Q2) What is the difference between C++ and C?
Q3) What is Inheritance and how many types are there?
Q4) Write a program to add two numbers by crea ng a func on.
Q5) Write short notes on the following:
(a) iostream.h
(b) Keywords
(c) getch() func on
(d) clrscr() func on
(e) conio.h
Q6) Explain the operators used in C++.
Q7) Write a program to print the table of a given number.
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Database Concepts and Introduc on to SQL
Assignment- DCA/ PGDCA
Note: A empt All ques ons.
Q1) Explain the following data models with their advantages and
disadvantages:
1. Rela onal Data Model
2. Network Data Model
Q2) What is an ER diagram? Explain its role in RDBMS.
Q3) How many types of rela onships are present in RDBMS? Explain.
Q4) Write the difference between DBMS and RDBMS.
Q5) What is Normaliza on? How many types of Normal Forms are there in
RDBMS?
Q6) Explain (Any two):
1. SQL
2. Primary Key
3. BCNF
Q7) Explain the following commands:
1. Create Command
2. Drop Command
3. Rollback Command
4. Desc Command
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Introduc on to Internet and Web Technology (HTML)
Assignment- DCA/ PGDCA
Note: A empt All ques ons.
Q1) Explain the term Internet and Intranet.
Q2) What is DNS?
Q3) Explain all types of Computer Networks (LAN, MAN, and WAN).
Q4) Explain all types of list.
Q5) Write the facili es of Internet.
Q6) How many types of HTML tags are used in HTML? Explain them.
Q7) What is a Web Browser? Write the names of any three web browsers.
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Programming and Problem Solving through Python
Assignment- DCA/ PGDCA
Note: A empt any Seven ques ons.
Q1) What is Python? Write its features and advantages.
Q2) Explain the different data types in Python with examples.
Q3) What are operators in Python? Explain different types of operators.
Q4) Explain condi onal statements in Python (if, if-else, if-elif-else).
Q5) What are loops in Python? Explain for loop and while loop with
examples.
Q6) What is a func on in Python? Explain user-defined func ons with
syntax and example.
Q7) Explain the difference between list, tuple, and dic onary in Python.
Q8) What is a string in Python? Explain string opera ons.
Q9) What is file handling in Python? Explain different file modes.
Q10) What is Excep on Handling in Python? Explain try, except, finally with
example.
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Introduc on to Financial Accoun ng with Tally
Assignment- DCA (Only Student)
Note: A empt All Seven ques ons.
Q1) Explain the objec ves of accoun ng.
Q2) Write the advantages of accoun ng.
Q3) How many books are maintained in a Manual Accoun ng System?
Explain them.
Q4) How many types of Accounts are there? Explain all types.
Q5) Explain terms proprietor liability voucher stock goods.
Q6) What is Tally? Write its features and advantages?
Q7) What is a Voucher in Tally? Explain different types of vouchers.
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Introduc on to Cyber Security
Assignment- DCA (Only Student)
Note: A empt All Seven ques ons.
Q1) What is Cyber Security? Explain its importance.
Q2) What are the main objec ves of Cyber Security?
Q3) Explain the different types of cyber threats.
Q4) What is a Hacker? Explain the types of hackers.
Q5) What is Malware? Explain its types (Virus, Worm, Trojan, Spyware,
Ransomware).
Q6) What is Phishing? How can it be prevented?
Q7) What are Firewalls and their types?
Q8) Explain the role of An virus so ware in Cyber Security.
Q9) What is Social Engineering? Give examples.
Q10) What are best prac ces to stay safe online?
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Introduc on to Financial Accoun ng with Tally
Assignment- PGDCA ( Only Student)
Note: A empt any Seven ques ons.
Q1) What is Data Structure? Explain its types with examples.
Q2) What is the difference between Linear and Non-Linear Data
Structures?
Q3) Explain Array in C++ with its advantages and disadvantages.
Q4) What is a Linked List? Explain its types.
Q5) What is Stack? Explain its opera ons with example.
Q6) What is Queue? Explain its types and opera ons.
Q7) What is Recursion? Write a C++ program to calculate factorial using
recursion.
Q8) Explain Tree data structure and its types.
Q9) What is Searching? Explain Linear Search and Binary Search.
Q10) What is Sor ng? Explain Bubble Sort and Selec on Sort.
AISECT SKILLS KNOWLEDGE PROVIDER
CENTRE SINGRAULI
SUB: Informa on Security Management
Assignment- PGDCA (Only Student)
Note: A empt any Seven ques ons.
Q1) What is Informa on Security? Explain its objec ves.
Q2) What are the key principles of Informa on Security (CIA –
Confiden ality, Integrity, Availability)?
Q3) Explain different types of threats to informa on security.
Q4) What is Risk Management in Informa on Security? Explain its steps.
Q5) What are the types of a acks in Informa on Security? Explain with
examples.
Q6) What is Authen ca on and Authoriza on? How are they different?
Q7) Explain different types of security controls (Preven ve, Detec ve,
Correc ve).
Q8) What is Cryptography? Explain its types (Symmetric and Asymmetric).
Q9) What is Firewall? Explain its types and func ons.
Q10) What is the role of Informa on Security Policy in an organiza on?