FAISALABAD BOARD 2012
COMPUTER SCIENCE
PART-II
Time: 20 Mintes     
(Objective Part)   
Marks: 15
Note: Four Answers are given against each column A,B,C&D. Select the write answer and only separet answer sheet, fill the circle A.B,Cor D with pen or marker in front of that question number.
MS ACCESS

• How many primary keys can a table has?
  

(a) One                       
(b) Two
(c) Four                       
(d) Unlimited

• In 3NF which form of dependency is removed:
  

(a) Functional             
(b) Non-functional
(c) Associative            
(d) Transitive

• The data in tables is entered in:
  

(a) Design view       
(b) Normal view
(c) Data sheet view
(d) Layout view                                        

• Customers, cars and parts are example of :
  

(a) Attribute      
(b) Cardinals
(c) Relationships    
(d) entities

• DBMS stand for:
  

(a) Database modeling system
(b) Database management system
(c) Data business model system
(d) Data Boolean management system

• The columns of a table correspond to:
  

(a) Table             
(b) Record
(c) Field              
(d) Cell

C- LANGUAGE OR VISUAL BASIC
C - LANGUAGE

• One execution of a loop is known as:
  

(a) Cycle            
(b) Duration
(c) Iteration            
(d) Test

• Which programming structure executes program statement in order?
  

(a) Relation        
(b) Decision
(c) Sequence          
(d) Repetition

• Which function is used to input data in C-Language, program?
  

(a) Printf ( )        
(b) Scanf( )
(c) Sqrt ( )         
(d) Puts ( )

• Conditional operator takes:
  

(a) Three operands   
(b) Two operands
(c) Four operands 
(d) One operand

• Variable name cannot begin with:
  

(a) Number         
(b) Under score
(c) Upper case letter
(d) Lower case letter

• Memory is allocated to a local variable at the time of ifs.
  

(a) Declaration    
(b) Definition
(c) First reference
(d) Destruction

• The loop that never ends is called:
  

(a) Infinite loop 
(b) Reunning loop
(c) Nested loop  
(d) Continuous loop

• Which mode opens only an existing file for both reading and writing?
  

(a) "w"               
(b) “w++”
(c) "r+"             
(d) "a+"

• Which symbol is used to denote a preprocessor statement?
  

(a) %                    
(b) #
(c) $                    
(d) @

OR VISUAL BASIC

• In Visual Basic a form is another name for:
  

(a) Object         
(b) Windows
(c) Property         
(d) Label

• A loop within other loop is called:
  

(a) Complex loop
(b) Nested loop
(c) Outer loop      
(d) Inner loop

• How many conditions are required to write an If-Else statement?

(a) One               
(b) Two
(c) Three           
(d) Four          

• Single execution of a loop is called:       
  

(a) Cycle             
(b) Iteration
(c) Test                 
(d) Duration                            

• The statement that forces the declaration of all variables is:
  

(a) Statics          
(b) Option explicit
(c) Re-dim      
(d) Dim

• The set of rules for writing a program in any programming language is called:

(a) Syntax           
(b) Bug
(c) Error             
(d) Debug

• Which variable is used to access an actual object in Visual Basic?

(a) Variant         
(b) Object
(c) Actual object 
(d) Constant

• All arc valid criteria in select case statement except:

(a) Case 100       
(b) Case > 50
(c) Case 40 to 50
(d) Case 40, 50, 60, 70

• Methods characterize an object's:

(a) Appearance    
(b) Value
(c) Style             
(d) Behavior

Time 2:10 Hours
(Subjective)
Marks: 60

SECTION - I
MS-ACCESS

2. Write short answer of any Six Parts. 12

• Define data redundancy.
• List some important purposes of query language.
• Who is end user'
• State the purpose of index file.
  
• Which activities are involved in data analysis?
  
• What is meant by synonym?
  
• How is a query written?
  
• Define the term degree of a relation.
  
• Which two database objects can be used to create a report?
  

C-LANGUAGE

3. Write short answer of any Six Parts. 12

• What is object code?
• Name the types of pre-processor directives.
  
• Define compiler.
  
• Why are comments used in C?
  
• Define variables in C.
  
• Write two rules for naming a variable in C.
  
• What is stdio. h?
  
• What will be the output of following code?
  int a = 9 ;
  a = a % 4 ;
  print( \ n % d is Result " , a);
  
• Trace errors in the following code:
  S- include ( stdio.h )
  void main ( )
  {
  float n ;
  scanf (" % d " , & n) ;
  Printf ("The Number is % r . n) ;
  }

OR
VISUAL BASIC

3. Write short answer of any Six Parts.

• Define select-case structure.
  
• What is macro?   
  
• Explain print method. '
  
• Write any to methods of form.
  
• What  is meant by "option explicit"?
  
• What  do mean  you  mean by IDE?
  
• Define timer control.
  
• Which control is used to connect with database?
  

C-LANGUAGE

4. Write short answer of any Six Parts. 12

• What is meant by switch statement?
• What is if-else structure?
• Trace out the errors in the following code:
• #include < stdio. h >
  # include < conio. h>
  void main ( )
  if (16 7 10) then
  printf (" % C "," Pakistan") ;
  getch ( ) ;
  }
• Define go to statement
  
• Define sentinel loop.
  
• Trace the output of the following:
  int n;
  for (n = 10 ; n < = 15 , n ++)
  printf (“% d \ n ", ++fn) ;
• Differentiate between local and global variables.
• What is meant by function definition?
• How data is stored in binary files?

OR VISUAL BASIC

4. Write short answer of any Six Parts.  12

• Define operator precedence.
  
• Explain data control.
  
• Differentiate between bounded and unbounded controls.
  
• How a grid control is attached with database?
  
• Explain standard code module.
  
• Explain OLE control.
  
• What is text stream object?
  
• Define two dimentional array.
  
• Explain gets ( ) function.
  

SECTION-II

Attempt any One question carries 08 marks.

MS-ACCESS

5. Define data processing. What activities are involved in data processing? Discuss in detail.

6. What is query? Discuss its uses and advantages.

SECTION-III

Attempt any TWO (2) questions front C . Language or Visual Basic. Every question Carries 08 marks.

(C- LANGUAGE)

7. Write a note on real data types in C-Language.

8. Write a program that input a number and check whether itis positive negative or zero.

9. Can we use if and goto statement to construct a loop structure? If yes, then how? Explain with example.

OR VISUAL BASIC

7. What is an IDE? Write in detail components of IDE.

8. Write a program that input a number and check whether it is positive, negative or zero.

9. Use goto statement with labels and its structure to create a loop structure. Explain with example.