SUPERIOR GROUP OF COLLAGES

MULTIPLE CHOICE QUESTIONS

UNIT#01+02
1. Storage and retrieval of data is related to:

A Data Capturing B Data manipulation C Managing output D Analysis Result

2. A collection of related data field is called:

A File B Database C Attributes D Record

3. A logical grouping of Character is:

A Field B Record C File D Data Base

4. A text file data is stored in:

A ASCII-Code B Binary Code C Octal Code D Text Code

5. Data can be recovered in case of loss by using:

A Master File B Transaction File C Backup File D Data File

6. A database is an organized collection of data:

A Physically B Loosely C Random D Logically

7. A request for information from database terminology is called:

A Report B Letter C Table D Querry

8. The extension of image file is:

A .exl B .doc C .bmp D .ppt

9. Which of the following is known as data set?

A Record B Field C File D Module

10. Data inconsistency is caused by:

A Organized data B Integrated data C Independent data D Redundant data

11. The category of data that describes an entity is called:

A Attribute B Data item C Record D Tuple

12. A table must have a:

A Primary key B Secondary key C Composite key D Sort Key

13. Which of the following can be a primary key?

A Last name B Salary C Customer ID D Region

14. Which of the following is not included in the definition of entity?
A Person B Object C Concept D Action
15. The column of a table correspond to:

A Table B Record C Field D Cell

 UNIT#03+04
1. Which of the following is not included in the definition of entity?

A person B Object C Concept D Action

2. The degree of relation refers to the number of:

A Rows B Tables C Data D Columns

3. in ERD model, the relationship b/w two entities are represented by:

A Rectangle B Oval C Square D Diamond

4. Color of car is an example of:

A Entity B Attributes C Relation D Concept

5. Merging the relation is also known as:

A View integration B View entities C View tables D View relations

6. In relational database, a table is also called:

A Tuple B Relation C File D Schema

7. Every relation must have……key?

A Candidate B Foreign C Primary D All

8. A row of relation is called:

A Attribute B Entity C Tuple D Relation

9. Transitive dependency is removed in:

A 1st normal form B 2nd normal form C 3rd normal form D 4th normal form
10. The goal of normalization is to:

A Increase B Decrease C Get stable D Increase Anomalies

11. In 2NF, which form of dependency is removed:

A Functional B Partial C Associative D Transitive

12. Which of the following is one-to-many relations?

A Student-Reg No. B Mother-Daughter C Person-Date of D Country-Capital

Birth
13. A person’s name, birthday and social security number are examples of:

A Attributes B Entities C Relationships D Descriptors

14. A relation that contains minimal redundancy and allows easy use called:

A Clean B Simple C Complex D Well-Structured

15. Data inconsistency is caused by:

A Organized data B Integrated data C Independent data D Redundant data

 UNIT#05+06
1. Which shortcut key is used to open an existing file in MS-Access?

A CTRL+N B CTRL+P C CTRL+O D CTYRL+ Z

2. A report may be based on:

A Table B Relationship C Form D Attribute

3. Which object is used to store data in database?

A Macro B Table C Form D Report

4. Which of the following is not a database object:

A Table B Query C Form D MS-Word

5. In, MS Access, Table contains:

A Fields B Records C Character D File

6. A database consists of various components called:

A Tools B Properties C Entities D Objects

7. The degree of relation refers to the number of:

A Rows B Tables C Fields D Columns

8. Each set of related items in a table is called:

A Table B Record C Field D Query

9. Which data type is default type in access:

A Memo B Number C Text D Auto number

10. Create command is used to create:

A Table B View C Report D Query

11. Which wildcard replaces one character only?

A * B ? C : D !
12. Which field type can be indexed?

A memo B Number C Hyperlink D DLE

13. To find four character names that starts with H, the criteria is specified as:

A H*a B H?4 C H??? D H##

14. The graphically query tool is known as:

A Query grid B Design grid C Query form D View form

15. How many query views are available in MS-Access?

