Blue Print of Half Yearly Informatices Practices XII

DATABASE CONCEPTS

1.	What is a database ?
Ans :	A database may be defined as a collection of interrelated data stored together to serve multiple applications.
2.	What is the Database Management System ?
Ans :	A DBMS refers to a software that is responsible for storing, maintaining and utilizing databases. A database along with a DBMS is referred to as a database system.
3	What is the purpose of a Database
Ans :	The following purpose of Database Management System are defined below a. Database reduce the data redundancy to a large extent b. Database can control data inconsistency to a large extent c. database facilitate sharing of data d. database enforce standards. e. database can ensure data security
4.	What is ACID property
Ans.	1. Atomicety 2. Consistency 3. Isolation / Integrity 4. Durability

5. What is data Redundancy

Ans: means , duplication of data e.g. the name of the student is in both the attendance register and the guard file even though the attendance register is having the name for all the months.

6. What is data Security

Ans : Unauthorized Access and Unauthorized Use. It is the protection of data against accidental or intentional disclosure to unauthorized person or unauthorized modification or destruction. it is related to privacy of data.

7.   What is database abstraction.

Ans : It is the concept development of database system 

8. What are the various levels of database Implementation.

Ans : 1. Internal Level (Physical Level)

          2. Conceptual Level 

          3. External Level (View Level)

9. What is Physical Level 

Ans : Physical Level of DBMS means internal level or hardware where the data is saved.

10. What is Conceptual Level

Ans : In this level the concept or keys of the data are implemented.

11. What is External Level 

Ans. It is the View Level , here the viewer sees the data as and when needed.

CLASS XI (IP & CS) SYLLABUS DETAILS SESSION 2018

WELCOME TO THE STUDENTS OF CLASS XI NEW SESSION 2018-19

• The Old Book for Python

Go Here

• Syllabus for Class XI Computer Science

• Syllabus for Class XI Informatices Practices

Marking Scheme XI IP 2017

Ans 1. (a) Java Bite Code / Object Program   -       -  correct answer 1 Mark

Source Code -> Compiler-> Object Program -> Linker -> Java Byte Code

Ans 1.(b)PARAM and PACE  and Anurag  ½  mark for any two correct names.

1. Very Fast in Computing

2. Very Big Memory Size.

Ans 1(c)  Firewall is a system (Hardware & Software) to safeguard or protect the system from unauthorized access (Hacking / Phishing)

2   marks  for definition.

Ans1.(e) Types of Errors 

    Compile Time Error- Occurs during compile time. When a program compiles it sources code is checked for 

rules of programming language. 

    Its types are:- 

         1. Syntax error : it occurs when a grammatical rule of Java is violated 

         2. Semantic error: it occurs when statement are not meaningful. 

Run Time Error: Occurs during the execution of the program.
Logical Error: Occurs due to wrong logic of a program. 

2 marks for explaining all errors.

Ans 1. (f)

Bar Code Reader	Smart Card Reader
1. This device is used to read barcode strip printed in any product/item.	1. This device is used to access/read electronic chip on the smart card.
2. It translates optical impulses into electrical signals.	2. It consists microprocessor and none-volatile memory to store and process the digital data.

   

There may be any two points difference.    Each point 1 x 2 =2 Mark

Ans 2 (a) ComboBox -   01 Mark

Because it is more suitable for it. It can hold all the values within confined space.

Ans 2. (b) jCheckbox. / JList                          1 mark for correct answer.

Ans 2. (c) The Java programs need to be written just once, which can be run on different platforms without making changes in theJava program. Only the Java interpreter is changed depending upon the platform.This characteristic is known as Write Once Run Anywhere.

(2 marks for complete answer)

)Ans2.(d)Spyware is a type of malware (malicious software) installed on computers that collects information about users without their knowledge. The presence of spyware is typically hidden from the user and can be difficult to detect. Some spyware, such as keyloggers, may be installed by the owner of a shared,corporate, or public computer intentionally in order to monitor users. 

Malware: 

Short for "malicious software," Malware refers to software programs designed to damage or do other unwanted actions on a computer system. 

1 mark for each threat details.

Ans 2. (e)StringAns=( (x%2==0) ? ”even”: “odd”)

2 mark for correct answer

Ans 2(f) 1 mark for def and 2 for recycle and recovery process.

Ans3.(i)     Primary Key :  It is the column or set of columns which can uniquely identify each tuples(rows) of  the relation(table).

