.jpg)
Important Questions for Second Year Computer Science
This guide is designed for students affiliated with all Punjab Boards and the Jammu Kashmir Board. It provides a structured list of essential questions organized by chapter to aid in exam preparation.
Unit One: Introduction to Database Systems
Describe data manipulations.
What is a field?
Define a program file and provide an example.
Define program organization and name different types of file organization.
Differentiate between data and information.
Define data processing.
Define redundancy.
Name two features of a DBMS.
Unit Two: Database Components
What are the properties of a relation?
Define indexes.
Define a foreign key.
Define a key and list different types of keys.
Define data administration.
Define a table or relation.
How is a relation formed in a database?
What is an entity in an ERD?
Who is a user or end user?
What is the purpose of using views?
Unit Three: Data Modeling and Design
Define an attribute.
Define data modeling.
Define the purpose of a feasibility study.
What is an E-R diagram?
Unit Four: Database Dependencies and Integrity
Define transitive dependency.
Define an entity.
Define integrity.
Define synonyms in a database context.
Define database integrity.
Define partial dependency.
Unit Five: Introduction to RDBMS and MS Access
Define RDBMS.
Differentiate between a form and a report.
What is a database wizard or sample database?
How is a query written?
List some advantages of an IDE.
State the uses of MS Access.
What are reports?
Enlist the parts of the application window in MS Access.
Unit Six: Working with Tables in MS Access
Define a primary key.
What is the use of datasheet views in MS Access?
Define the cardinality of a relation.
Define the degree of a relation.
Write down two table views available in Access.
Unit Seven: Forms and Visual Basic in Access
What is a subform?
What are the uses of columnar forms?
What is the purpose of control naming convention?
What is the syntax of a msgbox?
What are methods in VB?
What is a property window?
What is a code window?
What is the purpose of a timer control?
Differentiate between key press and key up events.
What are the events of a mouse?
What are the events of a keyboard?
Unit Eight: Programming Fundamentals
Define a programming language.
What does case sensitive mean in C language?
What is a preprocessor directive?
Define a programmer.
Differentiate between logical errors and syntax errors.
What are header files?
Differentiate between a compiler and an assembler.
Differentiate between source code and object code.
What are delimiters?
What are run time errors?
Define a structured programming language.
What is Visual Basic?
Differentiate between visual programming and event driven programming language.
What is a .NET function?
What is VBA?
Unit Nine: Variables, Constants, and Operators
Define an identifier with an example.
Differentiate between declaring and defining a variable.
Define variables and state two rules for naming variables.
What are the uses of an assignment statement?
What is operator precedence?
Define a constant and list different types of constants.
What is a character constant?
What are keywords?
What is a concatenation operator?
Unit Ten: Input and Output in C
What is standard input?
What is an escape sequence?
What is the getche() function?
What are the uses of a format specifier in C language?
What is the use of the scanf function?
What is the clrscr function?
Predict the output for a given code snippet.
Trace the error in a given code segment.
List some important functions for input.
Unit Eleven: Control Structures - Selection
What is a control structure and a selection structure?
Find the output of a given code segment.
Explain an if statement.
Find the error in a given code segment.
Write the syntax of an if-else statement.
Why is a break statement used in a switch structure?
Explain a switch statement.
Unit Twelve: Control Structures - Repetition
What is a while loop?
What is a sentinel control loop?
Write the syntax of a for loop.
Write the syntax of a do while loop.
What is an iteration?
Unit Thirteen: Functions
Define a function and list some benefits of using functions.
What are local variables and what is their scope?
Compare local variables and global variables.
What is a function call?
What are actual parameters?
What are built-in functions?
What is the lifetime of local variables?
Differentiate between function definition and function declaration.
Unit Fourteen: Files and Advanced Concepts
Compare binary and text streams.
Define a binary file system.
What are text files?
Why is it important to close a file?
Describe a project file in VB.
What is the project explorer window?
Differentiate between a method and a property.
This guide is designed for students affiliated with all Punjab Boards and the Jammu Kashmir Board. It provides a structured list of essential questions organized by chapter to aid in exam preparation.
Unit One: Introduction to Database Systems
Describe data manipulations.
What is a field?
Define a program file and provide an example.
Define program organization and name different types of file organization.
Differentiate between data and information.
Define data processing.
Define redundancy.
Name two features of a DBMS.
Unit Two: Database Components
What are the properties of a relation?
Define indexes.
Define a foreign key.
Define a key and list different types of keys.
Define data administration.
Define a table or relation.
How is a relation formed in a database?
What is an entity in an ERD?
Who is a user or end user?
What is the purpose of using views?
Unit Three: Data Modeling and Design
Define an attribute.
Define data modeling.
Define the purpose of a feasibility study.
What is an E-R diagram?
Unit Four: Database Dependencies and Integrity
Define transitive dependency.
Define an entity.
Define integrity.
Define synonyms in a database context.
Define database integrity.
Define partial dependency.
Unit Five: Introduction to RDBMS and MS Access
Define RDBMS.
Differentiate between a form and a report.
What is a database wizard or sample database?
How is a query written?
List some advantages of an IDE.
State the uses of MS Access.
What are reports?
Enlist the parts of the application window in MS Access.
Unit Six: Working with Tables in MS Access
Define a primary key.
What is the use of datasheet views in MS Access?
Define the cardinality of a relation.
Define the degree of a relation.
Write down two table views available in Access.
Unit Seven: Forms and Visual Basic in Access
What is a subform?
What are the uses of columnar forms?
What is the purpose of control naming convention?
What is the syntax of a msgbox?
What are methods in VB?
What is a property window?
What is a code window?
What is the purpose of a timer control?
Differentiate between key press and key up events.
What are the events of a mouse?
What are the events of a keyboard?
Unit Eight: Programming Fundamentals
Define a programming language.
What does case sensitive mean in C language?
What is a preprocessor directive?
Define a programmer.
Differentiate between logical errors and syntax errors.
What are header files?
Differentiate between a compiler and an assembler.
Differentiate between source code and object code.
What are delimiters?
What are run time errors?
Define a structured programming language.
What is Visual Basic?
Differentiate between visual programming and event driven programming language.
What is a .NET function?
What is VBA?
Unit Nine: Variables, Constants, and Operators
Define an identifier with an example.
Differentiate between declaring and defining a variable.
Define variables and state two rules for naming variables.
What are the uses of an assignment statement?
What is operator precedence?
Define a constant and list different types of constants.
What is a character constant?
What are keywords?
What is a concatenation operator?
Unit Ten: Input and Output in C
What is standard input?
What is an escape sequence?
What is the getche() function?
What are the uses of a format specifier in C language?
What is the use of the scanf function?
What is the clrscr function?
Predict the output for a given code snippet.
Trace the error in a given code segment.
List some important functions for input.
Unit Eleven: Control Structures - Selection
What is a control structure and a selection structure?
Find the output of a given code segment.
Explain an if statement.
Find the error in a given code segment.
Write the syntax of an if-else statement.
Why is a break statement used in a switch structure?
Explain a switch statement.
Unit Twelve: Control Structures - Repetition
What is a while loop?
What is a sentinel control loop?
Write the syntax of a for loop.
Write the syntax of a do while loop.
What is an iteration?
Unit Thirteen: Functions
Define a function and list some benefits of using functions.
What are local variables and what is their scope?
Compare local variables and global variables.
What is a function call?
What are actual parameters?
What are built-in functions?
What is the lifetime of local variables?
Differentiate between function definition and function declaration.
Unit Fourteen: Files and Advanced Concepts
Compare binary and text streams.
Define a binary file system.
What are text files?
Why is it important to close a file?
Describe a project file in VB.
What is the project explorer window?
Differentiate between a method and a property.
Important Long Answer Questions
What is data modeling and what are the ingredients of data modeling?
Define a query and explain the uses of wildcards in queries with examples.
Discuss different methods of modifying a table.
Briefly describe the basic structure of a C program.
While writing a C program, how many types of errors can occur and which one is the most difficult to locate and remove?
How would you create, edit, compile, link, and execute a program?
Define a language processor or translator and discuss different types of language processors.
Write a program that inputs a character and checks whether it is a vowel or consonant using a switch statement.
Write a program that inputs a year and finds whether it is a leap year or not using an if-else structure.
Write a program that inputs a number and tells whether it is even or odd using an if-else structure.
What is a while loop and explain its working with an example and a flowchart?
What is a do-while loop, write its syntax, and explain its working with an example?
What is a nested loop and explain it with an example and a flowchart?
What is a for loop structure and explain its working with an example and a flowchart?
Define a database system and explain any three components of a database system.
What is a key and discuss different types of keys?
What is an ER model and what are the symbols used in an ER diagram?
What is a field property and discuss different field properties in detail?
Explain different types of relationships with details.
What is a filter and discuss different types of filters in MS Access?
What is a program and a programming language and discuss two main categories of programming languages?
What is data modeling and what are the ingredients of data modeling?
Define a query and explain the uses of wildcards in queries with examples.
Discuss different methods of modifying a table.
Briefly describe the basic structure of a C program.
While writing a C program, how many types of errors can occur and which one is the most difficult to locate and remove?
How would you create, edit, compile, link, and execute a program?
Define a language processor or translator and discuss different types of language processors.
Write a program that inputs a character and checks whether it is a vowel or consonant using a switch statement.
Write a program that inputs a year and finds whether it is a leap year or not using an if-else structure.
Write a program that inputs a number and tells whether it is even or odd using an if-else structure.
What is a while loop and explain its working with an example and a flowchart?
What is a do-while loop, write its syntax, and explain its working with an example?
What is a nested loop and explain it with an example and a flowchart?
What is a for loop structure and explain its working with an example and a flowchart?
Define a database system and explain any three components of a database system.
What is a key and discuss different types of keys?
What is an ER model and what are the symbols used in an ER diagram?
What is a field property and discuss different field properties in detail?
Explain different types of relationships with details.
What is a filter and discuss different types of filters in MS Access?
What is a program and a programming language and discuss two main categories of programming languages?
Frequently Asked Questions (FAQs)
Q1: Are these questions relevant for my specific board (e.g., Lahore, Gujranwala, etc.)?
Yes, this list has been curated to cover the common curriculum across all major Punjab Boards (Lahore, Multan, Sargodha, etc.) and the Jammu Kashmir Board. The core topics are consistent, making this a universal guide for all students.
Q2: Should I only prepare these questions for my exam?
While this list focuses on highly important and frequently asked questions, it should be used as a powerful guide for your revision, not as a replacement for your textbook. We strongly recommend studying all chapters thoroughly and using these questions to test your knowledge and focus your final preparation.
Q3: How should I use this list effectively?
First, ensure you have studied the theoretical concepts from your textbook. Then, use this list to practice answering each question concisely. For short questions, write precise, to-the-point answers. For long questions, practice writing well-structured answers that include definitions, examples, and diagrams (like flowcharts) where necessary.
Q4: What is the best way to prepare for programming questions?
For programming questions (e.g., from Unit 8 onwards), reading the code is not enough. The best practice is to write the code yourself on paper. This helps you understand the logic, syntax, and common errors. Practice writing programs for checking vowels, leap years, and even/odd numbers until you can do them without hesitation.
Q5: I find database concepts difficult. Any tips?
Focus on understanding the definitions first. Concepts like keys (primary, foreign), relationships, and normalization are built upon basic terms. Draw the E-R diagrams yourself. For MS Access, if possible, try to perform the tasks practically (like creating queries, forms) as hands-on experience makes theoretical concepts much clearer.
Q6: Where can I find the answers to these questions?
The answers to all these questions can be found within your prescribed textbook. The purpose of this list is to direct your attention to the most exam-relevant topics. Carefully review the corresponding chapters to formulate complete answers.
Q1: Are these questions relevant for my specific board (e.g., Lahore, Gujranwala, etc.)?
Yes, this list has been curated to cover the common curriculum across all major Punjab Boards (Lahore, Multan, Sargodha, etc.) and the Jammu Kashmir Board. The core topics are consistent, making this a universal guide for all students.
Q2: Should I only prepare these questions for my exam?
While this list focuses on highly important and frequently asked questions, it should be used as a powerful guide for your revision, not as a replacement for your textbook. We strongly recommend studying all chapters thoroughly and using these questions to test your knowledge and focus your final preparation.
Q3: How should I use this list effectively?
First, ensure you have studied the theoretical concepts from your textbook. Then, use this list to practice answering each question concisely. For short questions, write precise, to-the-point answers. For long questions, practice writing well-structured answers that include definitions, examples, and diagrams (like flowcharts) where necessary.
Q4: What is the best way to prepare for programming questions?
For programming questions (e.g., from Unit 8 onwards), reading the code is not enough. The best practice is to write the code yourself on paper. This helps you understand the logic, syntax, and common errors. Practice writing programs for checking vowels, leap years, and even/odd numbers until you can do them without hesitation.
Q5: I find database concepts difficult. Any tips?
Focus on understanding the definitions first. Concepts like keys (primary, foreign), relationships, and normalization are built upon basic terms. Draw the E-R diagrams yourself. For MS Access, if possible, try to perform the tasks practically (like creating queries, forms) as hands-on experience makes theoretical concepts much clearer.
Q6: Where can I find the answers to these questions?
The answers to all these questions can be found within your prescribed textbook. The purpose of this list is to direct your attention to the most exam-relevant topics. Carefully review the corresponding chapters to formulate complete answers.