CBSE Class 12 Informatics Practices Sample Paper 2014 Set 06

Q1. Answer the following questions on the basis of Ms-Access: 

1) What do you mean by Data Redundancy? How Ms-Access help to reduce it? 

2) What is Foreign key? Explain by taking an example. 

3) What is the difference in number and currency format? 

4) Explain One to Many relationship by taking an example. 

5) What is the extension of Microsoft Access database file? 

6) Suggest the data types for the following Teacher Table: 

T_Code - Teacher’s Code generated Automatically

T_Name - Teacher’s Name

DOB - Date of Birth

Basic_Sal - Basic Salary

Qualification -Qualification of a teacher (List should appear like- M.A., B.A, ….)

Photo -Photograph of a teacher

Bio-Data -Ms-Word file.

Blog -Teacher’s Blog on Internet

Q2. Answer the following questions on the basis of ASP: 

1) What is ASP? How it is different from HTML? 

2) What is the difference in PWS and IIS? 

3) What is the difference in Byte and Integer data type? 

4) Explain EQV and IMP operators. 

5) Name any two ASP Components. 

6) Name any two Objects in ASP. 

7) Name objects required to manage database through ASP. 

8) Write any two Server Variables. 

9) What is the full form of ODBC? 

10) What is the use of Response.Redirect? 

Q3. Answer the following questions on the basis of ASP: 

1) Give the output: 

a) Response.Write(Round(234.543,2))

b) Response.Write(ASC(“A”)

c) Response.Write(SQR(25))

d) Response.Write(Len(LTRIM(“###Hello”))) # stands for space

2) Change the following script using FOR…NEXT without affecting the output: 

<% DIM A(5), C

C=1

DO UNTIL C>5

A(C) =C*C

C=C+2

LOOP 

Please refer to attached file for CBSE Class 12 Informatics Practices Sample Paper 2014 Set F