Informatics Practices 2012 CBSE [ Outside Delhi] Set I

(a) The Societal Impacts of E-Governance on society are:

(i) E-Governance programs have improved the efficiency of administration and service delivery.

(ii) The E-Governance programs resulted in increased transparency and increased accountancy of government offices.

(b) The two main features of E-Business are:
(i) The E-Business refers to any form of transaction that uses an electronic medium to facilitate the transaction.
(ii) The E-Business provides servicing customers, collaborating with business partners, conducting e-learning and conducting electronic transactions within an organization.

Two most commonly used e-Business sites are:

(i) IRCTC Portal: Indian Railways Catering and Tourism Corporation

www.irctc.co.in

(ii) Various Banks such as State Bank of India

www.statebankofinda.com

(c) The place of the various controls is mentioned
below:

(a) The optical fiber can be used to connect the computers which are spread within the distance of 45meters. 
The optical fibers are used for fast transmission of data in the form of light signals over a long distance. They have much greater bandwidth than the other cables. 
(b) Gurumukhi and Devanagri are examples of two Indian Scripts included in Unicode.
(c) Proprietary software: Proprietary software refers to any computer software that has restrictions on any combinations of the usage, modification or distributing modified versions of the software. Microsoft Windows, Adobe Flash Player, iTunes are examples of proprietary software. 
Open Source Software: These are the software whose source code is available to the user for their use and/or modification from its original design is free of charge. These softwares can be freely used and redistributed.
Tomcat is an example of Open Source software. 
(d) Google Chrome and Internet Explorer are the two most commonly used internet browsers.
(e) 
(i) Repeater is a device used to regenerate the data and voice signal over a long distance. Repeater reads the data packets and amplifies the signals before sending them to the destination node due to which speed of the data transmission increases. Hence, we can install repeaters in-between the offices for smooth communication of data.
(ii)  The LAN (Local area network) can be selected to design network within a small range of 1km. A local-area network (LAN) is a computer network that spans a relatively small area such as a single building or within an organization which is spread within 1km. 
f)  The Star topology gives much faster performance as compared to Bus topology, because all computers are attached to a single central point called a hub or a switch. 
Network layout of Star topology to connect 5 computers:

g)  Uniform Resource Locators are the address used to locate the files.  
Examples of URLs are:
URLs- www.yahoo.com, www.google.com etc
Domain name specified the type of domain.
Examples of Domain name are:
Domain Names - .com, .gov, .edu etc

(a) The ComboBox is the most suitable control to show list of counties, because it takes less space while design a form. At the time of execution we can click on the down arrow of the ComboBox to select the country.

(b) The Break statement is used to break the loop of switch statement at the end of each case blocks. Due to which each case block gets executed only once during a condition check.

  switch(choice)

{

case 1: //statements

              break;

case 2: //statements

              break;

.

.

}

Here for each value of choice, only one block of case will execute and then as break will encounter, the control would be transferred at the end of the switch block.

(c) The HTML tag < ol > (ordered list) is used to insert a numbered list in a web page:

Example Code:

         < b>My Ordered List:< /b >

         < ol >

            < li > Red

            < li > Green

           < li > Blue

           < /ol >

Output:

My Ordered List:

1.     Red

2.     Green

3.     Blue

(d) The HTML code to hyperlink CBSE website is:

  < a href=”http://www.cbse.nic.in/” >Welcome to CBSE< /a>

(e) The loop will go infinite and it will print : 16 16 16 16 16 16...  as output because the condition check is missing in the body of the for loop.

(f)The unit (iii) Mbps (Mega bits per second) is used to measure the speed of data transmission from one node to another.

The data is transferred in the form of bits or bytes. The data transfer rate of a device is often expressed in kilobits or megabits per second, abbreviated as Kbps and Mbps respectively.

(g) Program to calculate cube of an entered number:

private void jButton2ActionPerformed( java.awt.event.ActionEvent evt)

{

            System.exit(0);

}

    private void jButton1ActionPerformed( java.awt.event.ActionEvent evt)

 {

        int a;

        String res;

        a=Integer.parseInt(jTextField1.getText());

        res=String.valueOf(a*a*a);

        jTextField2.setText(res);

    }

(a)

The command to view all existing databases in MySql is:
show databases;
Command to used an existing database is:
 use database_name;

(b) The command used to remove entire content of a table Backup along with table structure is:

   DROP TABLE table_name;

