Computer Science
Paper II
Objective Type
Time Allowed: 20 Minutes
Maximum Marks: 15
Inter(Part- II)
Important Instruction Objective Paper consists of two parts i.e MS-Access &  C-Language and MS • Access & V.B. The candidates are Required to attempt any one part . Over .writing. cutting., using of lead pencil is not allowed.
Note . Write answers to the questions on the objective answer sheet Provided FOAM. Foour possible answers A,B , C, D to each question are given. Which answer is correct, fill the relevant circle with pen ink to each question on the answer sheet provided.

MS-Access  & C-Language

• Which of the following keys does not hold uniqueness properly

(A) Secondary Key
(B) Foreign Key                              
(C) Primary Key      
(I)) Candidate Key

• Which o he following may be a temporary File ;
  

(A) Back up File
(B) Master File
(C) Transaction file
(D) None of these

• In relation database a table is also called a :
  

(A) File   
(B) Scheme 
(C) Tuple  
(D) Relation

• Insert command is used to insert
  

(A) A new table 
(B) A view 
(C) A new record
(D) Dependencies

• Function getche ( ) is defined in:
  

(A) stdio .h       
(B) conio.h          
(C) string.h                
(D) math.h

• A database consists of various components called the.
  

(A)Tool         
(B) Properties     
(C) Entities                 
(D) Objects

• A data in a table is entered in :
  

(A) Layout view     
(B) Normal view         
(C) Datasheet view          
(D) Design view

• The step procedure to solve a problem is called:
  

(A) Program   
(B) Programming Language 
(C) Flow Chart   
(D) Algorithm

• Methods to characterize an objects:
  

(A) Value       
(B) Behavior        
(C) Appearance
(D) Identifier

• Visual Basic is a:
  

(A) Both  B and C 
(B) Back End  
(C) Front End  
(D) None of these

• Variables and constant names can not contain a :
  

(A) Period     
(B) Underscore    
(C) Number     
(D) Letter

• A loop within a loop is called:
  

(A)Complex Loop    
(B)  Nested Loop  
(C) Outer Loop  
(D) Inner Loop

• In Visual Basic which statement indicates the end of decision structure :
  

(A) End   
(B) End if   
(C) Next     
(D) Else

• The key word that makes the end of a do structure is :
  

(A)Exit Do 
(B) End Do  
(C) End while     
(D) Loop

• All of the given are relational operator except
  

(A) < >      
(B) <=              
(C) >=     
(D) =

 Note: Computer  to answer (06) parts each from question Q. No 2,3 and  4 while attempt any three questions from Part II. Write same question number and its part number as given in the question paper.

Section –I
MS-Access & C-Language

Q.2.

• Differentiate between Data and information.
  
• List different activities in data processing.
  
• Define Normalization.
  
• Distinguish between primary key and foreign key
  
• Define an entity or object with examples
  
• Define Homonym.
  
• Define the term R.D.B.M.S.
  
• Write any two advantage of form.
  
• Describe field property.
  

Q.3

• What is conditional operator?
  
• Differentiate between if …. Else and switch statement
  
• Find Error:
  Int a:
  Printf ( “ enter any number “):
  Scanf (“% C” &f)
  Printf (“number =” , n)
  
• Trace the output:
  int i, j :
  for (i= 1; i < > j ;j++)
  {
  For (j = 1 :j < = I ; j++)
  Print  (“*” );
  Printf (“\n”);
  }
  
• Define Loop.
  
• Write general form or syntax of Do……. While loop.
  
• What is sentinel value?
  
• What is a function call?
  
• Differentiate between text stream and binary stream.
  

Q.4.

• What is the use of include Directive?
  
• What is syntax error? Define with example.
  
• What is meant by Machine independence?
  
• Define standard identifier with example.
  
• What is meant by variable declaration?
  
• How does overflow occur? Give example.
  
• Differentiate between getch ( ) and getche ( )?
  
• Trace out the errors in following code:
  #include < stdio.h>
  #include < conio.h>
  Void main ( ):
  {
  Printf (“% S”, Pak);
  Getch ( );
  }
  
• What is the output of the following:
  #include < stdio.h>
  #include < conio.h>
  void main ( ):
  {
  char Ch1= ’A’ , Ch2= ‘B’ , Ch3 = ‘C’;  
  prinf (“Ch2 \n % c \n Ch1, “ , ch3);
  getch ( );
  }

MS-ACCESS & VISUAL BASIC

Q.2

• Differentiate between Data and information.
  
• List different activities in data processing.
  
• Define Normalization.
  
• Distinguish between primary key and foreign key
  
• Define an entity or object with examples
  
• Define Homonym.
  
• Define the term R.D.B.M.S.
  
• Write any two advantage of form.
  
• Describe field property.
  

Q.3

• Why S.Q.L is used?
  
• What is variable?
  
• Define M.D.I form ?
  
• How Startup form is set?
  
• Differentiate between combo box and list control.
  
• Why caption property is used?
  
• Explain radio button
  
• Why Dim Keyword is used?
  
• Define modular programming?
  

Q.4

• Define key words?
  
• Write any to rules for naming variable
  
• What is meant by initiliazing variables.
  
• What is condition.
  
• Differentiate between if ….. Else and select case structure .
  
• Define Loop?
  
• Write general form of select case structure .
  
• What is iteration?
  
• Differentiate between a Do While and Do Until Loop?

Note: Attempt any one of the following question .                                    

Q.5.  Describe different types of Keys used in Databases.  (8)

Q.6. Explain different data types available in MS –Access. (8)

Section –III C-Language

Note: Attempt any two of the following question Either form C-Language or Visual Basic

Q.7 Define and explain “Scanf function “ with example.(8)

Q.8. Write a program in C-Language that inputs a character from user and determines whether it is a vowel or consonant?    (8)

Q.9. What is for loop? Explain in detail, also give example.  (8)

Visual Basic

Q.7. Define and explain “ input box” with examples.    (8)

Q.8. Write a program in Visual Basic that inputs a character from user and determines whether it is a vowel or consonant?     (8)

Q.9. Explain for ………. Next Loop in detail. Also give an example .  (8)