Computer Guess Important Long & Short Questions class 2nd year

2nd year computer important questions

below is the chapter wise list of important short questions for 2nd-year computer

Unit 1
Describe data manipulations
What is a field?
Define program file with example
Define program organization. Name different types of file organization.
Differentiate between data and information.
Define data processing.
Define redundancy.
Name two features of DBMS.
Unit 2
What are properties of relation?
Define indexes.
Define foreign key.
Define key. List different types of keys.
Define data administration.
Define table /relation
How a relation is formed in database?
What is an entity in an ERD.
Who is user or end user?
What is the purpose of using views?
Unit 3
Define and attribute.
Define data modeling.
Define the purpose of feasibility study.
What is E-R diagram?
Unit 4
Transitive dependency.
Define entity.
Define integrity.
Synonyms
Database integrity.
Partial dependency
Unit 5
RDBMS
Differentiae between form and report
Database wizard/sample database
How query is written
List some advantages of IDE
Uses of MS Access
Reports
Enlist the parts of application window in MS Access.
Unit 6
Primary key
What is the use of data sheet views in MS Access?
Cardinality of relation
Degree of relation
Write down two table vies available in Access.
Unit 7
Sub form
Uses of columnar forms
Purpose of control naming convention
Syntax of msg box
What are methods in vb?
Property window
Code window
Purpose of timer control
Differentiate between key press and key up events
Events of mouse
Events of keyboard
Unit 8
Define programming language
Case sensitive in C language
Preprocessor directive
Programmer
Differentiate between logical errors and syntax errors
Header files
Compiler and assembler
Differentiate between source code and object code
Deli meters
Run time errors
Structured programming language
Visual basic
differentiate between visual programming and event driven programming language
what is .net function
what is VBA?
Unit 9
Define identifier with an

Computer Gues 2nd Year

Data manipulation,data redundancy, database,dbms,rdbms,types of database models,sql,data dictionary.define DDL,DML &DCL. Wht is a key? dfrnt typs of keys used in databases, defne domain, user or end user, DBA,Entity, relationshp, cardinality, ER Diagram,file orgnztn,redundancy,function dependency, normaliztn, 1NF,2NF,3NF, Database Anomalies, transitive dependency. IDE,Dfrnce tolbr &menu br,queries, field name,sortng, wht is conditio nal frmtng.

Computer 2nd year important long questions

What is data modeling? What are ingredients of data modeling? (unit 3)

Explain different data types available in MS Access. (Unit 6)
Define query. Explain the uses of wildcards in queries with examples. (Unit 6)

Discuss different methods of modifying a table. (unit 6)

Briefly describe the basic structure of a C program. (unit 8)

While writing a c program, how many types of errors ca occur? Which one is the most difficult to locate and remove ( unit 8)
How would you create, edit compile, link and execute a program? (Unit 8)

Define a language processor or translator. Discuss different types of language processors. (Unit 8)

Write a program that inputs a character and checks whether it is a wovel or consonantusing switch statement. (unit 11)

Write a program that inputs a year and finds whether it is leap or not. Using if-else structure. (unit 11)
Write a program that inputs a number and tells whether it is even or odd using if-else structure. (unit 11)

What is while loop? Explain its working with an example and flow chart (unit 12)

What is do-while loop. Write its syntax. Explain its working with example. (unit 12)

What is nested loop? Explain with example and flowchart. (unit 12)
What is for loop structure? Explain its working with example and flowchart. (unit 12)

Define database system. Explain any three components of database system. (unit 1)

What is key? Discuss different types of keys. (unit 1)

What is ER model? What are symbols used in ER diagram? (unit 3)
What is field property ? discuss different field properties in details (unit 6)

Explain different types of relationships with details. (unit 3)

What is filter? Discuss different types of filters in MS Access. (unit 6)

What is program and programming language? Discuss two main categories of programming language. (unit 8)