Series &RQPS
Question Paper Code 326 Set 4
INFORMATION TECHNOLOGY
(Session 2023-24)
Time allowed : 3 hours
Maximum Marks : 60
General Instructions :
- Please read the instructions carefully.
- This question paper consists of 24 questions in two Sections : Section A and Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- Out of the given (6 + 18) = 24 questions, a candidate has to answer (6 + 11) = 17 questions in the allotted (maximum) time of 3 hours.
- All questions of a particular section must be attempted in the correct order.
- Section A : Objective Type Questions (30 marks) :
- This section has 6 questions.
- There is no negative marking.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
- Section B : Subjective Type Questions (30 marks) :
- This section has 18 questions.
- A candidate has to do 11 questions.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
Section A (Objective Type Questions) (30 Marks)
1. Answer any 4 questions out of the given 6 questions on Employability Skills. (4×1=4)
(i) A _____ is a group of words that communicate a complete meaning.
Ans: Sentence
(ii) In the acronym ‘SMART’ to set goals, the letter ‘S’ implies ____.
Ans: Specific
(iii) is a state of feeling upset, annoyed and hopeless.
Ans: Stress / Depression / Frustration
(iv) In a spreadsheet, ____ the shows the location of selected cell.
Ans: Name Box
(v) A/An ____ entrepreneur is a type of entrepreneur who creates a new market for his services or provides a service in an existing market.
Ans: Service
(vi) ____ farming is the process by which we can grow plants in an environmental friendly way.
Ans: Organic / Eco Friendly / Green
2. Answer any 5 out of the given 7 questions. (5X1=5)
(i) ____ is produced by processing data.
Ans: Information
(ii) How many primitive data types are supported by Java ?
Ans: 8 primitive data types (byte, short, int, long, float, double, char, boolean)
(iii) Which one of the following commands is used to delete the table from the database ?
(A) Delete
(B) Drop
(C) Remove
(D) Pop
(iv) ____ method in Java is used to concatenate the specified string at the end of the given string.
Ans: concat()
(v) NeGD stands for ____.
(A) National e-Governance District
(B) National e-Government Draw
(C) National e-Governance Division
(D) National e-Government Discord
(vi) What is the advantage of Java Virtual Machine ?
Ans: It is a platform-independent environment for executing Java code.
(vii) In which phase of web based application development, will the feasibility of the project be checked ?
Ans: Requirement Definition Phase
3. Answer any 6 out of the given 7 questions. (6X1=6)
(i) Write any two logical operators in Java.
Ans: AND, OR, NOT
(ii) State True or False. “Java is not a portable language.”
Ans: False
(iii) The ____ aggregate function in SQL is used to find the average of all the values for an attribute in a table.
(A) MAX
(B) MIN
(C) AVG
(D) COUNT
(iv) Name any two educational websites.
Ans: (i) https://ncert.nic.in (ii) https://cbseacademic.nic.in (iii) https://examsmantra.in
(v) In SQL, ____ constraint is used to restrict the values within a range in a relation.
(A) DEFAULT
(B) NOT NULL
(C) KEY
(D) CHECK
(vi) In a web application development process, data connectivity between front-end interface and back-end database happens in the ____ phase.
(A) Design
(B) Testing
(C) Implementation
(D) Requirement Definition
(vii) The ____ statement in Java is used to execute a block of code matching one value out of many possible values.
Ans: Switch / If … else / if … else if
4. Answer any 5 out of the given 6 questions. (5X1=5)
(i) Which of the following ICT enabled services have not been set up by the Indian Government ?
(A) Registration of death certificate
(B) Purchase of movie tickets
(C) RTI application submission
(D) Registration of birth certificate
(ii) Sohan has created a table, STUDENT in RDBMS. He now wants to add another field, PERCENTAGE, which is of type integer, to the table. Write the command that will help Sohan to complete his task.
Ans: Alter table student add percentage int;
(iii) Name any two ICT tools that can be used for e-Governance.
Ans: Mobile Phone, Internet, LAN, Laptop, Tablet
(iv) ____ method of Arrays class in Java helps us to search for a specific element in the array.
(A) search()
(B) binary()
(C) binarySearch()
(D) find()
(v) The number of rows in a relation is called the ____ of a relation.
Ans: Cardinality
(vi) Predict the output :System.out.print("Hello");
System.out.println("Java");
Ans: HelloJava
5. Answer any 5 out of the given 6 questions. (5X1=5)
(i) Name any two domains where database applications may be used.
Ans: Hospital, School, Banking, Government sector, Companies, e-Commerce, Airlines, Telecommunications, Hotels
(ii) To show the structure of created table in the database, ____ command is used.
Ans: DESC / Describe
(iii) ____ keyword is used to create a new class in Java program.
Ans: class
(iv) Write the SQL command to display all the details of teachers from the table ‘Teacher’ whose salary is greater than 15000.
Ans: SELECT * from Teacher where salary >15000 ;
(v) OOP stands for ____.
(A) Ordinary Object Programming
(B) Oriented Object Programming
(C) Outsource Oriented Processing
(D) Object Oriented Programming
(vi) Which keyword helps to make a data member of a class visible only within the class ?
Ans: private
6. Answer any 5 out of the given 6 questions. (5X1=5)
(i) Which of the following is a valid variable declaration ?
(A) yes no
(B) yes & no
(C) yesno
(D) 1_yesno
(ii) While creating a table in MYSQL database, Sudha wants to set the value for the field Age as 0. This value will be inserted if no value of age is given by the user. Suggest a constraint that Sudha can use to complete her task.
Asn: DEFAULT
(iii) Name the national portal which provides a single window access to information and services being provided by various government entities.
Ans: https://www.india.gov.in
(iv) What will be the output of the Java code given below ?int a = 20;
int b = 30;
a + = b;
System.out.println(a);
Ans: 50
(v) Which one of the following is not a DML command ?
(A) SELECT
(B) INSERT
(C) CREATE
(D) DELETE
(vi) Give any one benefit of online shopping to the consumer.
Ans: No pressure shopping, Anywhere anytime, Save travelling time, Safety
Section B (Subjective Type Questions) (30 Marks)
Answer any 3 questions out of the given 5 questions on Employability Skills. Answer each question in 20-30 words.
7. Write any two ways to maintain positive attitude.
Ans: (i) Feed the mind with positivity, read motivating books, listen to music with uplifting lyrics, watch inspiring movies, etc.
(ii) Move towards your goals and dreams. Be cheerful and work hard to achieve the dreams.
8. What are the different stages of active listening ? Write the names of any four stages.
Ans: Receiving, Understanding, Remembering, Evaluating, Responding / Feedback
9. How can we reduce greenhouse gas emission ?
Ans: We can reduce greenhouse gas emissions by using energy-efficient appliances, conserving electricity, reducing waste, planting more trees, using CNG instead of fossil fuels, and choosing renewable energy like solar or wind power.
10. Write any two benefits of goal setting by an entrepreneur.
Ans: (i) Give directions (ii) Makes him to put more effort and focus (iii) Provides clarity and focus (iv) Helps to measure progress
11. Write the steps to save a presentation in LibreOffice Impress.
Ans: Step 1: Click on File menu and Select Save / Save As option from Drop-down menu. OR Press Ctrl +S
Step 2: In the Save As dialog box, Select the folder where you want to save your file and write the name of file.
Step 3: Click on Save button.
Answer any 3 out of the given 5 questions in 20-30 words each. (3X2=6)
12. Give the output of the following code segment :
public class test {
public static void main (string [] args) {
int num = 5;
while (num > 1)
{ system.out.println("**" + num * num);
-- num;
}
}
}Ans:**25
**16
**9
**4
13. What is DBA ? Write any one responsibility of DBA.
Ans: DBA means a Database Administrator (DBA)
A Database Administrator (DBA) manages the database and DBMS, controls user access, monitors usage, and ensures security and integrity. They provide technical support, acquire necessary software and hardware, and make sure the database is always available and accessible. Additionally, they ensure that all stored data remains safe, accurate, and well-organized.
14. Differentiate between CHAR(n) and VARCHAR(n) data types of MySQL. Give examples to support your answer.
Ans: CHAR(n) – It is used for fixed length character string where ‘n’ is no. of characters.VARCHAR(n) – It is used for variable length string where ‘n’ is maximum no. of characters in a string.
15. Aalam wants to create a database to manage the purchase and sale of items in his departmental store. The ITEMS table in the database contains information of all items that he sells in his store. Give details of ITEMS table along with its schema.
Ans: ITEMS (Item_Code, Item_Name, Price, Qty)
Details:
| Name | Type | Remarks |
Item_ Code | INT (10) | Primary Key |
Item_ Name | CHAR (20)/ VARCHAR(20) | Name of Item |
Price | INT (10) | Price of Item |
Qty | INT (10) | Qty of Item available |
16. Differentiate between while loop and do while loop in Java.
| while loop | do….while loop |
|---|---|
| Entry-controlled loop | Exit-controlled loop |
| Loop executes only when condition is true | Loop executes at least once whether condition is true or false. |
Answer any 2 out of the given 3 questions in 30-50 words each. (2X3=6)
17. Complete the following code in JAVA, that prints the number (either 0 or 1) in words :
public class word {
public static void main (string [ ] args) {
int number = 0;
______ (number) {
case 0 :
system.out.println("ZERO");
______;
case 1 :
system.out.println("ONE");
break;
______:
system.out.println("NEITHER ZERO NOR ONE");
}
}
}public class word {
public static void main (string [ ] args) {
int number = 0;
switch (number) {
case 0 :
system.out.println("ZERO");
break;
case 1 :
system.out.println("ONE");
break;
default:
system.out.println("NEITHER ZERO NOR ONE");
}
}
}18. (a) Vikrant has given the following query but it has errors. Rectify the errors and underline the correction made.
Select name, age from teacher where name = “_a%”;
Ans: Select name, age from teacher where name like “_a%”;
(b) Explain the GROUP BY clause in SQL with an example.
Ans: GROUP BY clause is used to view results in groups based on an attribute.
For e.g. – to find the number of teachers teaching in each department, we can use group by clause –SELECT Dept_No, Count(*) From Teacher Group By Dept_No;
19. State the applications of database management systems in the field of education.
Ans: Applications of Database Management Systems (DBMS) in Education are as follows:
(i) For storing information about teaching and non-teaching staff.
(ii) For storing details of infrastructure.
(iii) For storing information about student’s details, marks and result.
(iv) Educational institutions can track student performance, analyse data, and provide students with personalized learning experiences.
(v) To store data of alumni members
Answer any 3 out of the given 5 questions in 50-80 words each. (3X4=12)
20. (a) Read the given Java code carefully and give the output :public class StringDemo{
public static void main(String[]args) {
String myString = "Welcome Java";
System.out.println (myString.toUpperCase());
System.out.println (myString.indexOf('o'));
System.out.println (myString.contains("come"));
}}
Ans:WELCOME JAVA
4
true
(b) Consider the following string in Java :String quote = "Stay Safe";
Write a statement to replace ‘Safe’ with ‘Secure’
Ans: quote.replace(“Safe”, “Secure”);
21. (a) Write a program in Java to display area of a rectangle.
Note : Assign any imaginary values to the variables used in the program.
public class Area_Rect
{
public static void main(String[ ] args)
{ int l = 20, b = 30, area;
area = l * b;
System.out.println(“Area of rectangle is”+area);
}
}(b) What is the difference between = and == operator in Java ? Give example to support your answer.
| Assignment Operator (=) | Relational / Comparative operator (==) |
|---|---|
| The “=” is an assignment operator used to assign the value on the right to the variable on the left. | The ‘==’ is a relational / comparative operator that checks whether the two given operands are equal or not. If so, it returns true otherwise it returns false. |
| eg: b = 20; | eg: 5==5 This will return true. |
22. (a) Give one difference between a webinar and a video tutorial.
Ans: Webinar – These are real time lectures, where users participate in the lecture, may ask questions, and get their queries answered.
Video Tutorials – These are videos or slides of lectures for which the learner can visit the site and view them.
(b) The organization or company providing the online reservation facility to the users has several advantages. Give any two of these advantages.
Ans: Two advantages to the organization or company:
(i) Requires less staffing save your staff time
(ii) Reduce workloads for your staff and optimize customer service
(iii) No more human errors
(iv) Global access
(c) Anil wants to book a flight from Delhi to Mumbai through online reservation. He has opened the website for flight reservation and logged in using his userid and password. Write the steps that he should follow now to complete his booking.
Ans: Step 1: Search the flight available by entering some details like source, destination, date of travelling, personal details etc.
Step 2: Select the desired seat and confirm the seat and proceed to payment option.
Step 3: Make the payment.
Step 4: Download the e-ticket after confirmation.
23. (a) Define the term Array with respect to Java.
Ans: Array is a type of variable which can hold multiple values of same data type.
(b) Explain the access modifiers and their types in Java.
Ans: Access modifiers are used to make the class members visible/non-visible outside the class.
Private members of a class cannot be accessed outside the class.
Public members of a class can be accessed both within and outside the class.
By default, all members of a class are public.
24. Consider the following and answer the questions.
(a) Write an SQL command to create a table TravelAgency whose description is given below :
| AgentCode | Char(4) | Primary Key |
|---|---|---|
| AgentName | Varchar(20) | Not Null |
| Location | Varchar(25) | |
| Package | Varchar(30) | |
| Charges | Decimal |
Create table TravelAgency (
AgentCode char (4) Primary key,
AgentName varchar (20) Not Null,
Location varchar (25),
Package varchar (30),
Charges Decimal
);(b) Write the command to add a new row to a table TravelAgency with the following data :("A005","Raman","Grover Travel","Domestic",8000)
Ans: INSERT into TravelAgency VALUES (“A005”, “Raman”, “Grover Travel”, “Domestic”, 8000);
(c) Write a query to remove the column Package from the table TravelAgency.
Ans: ALTER table TravelAgency DROP COLUMN Package;