(INTERMEDIATE-PART-II)
Computer Science (New Scheme)
Time:20 Minutes
Paper: II
Objective
Code: 8835
Marks:17

NOTE: You have four choices for each type of question as A , B , C and D. The choice which you think is correct, fill that circle in front of that question with marker or ink pen. Cutting or filling two or more circles will result in zero mark in that question.
(MS-ACCESS)

Q.1

• A collection of raw facts and figures is called:
  

(A) Data                       
(B) Information        
(C) Processing            
(D) None

• The output of a query is in the form of a:
  

(A) Table                    
(B) Form                    
(C) Report                  
(D) Query

• Which of the following key does not hold uniqueness property?
  

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

• In 3NF, which form of dependency is removed?
  

(A) Functional           
(B) Non-functional     
(C) Associative          
(D) Transitive

• The data in table is entered in:
  

(A) Design View        
(B) Normal Vies         
(C) Data Sheet View 
(D) Layout View

• Forms are designed for:
  

(A) Input Data                       
(B) Manipulate Data  
(C) Accepting change
(D) All of These

• Insert command is used to insert:
  

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

C-Language  OR     Visual Basic
(C-language)

• Another term for a computer making a decision is:
  

(A) Sequential            
(B) Selection              
(C) Repetition            
(D) iteration

• The escape sequence for back slash is:
  

(A) \                            
(B) \b                          
(C) \\                           
(D) \t

• Which of the following is equivalent to (p>=q)?
  

(A) p<q                      
(B) !(p<q)                   
(C) p>q                       
(D) !(p>q)

• The function getche() is defined in:
  

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

• The symbol “=” represents:
  

(A) Comparison operator                                                       
(B) Equal to operator
(C) Assignment operator                                                        
(D) None of These

• Which of the following mode open only an existing file for both reading and writing?
  

(A) “W”                     
(B) “W+”                   
(C) “r+”                      
(D) “a+”

• Global variables are created in:
  

(A) RAM                   
(B) ROM                    
(C) Hard Disk            
(D) Cache

• How many types of loops structure are available in C?
  

(A) 4                           
(B) 3                           
(C) 2                           
(D) 6

• One execution of a loop is known as a(n):
  

(A) Cycle                   
(B) Duration               
(C) Iteration               
(D) Test

• Which programming structure makes a comparison?
  

(A) Relation               
(B) Decision               
(C) Sequence              
(D) Repetition

OR
(Visual Basic)

• Which of the following is comparison operator in visual basic?
  

(A) AND                    
(B) <=                        
(C) OR                                   
(D) NOT

• Which of the following is related to loop structure?
  

(A) Object                  
(B) Classes                 
(C) Condition             
(D) All of These

• Which of the following is not a loop structure?
  

(A) for-next                
(B) select case            
(C) while-wend          
(D) do-while loop

• Which of the following is the advantage of function?
  

(A) Easy to write program                                                     
(B) Bitmap graphics
(C) Scale width                                                                      
(D) Scale mode

• A data file is stored on the:
  

(A) RAM                   
(B) Disk                     
(C) ROM                    
(D) None of These

• A variable represents:
  

(A) A piece of data                                                                
(B) The name of keyword
(C) A memory location                                                          
(D) None of These

• In visual basic, long data type takes:
  

(A) 4 bytes                 
(B) 2 bytes                 
(C) 8 bytes                 
(D) None of These

• In the visual basic, the text box and input box are used for:
  

(A) Output                 
(B) Input                    
(C) Both A & B         
(D) None of These

• Which of the following is not a logical operator?
  

(A) XOR                    
(B) NAND                 
(C)   EQV                  
(D) NOT

(INTERMEDIATE-PART-II)
Computer Science (New Scheme)
Time:20 Minutes
Paper: II
Objective
Code: 8835
Marks:17

NOTE: Either from “MS-Access & C-Language” or from “MS-Access & Visual Basic”

SECTION-I
(MS-ACCESS)