A 2 B 3 C 4 D 5
 UNIT#07+08
1. C language was developed in

A 1962 B 1969 C 1970 D 1972

2. C-Language programs are divided into units called:

A Section B Syntax C Function D Debug

3. Which of the following is used to denote pre-processor directives?

A % B $ C # D @
4. Which of the following key is used to save as file:

A F2 B F3 C F5 D F9
5. The name header file is written between:

A [] B () C <> D {>
6. Header file in C contains:

A Compiler command B Library functions C Header D Operators

7. A program syntax error is detected by:

A Linker B Compiler C Loader D Debugger

8. An IDE consists of:

A Text editor B Compiler C Debugger D All of these

9. The extension of header file is:

A .c B .txt C .hf D .h
10. The output of the compiler is:

A Library code B Linked code C Object code D Source code

11. How many form layouts are available in MS-Access?

A 2 B 3 C 4 D 5
12. A report may be based on:

A Table B Relationship C Form D Attributes

13. How many Reports layout are:

A 2 B 3 C 4 D 5
 UNIT#09+10
1. Variables and constants name cannot contain a(an):

A Letter B Underscore C Period D Number

2. Which is numeric data type:

A Floating point B Integer C Both A and B D None of these

3. Total number of keywords in C is:

A 30 B 32 C 34 D 36
4. The number of bytes used by int type in C is:

A 2 B 4 C 6 D 8
5. The only binary operator in the following is:

A ? B ++ C M D +
6. a + = b is equivalent to:

A b+=a B a=+b C a = a+b D b=b+a

7. The value of logical operator OR will be 1 if:

A A=0 & B=1 B A=1 & B=0 C A=1 & B=1 D All of these
8. int is.........in C.

A Special word B Key word C Cut word D First word

9. The number of bytes an un-signed integer data type cosumes is:

A 1 B 2 C 4 D 8
10. The left side of an assignment statement holds:

A variables B constant C Expression D Digit

11. Which escape sequence is used to begin new line

A \a B \b C \m D \n
12. Printf() is a:

A keyword B Built in function C Local function D User defined

function
13. The ASCII code for escape key:

A 27 B 28 C 29 D 30
14. the function getch ( ) is defined as:

A Stdio.h B Conio.h C String.h D Math.h

 UNIT#11+12
1. Which programming structure executes program statements in order?

A Relation B Decision C Sequence D Repetition

2. Another term for computer making a decision is:

A Sequential B Selection C Repetition D Iteration

3. If a relational expression is true, it has a value:

A 0 B 1 C -1 D None
4. In If-Statement, false is represented by:

A 0 B 1 C 2 D 3
5. The conditional operator is used as alternate to:

A if B If-else C If-else if-else D Switch

6. Graphical representation of a program is called:

A Logic chart B Binary Chart C Flow chart D E-R Chart

7. Conditional operator takes:

A One operand B Two operand C Three operand D Four operand

8. Which operator in C is Called Ternary operator?

A If B ++ C ? D ()
9. The expression 0% 4 has a value equal to:

A 0 B 1 C 2 D 4
10. How many basic selection statements are in C?

A 1 B 2 C 3 D 4
11. How many types of loop structures are present

A 1 B 2 C 3 D 4
12. One execution of loop is known as a (n):

A Test B Iteration C Duration D Integer

13. Which of the following loop is called counter loop?

A For B While C Do-While D None

14. What is the final value of x after executing the code for (int x=0; x<10; x + + )?

A 8 B 9 C 10 D 11
15. A loop within a loop is called:

A Complex B Nested C Infinite D For

 UNIT#13+14

1. Another name of built-in function is:

A Library function B Arithmetic function C User defined D All of these

function
2. The first line of user defined function is:

A Arguments B Header C Prototype D Calling

3. In C-Language, first line of function definition is known as:

A Function header B Function body C Arguments D Parameters

4. The scope of variable refers to:

A Length B Name C Accessibility D Data Type

5. Memory allocated to a local variable at the time of its:

A Declaration B Destruction C Definition D First reference

6. A function can return............Values:

A 1 B 2 C 3 D 4
7. Global variables are created in:

A RAM B ROM C Hard Disk D Cache

8. The Character conversion may occur in:

A Text stream B Binary Stream C Input Stream D Output Stream

9. A file is stored in:

A RAM B ROM C Hard Disk D Cache

10. fOpen() function takes......parameters.

A 1 B 2 C 3 D 4
11. A …… can store text only.

A Binary file B Text file C exe file D Object file

12. In.....file opening mode, data can only be read from an existing file:

A w B w+ C r+ D r
13. On successful closing a file, the fclose () returns:

A Null B Zero C One D File pointer

14. A binary stream is a sequence of:

A Bits B Bytes C kilobytes D Giga Bytes

15. Functions that are the part of language are called:

A Intrinsic B Built in function C Language defined D All

 SHORT QUESTIONS
UNIT#01+02
1. Define Data and information. 2. Define data integrity.
3. Define data capturing and data 4. State the purpose of query language.
manipulation.
5. Define data set and data dictionary. 6. Identify name of entity and primary key in
the following:
STUDENT (student ID, St name, Group)
7. Define Network model. 8. List three examples of DBMS.
9. What is Record and field? 10. What is the purpose of backup and
recovery?
11. Define program. 12. Why do people use data base?
13. What is direct access file and sequential 14. List down any two features of DBMS.
file?
15. Define End User. 16. Why are keys defined in table?
17. Differentiate b/w Database and Table. 18. Distinguish b/w an entity class and entity
instance.

UNIT#03+04
1. Define entity integrity. 2. Define mutual exclusiveness of data.
3. How is entity integrity maintained? 4. When is a relation in 3NF?
5. Define referential integrity. 6. State the purpose of cardinality.
7. What is Normalization? 8. Write any two criterias to select file
organization.
9. Define function dependency with 10. Why feasibility study is used?
examples.
11. Define synonym. 12. Define analysis.
13. Write difference b/w full functional 14. What is the importance of project
dependency and transitive dependency. planning?
15. What are database Anomalies? List their 16. List three uses of logic flow diagram.
names.
17. Define repeating group. 18. What is the concept of data distribution
strategy?

UNIT#05+06
1. Differentiate b/w degree of relation and 2. Name four database objects in MS-Access.
Cardinality of relation.
3. Define integrated development 4. Discuss role of query in database.
environment. Discuss two disadvantages.
5. Write Advantages of IDE. 6. How query is written?
7. List four advantages of query. 8. Define form. List its two uses.
9. State use of wildcards. 10. Write definition of reports.
11. What is referential integrity? 12. List any two uses of reports.
13. List two advantages of MS-Access. 14. Define database.
15. Define the term RDBMS. 16. What is OLE object in MS-Access?
17. What is database wizard? 18. What is use of input mask?
 UNIT#07+08
1. What is computer program and who is 2. What is meant by structured programming
programmer? language?
3. Write two characteristics of C-Language. 4. Differentiate b/w pre-processor directives and
header file.
5. Write the use of Turbo C++ 6. Explain constant macro with example.
7. What is object code? 8. Define Delimiters.
9. Define source code. 10. What is statement of terminator?
11. What is Object oriented language (OOP)? 12. What is Debugging?
13. What is the process of linking in C programs? 14. Write down procedure for writing a program in
C-Language.
15. Define Form in MS-Access. 16. Write advantages of Form.
17. What do you know about Columnar Form? 18. Write the use of data sheet form and reports.

UNIT#9+10
1. What is an identifier? Give an example. 2. Define format specifier with example.
3. Differentiate b/w Standard and user- 4. Write the syntax of Printf statement.
defined identifier.
5. C is a case sensitive language. What does 6. What is the use of OR and AND logical
it mean? operator?
7. Differentiate b/w Declaring and defining a 8. What is compound assignment operator?
variable.
9. What is the value of Y after the following 10. What is garbage value?
code executes?
Float y=3.4 +sqrt (25.0)
11. Identify error in the following lines: 12. Why does cancellation error occur?
Integer A=2+3;
Float B=5;
Int C=A+B;
13. Find the output of following code: 14. Differentiate b/w getch () function and getche()
Main() function.
{
Printf(“444\n”);
Printf(“44”);
}
15. Give single print statement to print the 16. Define standard input.
followingmessage:
No. of employees
No. of officers
17. Trace error: 18. Why the ampersand (&) used in scanf is
Include<STDIO.H> function?
VOID Main();
{Printf (“Pakistan”);
}
19. Discuss operators of C 20. What is Scanf function?
 UNIT#11+12
1. What is Control Structure? List types. 2. What is the use of if-else statement?
3. Define Compound statement. 4. What do you mean by condition?
5. Define one way decision and draw flow chart. 6. What is nested if statement. Write syntax.
7. What is the output of following code? 8. Trace the error from the following:
Int m, n: Void main ()
m=0; {
n=m; Int a=2;
if (m= = n) If (a=1);
printf (“AMBITIOUS”); Printf (“oK”);
else else
Printf (“ACADEMY”); printf (“No”);
}
9. Write a program that inputs a number from 10. Write down the syntax of ternary operator.
user and finds it is positive, negative or zero.
11. Write a program in C that inputs a number by 12. Write a program which inputs three numbers
the user and checks whether it is even or odd. and displays smallest number.
13. Write syntax of if-else statement. 14. Write a program in C that inputs the number of
months of the year and displays the number of
days of the corresponding month using if-else-if
statement.
15. Define While loop. Make its flow chart. 16. Differentiate b/w inner and outer loop.
17. Write output of following program fragments: 18. Why is sentinel value used in loop?
n=0
While (n<=4)
{
Printf (“ %3d % 3d\n”, n, 10-n);
n++
}

UNIT#13+14
1. What is meant by function definition? 2. What is lifetime of global variable?
3. Write syntax of function definition. 4. How long the global variable exists in
memory?
5. Define function body. 6. What is return statement?
7. Write the use of function prototype? 8. Describe the purpose of file handling?
9. Write the general form of function 10. Write file opening modes.
prototype.
11. What is function call statement? 12. Write the use of new line marker.
13. Define local variables. 14. Define pointer.
15. What is meant by scope of variables? 16. How is file opened and closed in C?
17. Define global variables. 18. Write use of fopen function.
19. What is function header and declaration? 20. Discuss Difference b/w binary and text
write their syntax. stream.
21. Define stream and function. 22. Give types of functions in C
 LONG QUESTIONS
UNIT#01
1. Explain data base system and also explain its components
2. Discuss Advantages and Disadvantages of DBMS.
3. Discuss types of Data Base model
4. Objectives of database management system
5. What is file explain types of file usage point of view.

UNIT# 3
1. What is data modeling. explain its gradients
2. What is ER Diagram . explain with example
3. What is relationship. Explain its types
4. Write detail note on distribution strategies of data

UNIT#06
1. What is Table Write its characteristics and methods to modify a table.
2. Explain procedure for creating a simple form also discuss procedure to create form by using
wizard and design view.
3. Define query. Discuss its types.
4. How can we extract data from two tables?

UNIT#08
1. Describe language Processor and their use. Discuss different Types of language
processors.
2. What is an error? Explain different types of Errors in C-Language.
3. Discuss structure of C Program.
4. Discuss Program execution cycle with block diagram.( write the necessary steps to prepare the
execution of program)
5. Explain the characteristics of c language

UNIT#11
1. Write a program that inputs marks and displays “Congratulation! You have passed”.
If the marks are 40 or more.
2. Write a program that inputs two numbers and find if second number is square of first number.
3. Write a program that inputs two numbers and finds whether these numbers are equal or not using if-
else structure.
4. Write a program that inputs a number and finds whether it is even or odd using if-else structure.
5. Write a program that inputs three numbers and displays maximum (largest ) number.
6. Write a program that inputs a year and finds whether it is a leap year or not using if-else structure.
7. Write a program that inputs a number from user and determines whether it is positive,negative or
zero.
8. Write a program that inputs radius. It calculates area of circle if user enters 1 as choice.
9. It calculates circumference if the user enters 2 as choice.
10. Write a program that inputs three numbers and displays the smallest using nested if.
11. Write a program that inputs three numbers and displays whether all numbers are equal or not by
using nested if condition.
 12. Write a program that inputs a numbers and displays whether it is even or odd by using logical
operator “!”.
13. Write a program that inputs a number of weekdays and displays the name of the day.
14. Write a program that inputs a character from user and checks whether it is a vowel or consonant.
UNIT#12
1. Write a program that displays counting from 1 to 10 using While loop and do while and for loop
2. Write a program that displays first five numbers and their sum using while loop and do while and for
loop.
3. Write a program that displays the following series using while loop.
1 3 5 7 9 11 13 15 19 21 23
4. Write a program that inputs a number from user and displays the factorial of that number using
while loop and do while and for loop.
5. Write a program that inputs a number from user and displays the table of that number using while
loop and do while and for loop.
6. Write a program that displays the sum of the following series using while loop.
1+1/2+1/4+1/6+…………….+1/100.
7. Write a program that displays “Pakistan” for five times using do-while loop.
8. Write a program that displays first ten odd numbers using do-while loop.
9. Write a program that gets starting and ending point from the user and displays all odd numbers in
the given range using do-while loop.
10. Write a program that displays the sum of the following series using do-while loop.
1+1/3+1/5+1/7+…………………….+1/99
11. Write a program to print the sum of odd numbers between 1 and 100.
Sum=1+3+5+…………………+99
12. Write a program in C language to print the following series.
0 3 6 9 12 15
13. Write a program that uses a while loop to enter a number from the user and then display it.The loop
is terminated when user enter -1.
14. Write a program that display the first 15 even numbers.
 MOST REPEATED SHORT QUESTIONS
Database C Language
1- Data vs Information Introduction to c
2- Field = Attribute = Column = Fact = Property 1. Computer program and programmer
3- Tuple = Record = Instance = Occurrence = Row 2. Structured Vs Non structured language
4- Data file = Entity = Table = Relation 3. C Statement
5- Database with example 4. Machine Independence
6- DBMS and RDBMS 5. Header file
7- File and its type (Program Vs Data ) 6. Preprocessor directives
8- Data dictionary 7. Delimiter
9- Data independence 8. Comments
10- Data integrity [and its types] 9. Conditional operators
11- Data Security 10. Linker Vs Loader
12- View 11. Identifiers and its types
13- Index 12. Variable Vs Constant
13. Variable declaration Vs Variable definition
14- File organization
14. Source Code Vs Object
15- Cardinality Vs Modality
15. Lvalue Vs Rvalue
16- Entity Vs Entity instance
16. Data types and its types
17- Synonyms Vs Homonyms
17. Overflow Vs Underflow
18- Functional dependency
18. Assignment statement
19- Determinant
19. Standard Input Vs Standard Output
20- IDE
20. printf() Vs scanf()
21- Wizard
22- Degree Vs Order (cardinality) 21. Format specifier
22. Escape sequence
23- Input mask
23. Field width
24- Wild Card
24. Control Structure
25- Macros
25. If statement OR if-else statement
26- Join
26. Nested if else statement
27- Sub-form
27. Loop Or repetition Or iterative control structure
28- Form elements (Combo box Vs List)
28. while Vs do-while loop
29- Query
29. goto statement
30- Property of relation
30. continue Vs break statement
31- SQL
31. counter controlled Vs Sentinel Controlled
32- Field properties
32. Nested loop
33. Function and its types
34. Function prototype
35. Formal Vs Actual parameters
36. Global variable Vs Local variable
37. Static variable
38. Stream and its types
39. String
40. Array
41. Pointer
42. Data file Vs Program file
43. EOF Vs Newline