2nd year Computer Guess Paper
Full book important Short and Long questions as a form of 2nd year Computer Guess Paper written by Professor Mr. Faraz Qasir Suib. These notes are very helpful in the preparation of the 2nd year Computer Guess Paper of Computer Science for the students of the intermediate and these are according to the paper patterns of all Punjab boards.
Summary and Contents:
Topics which are discussed in the notes are given below:
- Here are the detailed 2nd year Computer Guess Paper to help you prepare for your exams.
- Important Short and Long questions of each chapter of the Computer Science Class 12.
- Describe Data Manipulation on
gathered data and its step
Classifying.
- Describe Data Manipulation on
gathered data and its step
Calculation.
- Describe Data Manipulation on
gathered data and its step
Sorting.
- Describe Data Manipulation on
gathered data and its step
Summarizing.
- Explain two steps of
Management of Results Output
after Manipulation.
- Explain Traditional File System,
including Record & File.
- Explain File Types from Usage
point of view.
- Explain File Types from
Functional point of view.
- Explain File Types from Storage
(File Organization) point of
view.
- Explain Database System with
Diagram.
- Describe Main Components of
Database System.
- Describe three Database
Objectives.
- Explain Hierarchical Database
Model with Diagram.
- Explain Network Database
Model with Diagram.
- Explain Relational Database
Model with Diagram.
- Explain Database Management
System.
- Describe Objectives of Database
Management System.
- Describe five Advantages of
Database System.
- Describe five Disadvantages of
Database System.
- Describe Features of Database
Management System (DBMS).
- Explain Field, Record and File
with all their names.
- Explain Relation with example
and Properties of Relation.
- Explain RELATION or TABLE. Describe Keys with examples
and Types of Keys.
- Explain Entity, with example and
database modeling.
- Describe four Properties of
Relation.
- Describe four aspects of Practical
Scenario of owning a Database.
- Describe Data Modeling, its
Ingredients, Cardinality and
Modelity.
- Explain three Ingredients of Data
Modeling.
- Describe Database Design and
explain Logical Database
Design.
- Explain Cadinality and Modality
with Diagram.
- Describe Database Design and
explain Physical Database
Design.
- Explain Entity-Relationship (ER)
Diagram with example.
- 1 Explain Data Integrity along with
the two constraints.
1 Describe Data Integrity, explain
Normalization in detail with its
problems.
2 Explain Normalization. 2 Describe Normalization steps
with diagram and explain 1NF.
3 Explain Functional Dependency. 3 Describe Normalization steps
with diagram and explain 2NF.
4 Differentiate between Synonyms
& Homonyms in Normalization.
4 Describe Normalization steps
with diagram and explain 3NF.
5 Explain Redundant Information.
6 Explain Mutually Exclusive
Data.
7 Graphically express
Normalization Steps with
appropriate remarks.
8 Describe First Normal Form
(1NF).
9 Describe Second Normal Form
(2NF).
10 Describe Third Normal Form
(3NF).
11 Explain Transitive Dependency.
- Describe Declaring, Defining,
Initializing and Rules for
Naming Variables.
- Explain Data Types for Integers,
Floating Point Numbers &
Characters.
- Explain Arithmetic, Relational
and Logical Operators in C with
Tables.
- Explain Assignment, Increment,
Decrement and Compound
Assignment Operators.
- Explain Operator Precedence in
C with complete Table.
- Explain Expression, its Data
Type, Division and Comments
with example program.
- 1 Explain printf Function in C with
an example program.
1 Explain printf function, Format
& Field-Width Specifiers.
2 Explain Format Specifiers in
printf Function in C, using a
program.
2 Explain escape sequences, its
table and example program.
3 Explain Field Width Specifier in
printf Function in C, using a
program.
3 Explain scanf function, with an
example program.
4 Explain Escape Sequence in
printf Function in C, using a
program.
4 Explain Assignment, Increment,
Decrement and Compound
Assignment Operators.
5 Explain scanf Function in C,
using a program.
5 Explain Operator Precedence in
C with complete Table.
6 Differentiate between Character
Input functions getch() and
getche() in C.
6 Explain Expression, its Data
Type, Division and Comments
with example program.