2. Write short answer any Eight (8) questions: (2x8=16)

• Name different types of file organization.
  
• Describe consistency constraints.
  
• State the use of query language.
  
• List different types of keys.
  
• What is the purpose of using views?
  
• Differentiate between primary key and secondary key.
  
• What is meant by data modeling?
  
• Describe partial dependency.
  
• How does a database differ from a table?
  
• What is the roll of query in database?
  
• What is the concept of cardinality of a relation?
  
• Describe sub-form

C-Language

3. Write short answers to any EIGHT (8) questions: (2x8=16)

• Write two characteristics of C-language.
  
• Define linking
  
• What is header file?
  
• What is compound assignment operator?
  
• Define increment decrement operator.
  
• What is the use of AND operator?
  
• Trace the error in the following code
  #include<stdio.h>
  Void main(viod)
  Print(“Hellow world”)
  
• Define the format specifier used in printf() and scanf() function.
  
• Trace the output:
  #include<stdio.h>
  void main(viod){
  int x=10;
  printf(“%d”,x%2);}
  
• Trace the output:
  #include<stdio.h>
  void main(viod){
  int x=1;
  int y=2;
  x=x+1;
  y=y+x;
  printf(“%d \n %d”,x, y);
  }
  
• What is the use of getch() function?
  
• Trace the errors in the following code:
  #include<stdio.h>
  Void main(viod)
  {
  int x=4;
  y= x+10;
  printf(“%d”,x+y);
  }

(Visual Basic)

3. Write short answers to any EIGHT (8) questions:  (2x8=16)

• What is object code?
  
• What is an event procedure?
  
• What is a form?
  
• How to declare an array?
  
• What is a visible property of label control?
  
• Define IDE.
  
• Write syntax of do-while loop.
  
• Write two properties of a form.
  
• What is difference between method and property?
  
• What is difference between gotfocus and lost focus events.
  
• What is nested loop?
  
• What is use of select case statement?

C-Language

4. Write short answers to any six (6) questions : (6x2=12)

• Write syntax of conditional structure.
  
• Write syntax of if-else statement.
  
• Trace the errors in the following code:
  #include<stdio.h>
  Void main();
  {
  If(16<18) then
  Printf(“%c”,Ok);
  getch();
  }
  
• What is the output of the following code:
  int m, n;
  m=0;
  n=m;
  if(m==n)
  printf ( “BWP”);
  else
  prinf (“LHR”);
  
• Define goto statement.
  
• Define nested loop.
  
• What is life time of local variable?
  
• List some benefits of using function.
  
• What is binary stream?

OR
(Visual Basic)

4. Write shoat answers to any six (6) questions :   (6x2=12)

• What is variable?
  
• State literal constant.
  
• What is the purpose of VAL function?
  
• What is difference between counter and conditional loop?
  
• What is wrong with the following code.
  If a=5
  b=3
  end if
  
• Define control array.
  
• What do you mean by UBOUND function?
  
• Define frame.
  
• What are intrinsic controls?

SELECTION-II
(MS-ACCESS)

Note: Attempt any one question.

5. What is an ER Diagram? Give an example of ER Diagram. 8
6. What is MS Access? Write in detail Data Types Used in MS Access. 8

 Note: Attempt any TWO questions.

7. While writing a C program, how many types of errors can occur? Discuss briefly. 8
8. Write a program in C that inputs a number by the user and checks whether it is even or odd.   8
9. What is sentinel controlled loop and how it implemented? Discuss some of the situations where it can be useful? 8

OR
(Visual Basic)

SECTION-III
(Practical Part)

• Explain the procedure to extract date from multiple tables.
• Explain the procedure to create form using wizard.
• Write a program that inputs four numbers and compute their sum and average in C language or Visual Basic.
• Write a program to input three numbers and finds maximum number in C language or Visual Basic.
• Write a program to display first ten integer numbers in ascending order in C language or Visual Basic.