CHAPTER NO. 1 DATA BASICS

SHORT QUESTIONS:

1. Difference between Data and Information.
2. What activities are involved in data processing? Discuss in details.
3. Describe the file types from usage point of view and functional point o view?
4. How do we organize the files on storage media?
5. Describe the different database models?
6. Write advantages and disadvantages of the DEMS

LONG QUESTIONS:

1. In general, what activifies, arte be petfommed on the database? Discuss in details.
2. Describe the file types! from ‘usage ‘point of view and functional point of view.

CHAPTER NO. 2 BASIC CONCEPTS AND TERMINOLOGY OF DATABASES

SHORT QUESTIONS:

1. Define field, Record and file?
2. Discuss the tables/relations are formed up in DBMS?
3. Discuss the data manipulation in DBMS system.
4. Write down the properties of relations in details.
5. What is usage of indexes in FMS and DBMS?
6. Describe view?
7. Define key? Describe types of keys?
8. Define the data Administrator.
9. The Database Administrator.

lONG QUESTIONS:

1. How the Records and Files are constructed 3 in 1 traditioga Pile Ménagement system?

CHAPTER NO. 3 DATABASE DESIGN PROCESS

SHORT QUESTIONS:

1. Describé different steps involved i in analysis stage while designing a database.
2. Explain the following with the help of figures. Entity / Object, Attribute , Relationship
3. Explain Physical data model and conceptual data model.
4. Define and explain the term: Data distribution strategy, file organization.
5. Define the term analysis. Briefly discuss the following term: Feasibility study,
6. Requirement analysis, Data Analysis
7. Describe major objective Database Design? Explain Data Development process with diagram.

LONG QUESTIONS:

1. Draw and explain ER diagram for the system of getting admission in your college.

CHAPTER NO. 4 DATA ITAINTEGRITY AND NORMALIZATION

SHORT QUESTIONS:

1. Explain Data Integrity?
2. What is a’felation in 3NF?
3. Explain Normalization and Normal form?
4. Explain Second Normal form (2 NF)?
5. When 1s relation in first normal form? Explain with example.
6. Define referential integrity. How can 1t be achieved?
7. Define functional dependency?
8. What do we do to attain entity integrity?

LONG QUESTIONS:

1. Convert the ER diagram you have designed in the previous exercise for the admissions system of your college to relational database. Also normalize the relations up to third normal form.

CHAPTER NO. 5 INTRODUCTION TO MICROSOFT ACCESS

SHORT QUESTIONS:

1. Describe MS Access? Dgsribe hekehts of MS
2. Describe MS Access Database Components?
3. What 1s meant by RBMS?
4. What 1s an IDE?
5. Define the use of Toolbar in Microsoft Access.
6. What are the advantages of using a Microsoft Access IDE?
7. Differentiate between Form and Report.
8. Describe the Database Window in Microsoft Access.

LONG QUESTIONS:

1. Describe MS Access? Describe Benefits of MS.
2. Describe MS Access Database Components?

CHAPTER NO. 6 TABLE AND QUERY

SHORT QUESTIONS:

1. What are relationships?
2. Differentiate between Relationship and Join.
3. Define different type’s calculation in a query ade also specifies the some Functions.
4. What 1s query? Discuss its uses and advantages.
5. Differentiate between Sorting and Filtering.
6. Define the various type’s queries.
7. Define Basic Term used in Database?
8. How can you create a query in Design View?

LONG OUESTIONS:

1. Create a query in Design Vie create a query in Design view.
2. Different types calculation in query and also specifies the some Function.

CHAPTER NO. 7 MICROSOFT ACCESS -FORMS AND REPORTS

SHORT QUESTIONS:

1. Define the different layouts of forms.
2. Differentiate between forms or reports.
3. What is sub form?
4. What 1s report?
5. How is a form created for a single table?
6. How can you save and closed an auto report?
7. How can report created for a single table?
8. Describe object linking in MS Access?

LONG QUESTIONS:

1. Explam the processor for editing data through form.
2. How can you apply a sort order to the report?

CHAPTER NO. 8 GETTING STARTED WITH C

SHORT QUESTIONS:

1. Define a bug. Discuss some debugging features of Turbo C++.
2. Describe characteris ics of high- level programming languages.
3. Briefly describe the basic structure of a C program.
4. Difference between :
   Linker and Loader,
   Structured and Unstructured programming languages.
5. How would you create, edit, compile, link and execute a C program? Discuss briefly.
6. What necessary steps taken to prepare a C program for execution? Explain with diagram.