(c) The difference between COMMIT and ROLLBACK command is that, using COMMIT command the steps of transactions carried out successfully are saved permanently. Whereas using ROLLBACK the steps of transactions failed during processing are undone and the database returns to the same state as it was before this transaction execution stated.

(d) The Cartesian product of STUDENT table and TEACHER table will result in 12 rows and 6 columns.

(e) The CITY of table2 is assign a foreign key constraints which prevents the invalid data from being inserted into the foreign key column, because it has to be one of the values contained in the table it points to.

Any value which is inserted into a foreign key column must be equal to some value in the corresponding parent key of the parent table. So, we can say that Mr. Sanghi must have entered an invalid value in the column CITY due to which he is not able to insert the value into column CITY.

(f)

int intItemCode=23444;

// to assign the value of intItemCode to strItemCode we can write the following code:

    String strItemCode = Integer.toString(intItemCode);

OR

   String strItemCode = String.valueOf(intItemCode);

(g) In the code the LIKE keyword is missing which is used to work on string values, due to which Mr. Janak was not able to get the correct output.

The corrected code is given below:

Select Name from STUDENTS

where Course_name = Null OR Course_name LIKE  ‘%ecomomics’ ;

(a) The ORDER By clause determines the order of rows in the result table which can be either in ascending or descending.

Example:

       Select * from Student

       ORDER BY Name Desc;

Whereas the GROUP By clause combines the identical values of a particular field or group of fields. This grouping results into one summary record according to each group.     

Example:

       SELECT grade, avg(fees) from Student GROUP BY grade;

To place condition on groups we use HAVING clause instead of WHERE clause. 

(b) Cardinality: The cardinality of a relation is the number of tuples or rows present in a table.

Therefore, Cardinality of Table SCHOOL will be: 4

Degree: The degree of a relation is the number of attributes or columns present in a table.

Therefore, Degree of Table SCHOOL will be: 5

(c) Queries for question (i) to (iv)

(i) Select Item from SHOPPE

where Item LIKE ‘C%’ ORDER BY Item;

(ii) Select Code, Item, City from SHOPPE

where Qty<100;

(iii) Select count(DISTINCT Company) “Distinct Company”

from SHOPPE;
(iv)  Insert into SHOPPE

values(‘110’,’Pizza’,’Papa Jones’,120,’Kolkata’,50.0);

Outputs for question (v) to (vi)

(a)Query to create table STOCK:

Create table STOCK

 ( Id decimal primary key,

Name varchar(20),

Company varchar(20),

Price decimal Not Null
        );

(b)
(i)  Select ITEM.ICode, IName , Brand
from ITEM, BRAND

where (ITEM.ICode=BRAND.ICode) AND

 (Price BETWEEN 20000 AND 45000);

(ii) Select ITEM.ICode, Price , Brand

from ITEM, BRAND

where ITEM.IName = ’ Television’;

(iii) Update ITEM

SET Price Price=Price + (Price*0.15);

(c)

(i) The Primary Key is assigned to P_No.

(ii) The query is :
 

ALTER TABLE Patient

ADD Department varchar(30);

(a) The following message would be displayed after executing the code:
          
(b) The code using if statement is given below:

          int C=jComboBox1.getSelectedIndex();

          if(C==0)

                 Amount=Bill;

          if(C==1)

                 Amount=0.9*Bill;

          if(C==2)

                 Amount=0.8*Bill;

          else

                 Amount=Bill;

(c) The while loop is executed 6 times.

(d) The following output would be shown in the JTextArea after executing that code: 
                                

 (e)  The value of P will be: 4
The value of Q would be: 6

(f) The Output will be:
                                

In the ouput the first digit indicates the length of value stored in the integer variable.

(g) The form is:
                                                    

(i) Code to print series of EVEN or ODD number is:

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)

{                                        

        int a,b,even,odd;

        a=Integer.parseInt(jTextField1.getText());

        b=Integer.parseInt(jTextField2.getText());

        jTextArea1.setText(" ");

        if((a%2==0)&&(b%2==0)||(a%2!=0)&&(b%2!=0))

        {

            for(int i=a;i<=b;i+=2)

            {

              String str= jTextArea1.getText();   

                jTextArea1.setText(str + " " +i);

            }

        }

        else

             JOptionPane.showMessageDialog(this, " Both the ranges should be either EVEN or ODD");

    }                                       

(ii) Code to clear the content of jTextFields and jTextArea.

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt)

{                                        

        jTextField1.setText(" ");

        jTextField2.setText(" ");

        jTextArea1.setText(" ");

  } 

(iii) Code to terminate the application

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt)

{                                        

    System.exit(0);

}