Computer science
(objective)
New scheme
paper(III)
Time allowed :20 mintes
Paper code 8831
Maximum marks:17

Note: You have four choices for each objectivc type qustion as A B, C and D. The choice which you  think. Is correct ; fill that cricle in front of that questine number. Use  marker or pen to fill the circles, Cutting or filling two or more circles.  will reslt in zero mark in that question. Write PAPER CODE, which la printed  on this qustion paper, on the both side of the answer  Sheet and fill bubbles accordingly, otherwise the student will be responsible for the situation. use of Ink remover or white correcting fluid is not  allowed..

Q. 1

(MS.ACCESS)

• Which of the following data rnodel is more flexible?

(A) Network data model  
(B) Hierarchical model
(C) Data relational model
(D) Object data

• A table must have

(A) Primary key         
(B) Secondary key
(C) Cornposit key       
(D) Sort key

• Create command is used to create.

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

• Data base development process involves mapping of conceptual data model into

(A) Object oriented  data model
(B) Network data       
(C) Implementation model.    
(D) Hierarchical model

• Different attributes in two different  tables having  name are refered to as

(A) Synonym 
(B) Homonym
(C) Acronym  
(D) Mutually exclusive

• To find a four characters name that starts  with H the criteria is .specified as

(A) H* 4
(B) H?4      
(C) H???         
(D) H###

• How many are basic layouts of forms in MS-Access?

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

C-Language

• Which of the following requires no translate to execute the program

(A) C                                 
(B) C++            
(C) Machine language    
(D) Assembly language

• An assembly language uses

(A) English word                     
(B) OS and IS
(C) Mnemonic codes                      
(D) Binary code

• a+b is equivalent to

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

• Which of the following operator is to assign a value to a variable?

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

• Which of the following format specifier is used for character data type

(A) % S                    
(B) % C   
(C) % F         
(D) % D

• When relation expression is false, it has the value

(A) One                   
(B) Zero
(C) Less than 0      
(D) Two

• The ASCII code for escape key is

(A) 27
(B) 28 
(C) 29
(D) 30

• Use--- To declare variable in VB

(A) Dim     
(B) Dimm
(C) Sub
(D) Event

• Condition operator is an alternative of

(A) if                          
(B) if--else
(C) nested if                 
(D) nested of else

• An expression consists of

(A) Operators               
(B) Both A & B  
(C) Operand                   
(D) None

• Relation operators allows you to-number

(A) Add    
(B) Compare
(C) Divide   
(D) Multiply

• To display a massage-function is used

(A) Input box          
(B) Message box
(C) Message           
(D) Multiply

• In a for statement this expression is executed only once

(A) Test                                
(B) Validation
(C) Initialization                  
(D) None

• All the following are logical operators except

(A) or                         
(B) and                    
(C) <             
(D) not

• What is the final value of x executing the following code for(int x=0;x<10;x++)

(A) 10                     
(B) 9                   
(C) 0                      
(D) 1

• Which method is used to locate an item

(A) Selected                       
(B) Set selected
(C) Index                      
(D) Set index

• The scope of variable refers to its

(A) Length                       
(B) Name
(C) Accessibility               
(D) Data type

• How widely a variable is recognized to procedures in the object refers its
  

(A) Life time              
(B) Duration
(C) Scope                     
(D) Execution

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

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

• The loop which never ends is called
  

(A) Running loop              
(B) Infinite loop
(C) Continuous loop         
(D) A and B

1214 (Inter Part--II)
(Session N12-2014)
Computer Science
(Subjective)
New Scheme
Paper (II)
Maximum Marks:83
Time allowed: 3.10 hours

SECTION – I 

2. Answer briefly any Eight parts from the followings:- (MS — ACCESS )  (8x 2 =16)

• What is meant by reproduction?
• What is master file?
• Define file organization
• What is primary key?
• Differentiate between parent table and child table.
• Who is an end user?
• Define Modality
• What is normalization?
• Define a fornix
• How is query designed in Access?
• Who is OLE object in MS - Access?
• What is a sub-Form?

3. Answer briefly any Eight pa rte from the following (C - Language)  (8 x 2 =16)

• Define low level language
  
• What are preprocessor directives?
  
• Differentiate between linking and loading
  
• What is the use of OR operator?
  
• Define single tine comment in C.
  
• Write the given statement in C language 2as=V_f²-V_i²
  
• Trace the error
  # includescstdio.h)
  Main c )
  {
  Print c”helloworld”)
  }
  
• Compare getch( ) and getche( ) functions  
  
• State the purpose of %,C format specifier
  
• What is the use of field width specifier    
  
• Trace the output
  int i = 0;
  print f("%3d",i);
• Trace the out put
  float f-=3.14159;
  print f ("f=%4.2f” ,f);

3, Answer briefly any Eight parts   (Visual Basic)  (8 x 2 =16)

• Why Assembly language is called symbolic language.
• Define an Algorithm
• What is VBA
• What is to cant by variable Length string.
• What is the purpose of Val function.
• Why do we use input box.
• What are the parameters of message box
• Write the syntax of ease statement
• Which case option is used to test the range of values.
• Give the syntax of multiple if statements
• Differentiate between selection and repetition.

4.Answer  briefly any Six  parts from the following          (C - Language) (6x2=12)

• Define Control structure.
• Trace  the output
  void main()(
  int p.,,q„r;     p=10;     q=3;   r=-2;
  if ((p±q) < 14&& (r< q -3))
  printf("%d",r);   
  else
  print f( " %d” , P)        ;
  getch( );}
• Why break statement is used in switch ( ) structure.
• Trace the error
  void main ( ) {
  int a b    a=-10 b= 40
  if (a<0);           b=sqrt  (a);
  printf( " Result=%f; b);          
  getch ( )  ;}
• Define nested 1oop
• Trace the output
  void main( ) {
  in a, b; for (a=1O ;9<30;a++)
  b=++a;
  print f (“%d/n”,b);}
  get ch ( )  ;}
• What is a function call
• What is the use of actual parameter?
• Define stream

OR
Visual Basic

4. Answer briefly any six part from the followings:   (6 x2 =12)

• What is Compiler?
• What are control statement
•  What is loop? Write its two uses.
• Write two types of sub programs
• What is modular programming
• plain the difference been variable and constant
•  loop at is selection structure
• define explicate declaration of variable
• What is nested loop?

SECTION —II

Note: Attempt any ONE in MS-ACCESS. (8x1=8)
5. Describe different steps involved in designing a data base with the help of diagram
6. What is relationship? Write procedure to define relationship between two tables in Access.

SECTION------III

Attempt any two question either from “C-Language OR from "Visual Basic”. (8x 2=16)

7. (a) Describe language processors and their use discusses different types of language processors.
(b) Explain different types of constant in Visual basic.

8. (a) Write program which inputs two numbers and tells whether these number are equal or not equal.
(b) Write a program in visual basic which inputs three numbers from user and tells minimum number from these numbers.

9. (a) Explain the working of for loop with syntax and flow chart.
(b) What is meant by pretest and post test loop explain example

Section-----IV     
(Practical part)

Attempt any three parts. (5X3=15)

• Describe the procedure for replacing data
• Explain the procedure to add new record through forms.
• Write a program that display a massage and value of integer in C OR using visual basic.
• Write a program that display product of all odd numbers from 1 to 10 using for loop OR using for next loop in visual basic.
• Write a program that inputs two numbers in main function passes these numbers to a function the function display the maximum number in C language or in visual basic