LONG QUESTIONS:

1. Describe characteristics of High Level Language.
2. What 1s meant by programming language? Discuss different types of programming language.
3. Explain C program Development Process with Diagram?

CHAPTER NO. 9 ELEMENTS OF C

SHORT QUESTIONS:

1. Describe Keywords?
2. Describe Variables?
3. How do you declare Variables in C?
4. Differentiate between declaring vs defining a Variable in C?
5. Describe Rules for Naming Variables in C?
6. Explain, Constant in C language?
7. Difference between Constant and Variable. Character constant and Numeric constant.
8. Write a note on the following : Arithmetic Expression, Comments in C.

LONG QUESTIONS:

1. What 1s variable? Discuss the difference between declaring and defining a variable.
2. Write down rules for naming variables in C.
3. What 1s a data type? Discuss various C data types to manipulate integers floating point numbers and characters.
4. How many types operators are available in C? Describe briefly. Also mention their precedence.

CHAPTER NO. 10 INPUT/OUTPUT

SHORT QUESTIONS:

1. What do we mean by standard input and output? Illustrate the use of print f() and scanf () function.
2. Illustrate the difference between format specifiers and field-width specifers with example
3. Define the term ‘escape sequence’. List names and used of any five escape sequences.
4. Explain Standard Library Functions for Character input?
5. Write a program that converts a temperature in degree Fahrenheit to degree 1 Celsius. For conversion use to formula: Celsius = 5/9 (Fahrenheit- 32)
6. Write the general form of print f function
7. What 1s the use of “getch” function?

LONG QUESTIONS:

1. Write the program in example 5 using scanf function.
2. Write a program that takes a positive number with a fractional part, and rounds it to two decimal places. For example, 25.4851 would round to 25.49 and 62.4431 would round to 32.44

CHAPTER NO. 11 DECISION CONSTRUCTS.

SHORT QUESTIONS:

1. What 1s a control structare? Briefly describe the basic control structures for writing program.
2. Describe the IF Statement? Explain test condition.
3. Describe simple IF statement? Explain it with diagram and an example.
4. Describe [F-ELSE statement? Explain it with diagram and an example.
5. Describe Nested IF Statement? Explain it with diagram and an example?
6. Compare Nested if and Sequence of ifs and explain with example?

LONG QUESTIONS:

1. Write a program in VB that input three numbers and display the maximum number by using
   nested in statement.
2. Define “IF-ELSE-IF” statement. Explain its working with syntax. Flowchart and example.

CHAPTER NO. 12 _LOOP CONSTRUCTS.

SHORT QUESTIONS:

1. Define a loop. How many loops are available in C? Compare the following loops:
   a) While loop and do-while loop b) While loop and for loop.
2. Describe Iteration and loop?
3. Describe FOR Siatement its Execution Sequence, with flowchart and example?
4. Describe Nested Loop Statement with example?
5. Describe GOTO Statement? Explain it with example program?

Long QUESTIONS:

1. Write a program that inputs a number and displays the message “ Prime Number” 1f it 1s a
   prime number, otherwise displays “ Not a prime Number”.
2. What 1s for next loop? Write down syntax and working of for next loop with example.
3. Write a program to print odd numbers from 1 to 10 using while loop.

CHAPTER NO. 13 FUNCTIONSINC

SHORT QUESTIONS:

1.Describe and Structured Programming? Define Function and differentiate between Unstructured and Structured programming?
2.Describe benefits of use of Functions?
3.Explain the Two Types of Functions?
4.Explain the Function Prototype in C?
5.Explain Functions without Arguments with an example program?
6.Write three advantages of functions?
7.How 1s a function call made in a C program? Discuss briefly?
8.Difference between: Function Definition and Function Declaration, Global and Local
variables, Formal parameters and Actual parameters of a function?

LONG QUESTIONS:

1. What type of variables are declared outside any function?
2. How many values can a function return using return statement?

CHAPTER NO. 14 – FILEHANDLINGIN C

SHORT QUESTONS:

1. Explain the concept oF Streams C?
2. Explain File opening in C,its Modes, and file pointer with an example program?
3. Explain File Closing in C?
4. Explain String Handling in Text Files (including fputs() and fgets() functions) in C?
5. What 1s a file pointer? Briefly explain the concept?
6. Can a file be used for both input and output by the same program?

LONG QUESTIONS:

1. Write a program that counts the total number of characters in a text file?
2. Write a program that counts the numbers of words in a text files and display the count on
   the screen?