TYBCOM SEM-6 : Computer Systems & Applications Paper-II (Chapter wise Most Imp Questions with Solutions)

TYBCOM SEM-6 : 

Computer Systems & Applications Paper-II 

(Chapter wise Most Imp Questions with Solutions)

Unit 1: Advanced Excel (Very Important – Practical + Theory)

Long Questions

1. Explain advanced Excel functions with suitable examples (IF, VLOOKUP, HLOOKUP, INDEX, MATCH).

2. Explain Pivot Table and its applications in business.

3. What is Macro? Explain steps to record and run a macro.

4. Explain Data Validation and Conditional Formatting with examples.

5. Explain financial functions in Excel (PMT, NPV, IRR).

Repeated Short Notes 

• Sorting and Filtering

• Charts and Graphs

• Logical Functions

• What-if Analysis

• Goal Seek

Unit 2: Database Management System (DBMS)

Long Questions

1. Define DBMS and explain its advantages and disadvantages.

2. Explain database models (Hierarchical, Network, Relational).

3. Explain normalization with 1NF, 2NF and 3NF.

4. Explain Primary Key, Foreign Key and Candidate Key.

5. Explain SQL commands with examples (SELECT, INSERT, UPDATE, DELETE).

Repeated Short Notes

• Data Redundancy

• Data Integrity

• ER Model

• ACID Properties

• Structured Query Language

 Unit 3: E-Commerce

Long Questions

1. Define E-Commerce and explain its features and advantages.

2. Explain types of E-Commerce (B2B, B2C, C2C, C2B).

3. Explain Electronic Payment System and its types.

4. Explain security issues in E-Commerce.

5. Explain EDI (Electronic Data Interchange).

Repeated Short Notes

• Digital Signature

• Encryption

• Online Banking

• Payment Gateway

• Advantages and Limitations of E-Commerce

 Unit 4: E-Business and E-Governance

Long Questions

1. Define E-Business and differentiate it from E-Commerce.

2. Explain E-Governance and its types (G2C, G2B, G2G).

3. Explain applications of E-Governance in India.

4. Explain benefits and challenges of E-Governance.

Repeated Short Notes

• M-Commerce

• ERP

• CRM

• E-Tendering

• Digital India

Unit 5: Cyber Laws and IT Act

Long Questions

1. Explain objectives and features of the Information Technology Act, 2000.

2. Explain types of Cyber Crimes.

3. What is Hacking? Explain penalties under IT Act.

4. Explain Digital Signature and its legal recognition.

5. Explain Cyber Security measures.

Repeated Short Notes

• Phishing

• Identity Theft

• Data Protection

• Cyber Terrorism

• Malware