CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 2 with Solutions

Students can access the CBSE Sample Papers for Class 12 Informatics Practices with Solutions and marking scheme Term 2 Set 2 will help students in understanding the difficulty level of the exam.

CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 2 with Solutions

Time: 2 Hours
Maximum Marks: 35

General Instructions:

• The question paper is divided into 3 sections -A, B and C
• Section A, consists of 7 questions (1-7). Each question carries 2 marks.
• Section B, consists of 3 questions (8-10). Each question carries 3 marks.
• Section C, consists of 3 questions( 11-13). Each question carries 4 marks.
• Internal choices have been given for question numbers -1,3,8 and 12.

Section – A [2 Marks each]

Question 1.
Select the type of web pages in following cases.
Case X: – A Web page that responds to user interaction.
Case Z: – A Web page that does not support Database handling. [2]
OR
Write one advantage and one disadvantage of (i) Star topology, (ii) Mesh topology. [2]
Answer:
Case X: – Dynamic Web page
Case Z: – Static Web page

Commonly Made Error:
Concept of static and dynamic web pages is not clear to students.

Answering Tip:
Static web page fixed contents for all instances of time and no interaction is possible at the running session.

Or

(i) Star topology:
Advantage – Layout cable cost is less.
Disadvantage – Network fails if the central node(hosti’Server) becomes dysfunctional

(ii) Mesh topology:
Advantage – Network works even when one or more nodes are dysfunctional.
Disadvantage – Layout cost increases as all nodes are connected with the rest of the nodes in the network.

Commonly Made Error: Students mix up the concepts of various topologies.

Answering Tip: learn topologies, like Bus, star, tree etc

Question 2.
(i) What is term for T’?
‘P’ – it is the service that allocates space on some server on internet.
Any web site owner requires ‘P’ to make its presence on internet round the clock.
Answer:
‘P’ represents ‘Web hosting’

(ii) Which protocol is followed by all web server? Give an example of Web server. [2]
Answer:
Web servers use HTTP protocol, other protocols run over HTTP Apache (Or Microsoft IIS or Nginx) Web Server.

Question 3.
Show output for these queries.
(i) SELECT ROUKD(74.075,-2);
(ii) SELECT MOD(4.25,1.5); [2]
OR
Explain the arguments and return value for (i) ROUND () and (ii) MOD() functions of MySQL. [2]
Answer:
(i) 100
Commonly made Error:
The sign with rounding place confuses students.

Answering Up:
A negative number means the number will be rounded off will be done to digits on the left of the decimal. -1 will round off to nearest tens and -2 will round off to nearest hundreds.

(ii) 1.25

OR

(i) ROUND() – Function needs two arguments, first is a real number that is to be rounded off and other is the number of decimal places returned. It returns the number rounded off to the specified precision.
Example – SELECT ROUND(75.55,l);
The function returns the value as 75.6,

(ii) MOD() – This function needs two numerical values as arguments, dividend and divisor. It returns the remainder of the division.
Example – SELECT MOD(14,3);
The function returns 2 as the remainder of dividing 14 by 3.

Question 4.
Mr. Dhanesh will like to take his business on Internet. Mr. Rakesh understood the requirement and developed the desired code for the proposed business on internet. What is now required for making this available on World Wide Web? Which type of web pages should it have? [2]
Answer:
It needs a Web Hosting service for the Web site so that it is visible and operational round the clock on the Internet.
It must have dynamic web pages.

Commonly Made Error:
Online business site is wrong, for web page type.

Answering Tip:
Since the site in question is a business site so it must be dynamic in nature to accept customer’s demands and feed backs, also a business web site needs to maintain database of its visitors and customers along with the products.

Question 5.
Sobhit is unable to predict the output of these following MySQL queries:-
(i) SELECT POW(2, – 1);
(ii) SELECT POW(4,0.5);
Answer:
(i) 0.5
(ii) 2

Commonly Made Error: Negative and fractional powers may confuse students.

Answering Tip: POW or POWER function is used to calculate the value of a number raised to some given number as an exponent.

Question 6.
Look at the table below with score points of some students.

What is output for these queries –
(i) SELECT COUNT (STREAM) FROM SCOREPOINT GROUP BY STREAM;
Answer:

COUNT(STREAM)

4

3

5

