Series 4YWZX
Question Paper Code 326 Set 4
INFORMATION TECHNOLOGY
(Session 2024-25)
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 out of the given 6 questions. (4X1=4)
i) _____ is an element of communication which encodes and sends messages through a channel.
Ans: Sender
ii) To maintain a positive attitude, which one of the following is not a good practice?
a) Feed the mind with positivity
b) Don’t learn from failures
c) Move towards your goals and dreams
d) Start the day with a morning routine
iii) State True or False: “Personality disorders involve long-term patterns of thoughts and behaviours that are unhealthy and rigid.”
Ans: True
iv) In the spreadsheet software, a _____ is an arrangement of cells in a vertical (standing) manner.
Ans: Column
v) ______ is one of the most important attitudes of an entrepreneur, which is defined as the ability to continue to do something, even when it is difficult.
a) Decisiveness
b) Interpersonal Skills
c) Perseverance
d) Taking Initiative
vi) CNG stands for _____.
Ans: Compressed Natural Gas
2. Answer any 5 out of the given 7 questions. (5X1=5)
i) DBMS stands for _____.
Ans: Database Management System
ii) All Java statements must end with a/an _____.
Ans: Semi-colon (;)
iii) _____ is a language that is used to manage data stored in an RDBMS.
Ans: SQL (Structured Query Language) / MySQL
iv) In relational models, a ______ is called a relation.
Ans: Table
v) IRCTC Online portal for booking train tickets stands for:
a) International Railway Catering and Tourism Corporation
b) Indian Railway Controlling and Transport Corporation
c) Indian Railway Catering and Tourism Corporation (irctc.co.in)
d) International Railway Controlling and Transport Corporation
vi) Which of the following is not a valid data type of SQL?
a) CHAR(n)
b) VARCHAR(n)
c) STR(n)
d) DATE
vii) A web application is a program that is store on a _____ server.
a) Remote
b) Voice
c) Local
d) Data
3. Answer any 6 out of the given 7 questions. (6X1=6)
i) Name any two popular e-learning websites.
Ans: coursera.com, khanacademy.org, W3Schools, NCERT.nic.in, Unacademy
ii) A computer can understand only its own language called _____.
Ans: Machine Language / Binary Language / 0,1 Language / Hardware Language
iii) Kritika did not use ASC or DESC keyword with ORDER BY clause. By default in which order will the result of the query be displayed?
Ans: ASC / Ascending Order
iv) _____ is the national web portal of India, which provides a single window access to information and services being provided by the various Indian government entities.
Ans: www.india.gov.in
v) Rahul forgot to add a column in the existing table. Which one of the following SQL commands can he use to add the desired column in the table?
a) INSERT
b) UPDATE
c) MODIFY
d) ALTER
vi) _____ makes the password safer for online transactions.
a) Combination of alphabets, special symbols and numbers
b) Use of personal mobile number
c) Use of name of near and dear ones
d) Use of date of birth of mother
vii) “Variables in Java need not be declared and initialized before they are used.” State True or False.
Ans: False
4. Answer any 5 out of the given 6 questions. (5X1=5)
i) Connectivity between Frontend and Backend project will be done in ______ Phase of a web application project.
Ans: Implementation
ii) If the value of an attribute in a tuple in not known or not applicable or not available, a special value called _____ is used to represent them.
a) EMPTY
b) BLANK
c) NULL
d) VOID
iii) In India the main thrust for e-governance was provided by the launching of _____, the national satellite-based computer network in 1987.
a) NICNET
b) DEITY
c) NEGP
d) NEGD
iv) What is a variable in Java Programming language?
Ans: Variables are like containers or placeholders in memory that store value or information. In Java, they hold values like numbers, letters, or decimals while the program runs. Each variable has a specific type that tells what kind of data it can keep.
Example: int a = 15;
v) _____ keyword is used in SELECT statement along with column name to display duplicate values once in the result of an SQL query.
Ans: DISTINCT
vi) Select the valid statement to declare and initialize an array in Java:
a) int[] marks;
b) int[] marks = {60, 70, 90};
c) int[] marks = (60, 70, 90);
d) int[] marks = [60, 70, 90];
5. Answer any 5 out of the given 6 questions. (5X1=5)
i) Which of the following statements is incorrect related to database application used in the domains?
a) Education Database Application is used to store data of students and staff
b) Hospital Database Application is used to record data of patients
c) Banking Database Application is used to record details of stock of medicines
d) Government Database Application is used to record details electoral roll
ii) Out of many types of DBMS users, _____ is responsible to determine the requirements of the end users and then develop specifications to meet the requirements.
a) DBA
b) Application Programmers
c) System Analyst
d) Tester
iii) Exception thrown by any statement in try block in a Java program is handled in _____ block.
a) final
b) throw
c) catch
d) except
iv) Rashmi is not able to leave a blank in the Salary column of the Employee table. Which constraint is applied on the field Salary?
a) NOT NULL
b) DEFAULT
c) CHECK
d) NOT BLANK
v) Which is the correct way to write multiline comments in a Java program?
a) Beginning a comment line with two consecutive forward slashes (//)
b) Writing a comment between the symbols /* and */
c) Beginning a comment line with # symbol
d) Writing a comment between the symbols /# and #/
vi) Name the Java interpreter that translates the byte code into machine code and then executes it.
Ans: Java Virtual Machine (JVM)
6. Answer any 5 out of the given 6 questions. (5X1=5)
i) Which access modifier in Java is used to make a data member or a method member of a class visible only within the class?
a) public
b) protected
c) default
d) private
ii) Flipkart and eBay are example of _____ shopping stores.
Ans: online, electronic, e-commerece
iii) Write the names of any two web browsers which help us to browse various websites over the Internet.
Ans: Google chrome, Mozilla Firefox, Microsoft Edge, Brave, Opera, Maxthone, Vivaldi
iv) A/An _____ in Java is a block of statements grouped together to perform a specific task.
a) Array
b) Object
c) Class
d) Method
v) In Java, _____ statement is used to execute a block of code matching one value out of many possible values.
Ans: switch
vi) In which Java package is the scanner class available?
a) java.util
b) java.applet
c) java.net
d) java.lang
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. What is a Green Job?
Ans: A green job is one that helps bring about and maintain transition to environmentally sustainable forms of prodcution and consumption. It helps to protect and restore the environment for future generation.
8. To create a digital presentation, suggest the name of any two popular presentation softwares.
Ans: MS PowerPoint, Libre/Open Office Impress, Google Slides, Canva, Prezi, Apple Keynote
9. Briefly explain the following terms:
(a) Personality – It is cluster of thoughts, feelings and behaviours that make a person different from others.
(b) Personality traits – It is defined as relatively lasting patterns of thoughts, feelings and behaviours that differentiate individuals from one another.
10. Mention any four most common environmental barriers which an entrepreneur may face while running his/her venture.
Ans: (i) Government Policies: Too many rules or changing laws can make it hard to run a business.
(ii) New Technology: Technology keeps changing, and it can be hard or costly to keep up.
11. Briefly explain any two factors that affect active listening.
Ans: Here are two factors that affect active listening:
(i) Lack of Interest – If you’re not interested in the topic, it’s hard to pay full attention.
(ii) Body Language – Poor eye contact or closed posture can show disinterest and affect listening.
Answer any 3 out of the given 5 questions in 20-30 words each. (3X2=6)
12. What will be the output of the following Java statement:
(a) System.out.println("30+20");
Ans: 30+20
(b) System.out.println("Information Technology" +802);
Ans: Information Technology802
13. Write any two characteristics of database management system.
Ans: (i) Data Sharing: Allows multiple users to access and use the data at the same time.
(ii) Data Integrity: Ensures the accuracy and consistency of data.
14. What is the purpose of % and _ (underscore) used with LIKE operator in SQL?
Ans: These are the wildcard characters.
% represents zero or more characters where as _ (underscore) represents one or single character.
15. What is Java IDE? Name any one commonly used Java IDE.
Ans: Java IDE (Integrity Development Environment) is an editor which is used to write, compile, run and debug the Java programs. Java IDE is the combination of text editor and compiler, which simplify the writing, compiling and executing Java programs.
Netbeans Java IDE is the common used Java IDE.
16. List any two ways in which database application is used in banking sector.
Ans: (i) For storing information of customers and their accounts, transactions etc.
(ii) For storing information of employees like details, salary, joining date, presents, leaves etc.s
Answer any 2 out of the given 3 questions in 30-50 words each. (2X3=6)
17. Write a java program to calculate and display the factorial of a number 5 using for loop.
public class FactorialExample {
public static void main(String[] args) {
int number = 5; // Number to find factorial
int factorial = 1;
for (int i = 1; i <= number; i++) {
factorial *= i; // Multiply factorial by i
}
System.out.println("Factorial of " + number + " is: " + factorial);
}
}
Output: Factorial of 5 is: 12018. Explain the use of any three aggregate functions in SQL.
Ans: Aggregate functions that perform a calculation on a set of numeric values and return a single value as an output. They are commonly used with the GROUP BY clause to group rows that share a property and perform calculations on each group.
Here are three commonly used aggregate functions in SQL and their uses:
(i) SUM() – It returns the total sum of a numeric column.
Example: SELECT SUM(salary) FROM employees;
(ii) AVG() It returns the average value of a numeric column.
Example: SELECT AVG(marks) FROM students;
(iii) COUNT() It returns the total number of rows or non-null values in a column.
Example: SELECT COUNT(*) FROM orders;
19. Varun is the owner of New Trends Fashion Company that deals in garments. He wants to make a database application for his company. Suggest any 6 possible entities that can be used in the database for his website.
Ans: Here are 6 possible entities that Varun can use in the database for his New Trends Fashion Company website:
(i) Employee (ii) Customer (iii) Product (iv) Order (v) Payment (vi) Supplier
Answer any 3 out of the given 5 questions in 50-80 words each. (3X4=12)
20. Consider the following string variables:String str1 = "Hello";
String str2 = "Java Programming";
Write the code statements for the following in Java:
(a) to display the string str1 into uppercase.
Ans: System.out.println(str1.toUpperCase());
(b) to display the character at the index 6 in string str2.
Ans: System.out.println(str2.charAt(6));
(c) To display the index of the first occurrence of letter ‘l‘ in the string str1.
Ans: System.out.println(str1.indexOf('l'));
(d) to display the string str1 after replacing letter ‘l‘ with ‘*‘.
Ans: System.out.println(str1.replace('l','*'));
21. Differentiate between Entry controlled loop and Exit control loop.
| Entry controlled loop | Exit control loop |
|---|---|
| Condition is checked before the loop body executes. | Condition is checked after the loop body executes. |
| Loop body may not execute even once if the condition is false. | Loop body executes at least once, even if the condition is false. |
| Used when the number of iterations is known or depends on a condition. | Used when the loop must run at least once regardless of the condition. |
| Example: for, while | Example: do-while |
22. Explain any four advantages of online learning.
Ans: Four advantages of online learning are:
(i) Flexibility: Learn at your own pace and schedule.
(ii) Accessibility: Access courses from anywhere in the world.
(iii) Wide Range of Courses: Choose from a variety of subjects and skill levels.
(iv) Cost-Effective: Save on travel, accommodation, and physical materials.
23. (a) what are the different ways to create threads in Java programming?
Ans: There are two ways to create thread in Java.
(i) By extending the Thread class.
(ii) By implementing the Runnable interface.
(b) with reference to Java programming language, define assertion.
State any one way to write an assertion.
Ans: In Java, an assertion is a debugging tool used to test assumptions about the program during runtime. It allows developers to verify that a certain condition is true. If the condition is false, an AssertionError is thrown, indicating a programming error.
One way to write an assertion:assert condition : "Error message";
Here, condition is the boolean expression being checked, and "Error message" is an optional message that will be displayed if the assertion fails.
24. Consider the given table GARMENT:
| GCODE | GNAME | SIZE | COLOUR | PRICE |
|---|---|---|---|---|
| 111 | TShirt | XL | Red | 1400 |
| 112 | Jeans | L | Blue | 1600 |
| 113 | Skirt | M | Black | 1100 |
| 114 | Ladies Jacket | XL | Blue | 4000 |
| 115 | Trousers | L | Brown | 1500 |
| 116 | Ladies Top | L | Pink | 1200 |
Write SQL commands for the following:
(a) To display names of those garments that are available in ‘L’ size.
Ans: SELECT GNAME FROM GRAMENT WHERE SIZE = ‘L’;
(b) To change the colour of garments with code as 115 to “Orange”.
Ans: UPDATE GARMENT SET COLOUR = ‘Orange’ WHERE GCODE = 115;
(c) To add a new row with the following data:
GCODE = 117
GNAME = Kurta
SIZE = M
COLOUR = White
PRICE = 1000
Ans: INSERT INTO GARMENT VALUES (117, ‘Kurta’, ‘M’, ‘White’, 1000);
(d) To remove the column ‘COLOUR’ from the table ‘GARMENT’.
Ans: ALTER TABLE GARMENT DROP COLOUR;