\n| 4<\/td>\n | Sharpner<\/td>\n | 90<\/td>\n | 120<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Answer:
\na) \u03c3 Quantity > 60 (PRODUCT)
\nb) \u03c0 Pname, Quantity (PRODUCT)<\/p>\n Question 14.
\nWhy do we need a PHP script in Webpages? What type of output is generated when a PHP script is processed?
\nAnswer:
\nClient-side scripts(JavaScript) are run faster but it has some limitations. The limitations are we can view the source code hence it is less secure. On the other hand, PHP is executed on the server and the result is sent back to the client (browser) so it is impossible to view the source code.<\/p>\n Question 15.
\nWhat is e-banking? What are the areas where e-banking is effectively utilized?
\nAnswer:
\nE-banking (Electronic Banking): Through electronic channels doing all the banking activities at any time and place through the internet. Through this one can transfer funds from our account to another account, hence one can pay bills such as telephone, electricity, purchase tickets(Flight, Train, Cinema, etc).<\/p>\n Question 16.
\nWhat is GIS?
\nAnswer:
\nGeographical Information System: Geographic Information System(GIS) technology is developed from the digital cartography and Computer-Aided Design(CAD) database management system. GIS as the name implies capturing, storing for future reference, checking and displaying data related to various positions on the earth\u2019s surface. GIS-can be applied in many areas such as soil mapping, agricultural mapping, forest mapping, e-Governance, etc.
\nGIS is used in development planning like strategic rural and urban planning, infrastructure planning, precision agriculture planning, etc.<\/p>\n Answer any nine questions from 17 to 27 (3 scores each)<\/span><\/p>\nQuestion 17.
\na) What is nested structure? (1 score)
\nb) Consider the following structure definition
\nstruct Student
\n{
\nint rno;
\nchar Name [20];
\nchar dob;
\n}<\/p>\n How can you implement the concept of nested structure using the member ‘dob’?
\nAnswer:
\nIf a structure declaration contains another structure as one of the members, it is called a nested structure.
\nstruct date
\n{
\nshort day, month, year;
\n};
\nstruct Student
\n{
\nint rno;
\ncharname[20];
\ndate dob;
\n};<\/p>\n Question 18.
\nExplain any three concepts of object-oriented programming?
\nAnswer:
\nAdvantages of using OOP are<\/p>\n \n- OOP allows modularity(divide the large programs into smaller ones)<\/li>\n
- It is good for defining abstract data types.<\/li>\n
- It allows data abstraction. That is it hides or protects data.<\/li>\n
- It allows code reusability<\/li>\n
- Real-life entities can be easily created<\/li>\n
- It supports to create new data types.<\/li>\n<\/ol>\n
Question 19.
\nWrite an algorithm to remove an item from a Queue?
\nAnswer:
\nStep 1: If front = Null then print \u201cUNDERFLOW\u201d and return
\nStep 2: Set item = Queue[front]
\nStep 3: If front = rear then
\nSet front = Null and rear = Null
\nElse if front = N then set front = 1
\nElse
\nSet front = front +1
\nEnd if
\nStep 4: stop<\/p>\n Question 20.
\nList and explain any three attributes of TABLE tag in HTML
\nAnswer:
\n<Table> Attributes (Any three)<\/p>\n \n- Border – It specifies the thickness of the borderlines.<\/li>\n
- Border color – Colorful border lines.<\/li>\n
- Align – Specifies the table alignment in the window.<\/li>\n
- Bg-color – Specifies background colour.<\/li>\n
- Cellspacing – Specifies space between table cells.<\/li>\n
- Cellpadding – Specifies space between cell border and content.<\/li>\n
- Cols – Specifies the number of columns in the table.<\/li>\n
- Width – Specifies the table width.<\/li>\n
- Frame – Specifies the border lines around the table.<\/li>\n
- Rules – Specifies the rules (lines) and it overrides the border attribute.<\/li>\n<\/ol>\n
Question 21.
\nWhat are the different ways to add javascript in a webpage?
\nAnswer:
\nWays to add scripts to a web page.
\n1) Inside <BODY> section
\nScripts can be placed inside the <BODY> section.
\n2) Inside <HEAD> section
\nScripts can be placed inside the <HEAD> section. This method is a widely accepted method
\n3) External (another) JavaScript file
\nWe can write scripts in a file and save it as a separate file with the extension .js. The advantage is that this file can be used across multiple HTML files and can enhance the speed of page loading.<\/p>\n Question 22.
\nWhat is meant by web hosting? Briefly explain any two pages of web hosting?
\nAnswer:
\nWeb hosting
\nBuying or renting storage space to store website in a web server and provide service(made available 24×7) to all the computers connected to the Internet. This is called web hosting. Such service providing companies are called web hosts. Programming languages used are PHP, ASP.NET, JSP.NET, etc.<\/p>\n Types of web hosting
\nVarious types of web hosting services are available. We can choose the web hosting services according to our needs depends upon the storage space needed for hosting, the number of visitors expected to visit, etc.<\/p>\n 1. Shared Hosting: This type of hosting sharing resources, like memory, disk space and CPU hence the name shared. Several websites share the same server. This is suitable for small websites that have less traffic and it is not suitable for large websites that have large bandwidth, large storage space and have large volume of traffic. Eg: Shared hosting is very similar to living in an Apartment(Villas) complex. All residents are in the same location and must share the available resources(Car parking area, Swimming pool, Gymnasium, playground, etc) with everyone.<\/p>\n 2. Dedicated Hosting: A web server and its resources are exclusively for one website that have large volume of traffic mean large volume of requests by the visitors. Some Govt, departments or large organizations require uninterrupted services for that round the clock power supply is needed. It is too expensive but it is more reliable and provides good service to the public.
\nEg: It is similar to living in an Our own house. All the resources in your house are only for you. No one else\u2019s account resides on the computer and would not be capable of tapping into your resources.<\/p>\n 3. Virtual Private Server (VPS): A VPS is a virtual machine sold as a service by an Internet hosting Service. A VPS runs its own copy of an OS(Operating System) and customers have super level access to that OS instance, so they can install almost any s\/w that runs on that OS. This type is suitable for websites that require more features than shared hosting but less features than dedicated hosting.
\nEg: It is similar to owning a Condo<\/p>\n Question 23.
\nExplain different level of data abstraction in DBMS?
\nAnswer:
\nLevels of Database Abstraction
\n1. Physical Level (Lowest Level) – It describes how the data is actually stored in the storage medium.
\n2. Logical Level (Next Higher Level) – It describes what data are stored in the database.
\n3. View Level (Highest level) – It is closest to the users. It is concerned with the way in which the individual users view the data.<\/p>\n Question 24.
\nWhich constraints are used to define the following cases in SQL?
\na) set a field to uniquely identify rows in a table.
\nb) increment the value of a field automatically.
\nc) set the value of a field to be not null
\nAnswer:
\na) Primary key
\nb) auto increment
\nc) not null<\/p>\n Question 25.
\nConsider the data given below
\nData in first array: 12, 36, 29, 34, 48
\nData in Second array: Pen = 35, Pencil = 40, Eraser = 5, Brush = 25.
\na) Name the suitable types of arrays to store these data. (1 score)
\nb) Write the PHP code to create these arrays to store the data. (2 score)
\nAnswer:
\na) first array – Indexed array
\nsecond array – Associated array<\/p>\n b) i) $mark=array(12, 36, 29, 34, 48);
\nii) $price=array(\u201cPen\u201d=>”35″,”Pencil”=>”40″, “Eraser\u201d=>”5”, “Brush\u201d=>”25”);<\/p>\n Question 26.
\nWhat is meant by distributed computing? Discuss any two distributed computing Paradigms.
\nAnswer:
\nDistributed computing is a method of computing in which large problems can be divided into smaller ones and this smaller ones are distributed among several computers. The solution for the smaller ones are computed separately and simultaneously. Finally the results are assembled to get the desired overall solution.<\/p>\n 1. Parallel computing
\nIn Serial computation the problem is divided into series of instructions and these instructions are executed sequentially, i.e. one after another. Here, only one instruction is executed at a time. But in parallel computing more than one instruction is executed simultaneously at a time.<\/p>\n 2. Grid computing
\nIt is a system in which millions of computers, smart phones, satellites, telescopes, cameras, sensors etc. are connected each other as a cyber world in which computational power (resources, services, data) is readily available like electric power. Any information at any time at any place can be made available in our finger tips. This is used in disaster management, weather forecasting, market forecasting, bio information etc.<\/p>\n Question 27.
\nWhat are the different types of interaction between stakeholders in e-Govemance?
\nAnswer:
\ne-Govemance facilitates interaction between different stakeholders in governance
\nGovernment to Government(G2G): Electronically exchanging data or information among Government agencies, departments or organizations.
\nGovernment to Citizens(G2C): Exchange information between Government and Citizens Government to Business(G2B): Interaction between the Government and Business men.
\nGovernment to Employees(G2E): The exchange of information between Government and its employees<\/p>\n Answer any two questions from 28 to 30 (5 score each)<\/span><\/p>\nQuestion 28.
\na) Why do we need dynamic webpage? Give an example.
\nb) What is the role ofwebservers?
\nc) Differentiate static webpage and dynamic webpage
\nAnswer:
\na) Some pages are displaying same content(same text, images,etc) every time. Its content are not changing. This type of web pages are called static page.Conventional wep pages display static pages and has some limitations.
\nAdvanced tools are used to create web pages dynamic, that means pages are more attractive and interactive. For this JavaScript, VBScript, ASP, JSP, PHP, etc are used
\nb) A computer with high storage capacity, high speed and processing capabilities is called a web server. Hence it is a powerful computer with a server operating system and software for providing services like www, e-mail etc. Popular server operating systems are Redhat, openSUSE, Debian, Ubuntu, Sun Solaris, Microsoft Windows Server etc.
\nc)<\/p>\n \n\n\n| Static web pages<\/td>\n | Dynamic web pages<\/td>\n<\/tr>\n | \n| Content and layout is fixed<\/td>\n | Content and layout is changed frequently<\/td>\n<\/tr>\n | \n| Never use database Run by browser<\/td>\n | Data base is used It runs on the server and result get back to the client (browser)<\/td>\n<\/tr>\n | \n| Easy to develop<\/td>\n | Not at all easy<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Question 29.
\na) What is the use of rowspan and colspan in a table in HTML?
\nb) Correct the given HTML code to get the output as shown in the figure<\/p>\n \n\n\n| Science<\/td>\n<\/tr>\n | \n| Roll No.<\/td>\n | Name<\/td>\n<\/tr>\n | \n| 1<\/td>\n | Arun<\/td>\n<\/tr>\n | \n| 2<\/td>\n | Aliya<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <html>
\n<body>
\n<table>
\n<tr>
\n<td align=’centre’>science<\/td>
\n<\/tr>
\n<tr>
\n<td>Rollno<\/td?
\n<td>name<\/td>
\n<\/tr>
\n<tr>
\n<td>1<\/td>
\n<td>Arun<\/td>
\n<\/tr>
\n<\/table>
\n<\/body>
\n<\/html>
\nAnswer:
\na) Colspan – Specifies the number of columns span for the cell.
\nRowspan – Specifies the number of rows span for the cell.<\/p>\n b) <html>
\n<body>
\n<table border=”1″>
\n<tr>
\n<td colspan=\u201d2″ align=\u201dcenter\u201d>Science<\/td>
\n<\/tr>
\n<tr>
\n<td>Rollno<\/td>
\n<td>name<\/td>
\n<\/tr>
\n<tr> <td>1<\/td>
\n<td>Arun<\/td>
\n<\/tr>
\n<tr>
\n<td>2<\/td>
\n<td>Aliya<\/td>
\n<\/tr>
\n<\/table>
\n<\/body
\n<\/html><\/p>\n Question 30.
\nWrite SQL queries based on the table EMPLOYEE given below.<\/p>\n \n\n\n| EID<\/td>\n | Name<\/td>\n | Job Code<\/td>\n | Salary<\/td>\n<\/tr>\n | \n| 1876<\/td>\n | Syam<\/td>\n | ME3<\/td>\n | 45000<\/td>\n<\/tr>\n | \n| 1114<\/td>\n | Abdu<\/td>\n | FA5<\/td>\n | 32000<\/td>\n<\/tr>\n | \n| 1556<\/td>\n | John<\/td>\n | TA1<\/td>\n | 39000<\/td>\n<\/tr>\n | \n| 1354<\/td>\n | Dhyana<\/td>\n | TA1<\/td>\n | 50000<\/td>\n<\/tr>\n | \n| 1130<\/td>\n | Dhanam<\/td>\n | ME3<\/td>\n | 42000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n a) List EID and name of all employees
\nb) Find all employees with Job code TA1 and salary greater than 39000
\nc) Find all employees whose name begins with the letter D
\nd) Delete all employees with Job code ME3
\ne) Display the details of employees in ascending order of salary
\nAnswer:
\na) select EID, Name from EMPLOYEE;
\nb) Select * from EMPLOYEE where JobCode=’TA1′ and Salary>39000;
\nc) Select * from EMPLOYEE where Name like ‘D%’;
\nd) Delete from EMPLOYEE where JobCode=’ME3′;
\ne) Select * from EMPLOYEE order by Salary;<\/p>\n | | | |