Commonly Made Error:
The NULL value in field is also counted. Actually, the NULL in a field stands for ‘Not Available* or ‘None’, it is even not same as 0.

Answering Tip:
count() doesn’t count null values in the specified column.

(ii) SELECT COUNT(OPTION) FROM SCOREPOINT GROUP BY OPTION ITAVING OPTION=’PHE’; [2]
Answer:

COUNT(OPTION)

4

Question 7.
Fill in the blanks with appropriate Date & Time related MySQL function. [2]
(i) SELECT ______ (‘20220325’);
[to display output as 3]
(ii) SELECT _______ (‘20220325’);
[to display output as 25]
OR
Look at the “STUDENTS” table as given below.

Write the output of following queries on this table.
(i) SELECT MIN(Adm_Date) FROM STUDENTS;
(ii) SELECT DAY(Adm_Date)+MONTH(Adm_Date) FROM STUDENTS WHERE FeePaid IS NULL; [2]
Answer:
(i) MONTH
(ii) DAY

Commonly Made Error:
Concepts of date and time format confuse the students.

Answering Tip:
Date & Time functions work on date values. MySQL accepts Date & Time values in string as well as numeric format. Date & Time value in string format is ‘YYYY-MM-DD HH:MM:SS’ or, “YYYY- MM-DD HH:MM:SS”. In numeric format – YYYYMMDDHHMMSS, it does not have quotation and separator symbols.
Hence, in number format, YEAR function will return first 4 digits from left, MONTH will return 5th and 6th digits, DAY will return 7th and 8th digits.

OR

(i) 2019-06-05
(ii) 27

Section – B [3 marks each]

Question 8.
Consider the structure of a table as

OSWAAL CBSE Sample Question Papers Term-ll, INFORMATICS PRACTICES, Class-XII
(i) Write MySQL query to view all the GAME in small letters.
(ii) Write MySQL query to get first four letters of the player names in PNAME field.
(iii) Write MySQL query to get 3 letters from 5th place in the COACH field. [3]
OR
Show output for the following MySQL queries.
(i) SELECT LENGTH(“12345″);
(ii) SELECT MIDfGopal Singh”,4,5);
(iii) SELECT INSTRfRana VijayVV”); [3]
Answer:
(i) SELECT LCASE(GAME) FROM Players; [ or SELECT LOWER(GAME) FROM Players;]
(ii) SELECT LEFT(PNAME,4) FROM Players;
(iii) SELECT MID(COACH,5,3) FROM Players; [also SELECT SUBSTR(COACH,5,3) FROM Players; or SELECT SUBSTRING(COACH,5,3) FROM Players;]

OR

(i) 5
(ii) al Si
(iii) 6

Commonly Made Error:
Responding questions with the string functions, students forget to count blank spaces inside string.

Answering Tip:
Count the blank spaces as one character for functions like LENGTH, INSTR, MID/SUBSTR/SUBSTRING, LEFT, RIGHT.

Question 9.
Sanjay Singhania needs your help to understand MySQL function for getting current date and time. Help him know the syntax, arguments and return type of function. [3]
Answer:
The current date time is obtained by MySQL function NOWQ [also SYSDATEQ],
(i) Syntax – NOW()
(ii) Arguments – none
(iii) Return type – as Date-Time [YYYY-MM-DD HH:MM:SS format] or as Number [YYYYMMDDHHMMSS format]

Question 10.
A string may contain space between two words. Presence of spaces in the beginning, or towards end does not have airy sense, such leading and trailing spaces add to length of string. For example
(i) ” New Delhi” has length as 12
(ii) ” New Delhi ” length as 14
(iii) ” • New Delhi ” has length as 16
Which string handling functions can be used in each of these cases to get String “New Delhi” having length 9? [3]
Answer:
Case (i) – Since the string has leading blank spaces (on left side of) using the LTRIMQ function – SELECT LTRIM(” New Delhi”) will return “New Delhi”.

Case (ii) – Since the string has trailing blank spaces using RTRIMO function will remove these. – SELECT RTRIM(“New Delhi “) will return “New Delhi”.

Case (iii) – Since the string has both leading and trailing blank spaces (on left as well as on right side), it can be removed by using the TRIMQ function will remove these. – SELECT TRIM(” New Delhi “) will return “New Delhi”.

Section – C [4 marks each]