Alternate Key : It is column or set of columns which is not used for uniqueness of the tuples. It is the candiadate key which has selected as primary key purpose.

       Table ADMISSION ( ADMNO,ROLLNO,STNAME,CLASS,SECTION,DOADM,ADRR,DOB)

ADMNO – is the primary key 

ROLLNO – is the alternate key(it may have duplicate class values )

         Each correct definition ½x 2 = 1 Mark and Examples ½ x 2 = 1 Mark

Ans.3(ii)Phishing : Phishing is attempting to acquire information (and sometimes, indirectly, money) such as usernames, passwords, and credit card details by masquerading as a trustworthy entity in an electronic Communication.

            2  mark for correct   definition

Ans3. (iii) 2 marks for correct answer.

Ans3.(iv) Degree of a relation is the total number of columns in the table and cardinality is the total number of rows in the table.

1 mark for each correct answer

Ans3.(v) 2 marks for correct answer

Ans 4. (a) jTextField1 -  25 marks for correct answer

Ans 4(b)corrected code

            int Total=0 ,Jump=5;

int I;

for( I=0;I<=5;i++)

{

   Jump +=5;

Total  = Jump;

}

jTextArea.setText( “”+Total);Each correct errors ½ Mark x 4 = 2 Marks

Ans 4. (c) X = 50   Y = 48                  correct answer- 2 Marks ,  Partial Answer- 1 Mark

Ans 4. (d)intItemCode;

String Product;

if ( ItemCode == 1001 )

Product=”Vegetables& Fruits”;

else if( ItemCode==2002 )

Product=” Bakery Items”;

else if( ItemCode==3003)

Product=” Cereals”;

else if( ItemCode==4004)

             Product=”Juice & Soft Drinks”;

else if( ItemCode==5005)

             Product=”Cosmetics”;

else

JOption.showMessageDialog(null,”Select an appropriate ItemCode”);

 Correct Answer  2 Mark , Partial answer – 1 Mark

Ans 5   i is 11 and n is 0.

½  mark for each.

Ans6Float costp = Float.parseFloat( jTextField1.getText() ) ;   ½  Mark for each statement

           Integer Nop= Integer.parseInteger(jTextield2.getText() );

           Float TotAmt = costp * Nop ;

           Float STax = TotAmt * (20 /100)  or 0.2;            1 Mark for each statement

jTextField3.setText(“” + TotAmt);

jTextField4.setText(“” + STax);         ½  Mark for each statement

Ans7  (1)BillnoTF.setText(“”);

NameTF.setText(“”);

PriceTF.setText(“”);

DiscTF.setText(“”);

FinalTF.setText(“”)

MensRB.setSelected(TRUE);

               Each correct statement ½ Mark

Ans 7 (2) Code for Exit button                                    ½ Mark

System.exit(0); 

               To Make the TextFieldsDiscTF and FinalTFuneditable

DiscTF.setEditable(FALSE);

FinalTF.setEditable(FALSE);                   for two statements ½ Mark

Ans 7 (3) For calculation of the Discount  and Final price , consider only price value to be entered.

Float Price= Float.parseFloat(PriceTF.getText() );

                   Float DiscAmt,FinalAmt

if ( MensRB.isSelected( ) )

                     {     if ( Price <1000)

{  DiscAmt = Price * 0.3;   or   Price * (30/100) ; }

else

                            {   DiscAmt = Price * 0.5;   or   Price * (50/100) ; }

                     }

if(WomensRB.isSelected() )

 {     if ( Price <1500)                                                                                                                                                      

{  DiscAmt = Price * 0.4;   or   Price * (40/100) ; }

else

                            {   DiscAmt = Price * 0.5;   or   Price * (50/100) ; }

                    }

if(KidsRB.isSelected() )

 {     if ( Price <500)                                                                                                                                                        

{  DiscAmt = Price * 0.2;   or   Price * (20/100) ; }

else

                            {   DiscAmt = Price * 0.3;   or   Price * (30/100) ; }

                   }

if(MemberCB.isSelected( ) )

                 {

DiscAmt = DiscAmt + (0.05 * Price );

                 }

FinalAmt = Price – DiscAmt ;

DiscTF.setText(“” + DiscAmt);

FinaTF.setText(“”+ FinalAmt);

               1 – Mark for correct use of if statement for selecting category

1 – Mark for correct use of if statement checking percent and discount amount

               ½ Mark calculate Final amount .½ Mark to display these two values in TextFields.

Ans 8(a) KVS              RAIPUR

            REGION          2017

1 mark for TAB and 1 for NEWLINE.

Ans 8(b)           import javax.swing.JOptionPane;

                        Joptionpane.showMessageDialog(null,”DIGITAL INDIA”);

1 mark for each line

Ans 8 (c)int age;

            String txt = agetf.gettext();

age = integer.parseint (txt);

if (age <18)

msglbl.setText(“you are not eligible to vote”);

else

msglbl.setText(“you are eligible to vote”);

1 mark for correct logic, 1 for var declaration and parse, 1 forcorrect if else structure.

Ans 8 (d)int  a;

            for ( a= 1; a<=20; a++)

{ if(a%2==0)

            System.out.println(a);

}

1/2 mark for each statement.

           

Ans 8 (e) for (i=1; i<=10; i++)

                        System.out.println( i);

                                   

            1 mark for for structure and 1 mark for println statement

Ans 9(a) comments provide explanatory notes to the readers of the program.

indentation makes the program more readable and presentable.

1 mark for each explanation.

Ans 9(b) 2 marks for correct difference .

Ans9(c)the steps are:-

1.      understand the problem well.

2.      analyse the problem.

3.      design the program by deciding step by step solution in simple steps.

4.      code the program.

5.      tset and debug the program.

6.      complete the documentation.

7.      maintain your program.

2 marks for correct answer.

Ans 9. (d) 1 Text Box

2 Option Button

3 Combo Box

4 Command Button

½ mark each for each correct control name.

CLASS XI I P Flow of Control & Importance Topics

Conditional Flow of Control 

            1    When is if else more advantageous then switch case. 

            2.    Write a java code to find if the given year is a leap year (input in 4 digits)
            3.   What is the use of break statement.
            4.   What is the free flow construct.
            5.   What is a jump statement ? explain the three jump statements ?
            6.   What is the output of the following code if a =3, a=5
                    switch (a)
                     {
                        case 1:
                           System.out.println("One");
                        break;
                        case 2:
                           System.out.println("Two");

                        break;
                        case 3:
                           System.out.println("Three");

                        break;
                        case 4:
                           System.out.println("Four");

                        break;
                        case 5:
                           System.out.println("Five");

                        break;
                        case 6:
                           System.out.println("Six");

                        
                        case 7:
                           System.out.println("Seven");

                        break;
                        default:

                            System.out.println("Error");
                        break                    }
            7    Rewrite the following code using conditional operator. (_?_:_)

                        if(Total>=50)

                                        Show=’Y’;

                        else

                                         Show=’N’;

Iterative Flow of Control

1.      Loop to print the sum of following series

1+1/4+1/7+1/10+1/13+1/16+1/19+1/22+1/25

2.      Loop to print the factorial of a given number

3.      Loop to display 10 star in a row

4.      What is the use of Continue statement

5.   What is the difference between do while and while loop.

6.   Write the code to print the natural numbers between 10 to 100 

7.    Write the code to print the odd numbers between 10 to 100

8.    Write the code to print the even numbers between 10 to 100
9.   Give the output of the following code
      int m =100;
      while(m>0)
      {
             if(m<10)
                  break;
             m=m-10;
       }
       System.out.println("m is "+m);
10.  What is the meaning of infinite loop
11.  What is a nested looping
12.  

13.   Identify the invalid names out of the following. State the reasons if invalid

(i)                  do

(ii)                des_01

(iii)               item

(iv)         _product

   Java Swing Controls

                  1.  How many types of java swing controls are there in java

                  2.  What is a container control

                  3.  What is the difference between jCombo and jList

                  4.  What is the difference between jText and jPassword

                  5.  How many types of operators are there in java
                  6   User want to display the jTextField1 with 10% more value of amount in float type
                  7

                  

Post Fix Questions

1. Post Fix Output

       

                  10,40,+,8,2,+,*,10,-

                   

                  45,45,+,32,20,10,/,-,*

                 

                  30,5,2,^,12,6,/,+,-,3

                  20,40,+,30,20,-,*,2,/

                  True, False , AND , True, True , NOT , OR , AND

XII CS HOME WORK

Please open the link and do the questions on home work

https://drive.google.com/file/d/1nrf78r6ad8w9OuMY2rTNcwl-AG64gt7S/view?usp=drivesdk

This Monday only the pointer output only
This question bank is from one of our PGT CS