Question 11.
Look at the table given below and write answers for (i) to (iv)

Write SQL queries for the following: [4]
(i) To display the average Stock of each Manufacturer.
Answer:
SELECT Manufacturer, AVG(Stock) FROM Lighting GROUP BY Manufacturer;

(ii) To display Count of Lighting by Type.
Answer:
SELECT Type, COUNT(Type) FROM Lighting GROUP BY Type;

(iii) To display the total prices of all Manufacturers
Answer:
SELECT Manufacturer, SUM(Price) FROM Lighting GROUP BY Manufacturer;

(iv) To display all records of White Colour in descending order of Manufacturer.
Answer:
SELECT * FROM Lighting WHERE Colour = ‘White’ ORDER BY Manufacturer DESC;

Question 12.
Write query using appropriate MySQL functions for the following: [4]
(i) Write query to display ‘ian’ from the string ‘Liliani’.
(ii) Write query to display the string ‘shreejeet’ in capital letters.
(iii) Write a query to display position of “hit” in the string “Rohit”.
(iv) Write query to display the remainder of division for the number 172 divided by 13.
OR
For the given table EMPLOYEE write answers for (i) to (iv)

(i) Write query to display all records for which ENAME has last letter as ‘a’.
(ii) Write query to display first three letters of ENAME.
(iii) Write query to display ENAME, SALARY and Month Name in DOJ from the table.
(iv) Write query to display ENAME, DOJ and SALARY for all in PROD department.
Answer:
(i) SELECT SUBSTR(‘Liliani’,4,3);

(ii) SELECT UPPER(‘shreejeet’);
Commonly Made Error:
There is no CAPITAL or SMALL function in MySQL
Answering Tip:
UCASE or UPPER gives a sting in upper case characters (capital letters), similarly, LCASE or LOWER gives a string in lower case characters (small letters).

(iii) SELECT INSTR(‘Rohit’, ‘hit’);

(iv) SELECT MOD(172,13);
Commonly Made Error:
Students may get confused as to which format to use in the answer.
Answering Tip:
MOD stands for Modulo operation, it has 3 formats – MOD(dividend, divisor);
Dividend MOD divisor;
Dividend % divisor
All give the remainder of a division

OR

(i) SELECT * FROM EMPLOYEE WHERE ENAME LIKE ‘%a’;
Commonly Made Error:
Predicate of LIKE clause unquoted.
Answering Tip:
LIKE clause is used for pattern matching, the predicate is always in quotes (single or double) -‘%’ is used for any number of characters(underscore) is used in case of single-character matching.

(ii) SELECT LEFT(ENAME,3) FROM EMPLOYEE;

(iii) SELECT ENAME, SALARY, MONTHNAME(DOJ) FROM EMPLOYEE;

(iv) SELECT ENAME, DOJ, SALARY FROM EMPLOYEE WHERE DEPT=’PROD’; [ or, SELECT ENAME, DOJ, SALARY FROM EMPLOYEE WHERE DEPT LIKE ‘PROD’;]

Question 13.
“Great Achievers College” has its main campus in suburban area and its branch is situated in the township. The buildings at these places are shown in the diagram. [4]

Distances between the blocks are given below:

Admin to Science	85 m
Admin to Commerce	120 m
Admin to Arts	75 m
Science to Commerce	80 m
Science to Arts	70 m
Commerce to Arts	60 m
Township to Main Campus	6 Km

Number of Computers in these blocks are given as:

Admin	100
Science	80
Commerce	50
Arts	20
City branch	60

(i) Draw economic cable laying out scheme to network computers in the main campus blocks.
Answer:
Finally

(ii) Which Topology is suggested in your layout scheme for main campus?
Answer:
Bus topology.

Commonly Made Error:
Misconception about advantages and disadvantages of various topologies may lead to a wrong answer

Answering Up:
Learn all prescribed topologies

(iii) Which block will be appropriate for Server in the main campus, give reason.
Answer:
Admin, reason – ‘It has the highest number of computers’

(iv) Suggest most reliable and low maintenance connection for the campus with its city branch in township.
Answer:
Fibre optic cable connection from any ISP

Commonly Made Error:
Students may get confused as to whether the networking is to be done within campus or outside the campus.

Answering Tip:
Optical fibre provides very high-speed links with minimum maintenance.