CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions

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

CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions

Time: 2 Hours
Maximum Marks: 35

General Instructions:

  • Question paper is divided into 5 sections A ,B,C,D & E
  • In section A question number 1 to 3 are Very Short Answer type questions. Attempt any 3 questions.
  • In section B question number 4 is Source based question.
  • In section C question number 5 & 6 are Short Answer based questions.
  • In section D question number 7 to 9 are Long Answer based questions.
  • In section E question number 10 is a Map based question.

Section – A
                   (Very Short Answer Type Questions) (2 x 3 = 6)

Attempt all questions:

Question 1.
Explain the prominent features of Traditional Large Scale industrial regions. [2]
Answer:
Traditional industrial regions can be recognized by:

  1. High proportion of employment in the manufacturing industry. High-density housing, often of inferior type, and poor services. Unattractive environment, for example, pollution, waste heaps, and so on.
  2. Problems of unemployment, emigration and derelict land areas caused by closure of factories.

Question 2.
Define Tertiary Activities. [2]
Answer:
Tertiary activities involve the commercial output of services rather than the production of tangible goods. Common examples are the work of a plumber, electrician, technician, launderer, barber, shopkeeper, driver, cashier, teacher, doctor, lawyer and publisher, etc.

CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions

Question 3.
Differentiate between retail trading and wholesale trading. [2]
OR
Differentiate between departmental stores and chain stores. [2]
Answer:
The difference between retail trading and wholesale trading.

  1. The business activity concerned with the sale of goals directly to the consumers is known as the retail trading, while the business that constitutes bulk business through numerous intermediately merchants and supply houses is known as the wholesale trading.
  2. Most of the retail trading takes place in fixed establishments or stores solely devoted to selling while a wholeseller need not have a showroom or shop in central place.

OR

  1. Departmental stores delegate the responsibility and authority to departmental heads for purchasing of commodities, while chain stores can purchase merchandise most economically, often going so far as to direct the goods to be manufactured to their specifications.
  2. Departmental stores deals with large variety of goods offering for retail sale while chain stores are retail outlets in various location under same brand and management.

Section – B
(Source Based Question) (3 x 1 = 3)

Question 4.
‘Manufacturing Industry’
Manufacturing means ‘to make by hand’. However, now it includes goods ‘made by machines’. It is essentially a process which involves transforming raw materials into finished goods of higher value for sale in local or distant markets. Conceptually, an industry is a geographically located manufacturing unit maintaining books of accounts and records under a management system. As the term industry is comprehensive, it is also used as synonymous with ‘manufacturing’. When one uses terms like ‘steel industry’ and ‘chemical industry’, one thinks of factories and processes. But there are many secondary activities which are not carried on in factories such as what is now called the ‘entertainment industry’ and ‘Tourism industry’, etc. So for clarity, the longer expression ‘manufacturing industry’ is used.

Attempt all questions:

Question 4.1
What do you understand by the term Manufacturing? [1]
Answer:
Manufacturing literally means ‘to make by hand’. However, now it includes goods ‘made by machines’.

CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions

Question 4.2
“Manufacturing involves value addition.” Explain with a suitable example. [1]
Answer:
It is essentially a process which involves transforming raw materials into finished goods of higher value. Example-Raw cotton is transformed to more valuable threads and then threads are further transformed into more valuable fabric.

Question 4.3
Name two industries that provide services rather than production of goods. [1]
Answer:
The ‘Entertainment industry’ and ‘Tourism industry’.

Section – C
(Short Answer Type Questions) (2 x 3 = 6)

Question 5.
“Road transport plays a vital role in the promotion of trade and tourism in the world.” Support this statement with three suitable arguments. [2]
Answer:
Transport is a service or facility by which people, materials and manufactured goods are physically carried from one location to another. It is an organized industry created to satisfy man’s basic need of mobility.

  •  Modern society requires speedy and efficient transport systems to assist in the production, distribution and consumption of goods.
  • At every stage in this complex system, the value of the material is significantly enhanced by transportation.
  • The opening-up of tourist areas have been aided by improvement in transport facilities. Travel is easier by car, with better road systems.

CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions

Question 6.
Satellites and computers have brought revolutionary changes in the present life of the people. Elaborate the statement with three suitable examples. [2]
OR
Evaluate the role and importance of roads in the economic development of India? [2]
Answer:
Satellites touch human lives in many ways. Every time we use a cell phone to call a friend, send an SMS or watch a popular programme on cable television, we are using satellite communication. These have rendered the unit cost and time of communication invariant in terms of distance.

(i) Today weather forecasting through television is a boon in saving the loss of life and property.

(ii) As billions use the Internet each year, cyberspace will expand the contemporary economic and social space of humans through email, e-commerce, e-learning and e-governance.

(iii) The Internet together with fax, television and radio will be accessible to more and more people cutting across place and time.

(iv) It is these modern communication systems, more than transportation, that has made the concept of global village a reality.

OR

India has the 2nd largest road network in the world.

Importance of Roadways in India:

(i) It provides better connectivity between rural and urban areas and hence the advancement of rural India occurs.

(ii) To link every remotest area (J&K, North-east part, mountainous regions, etc.) with the mainstream of economy it’s very much important to have better connectivity so that the overall development of those people can be ensured.

(iii) Road connectivity is very important in linking Intra-state urban areas and Inter-states for better transportation of various goods and services and hence for overall development in terms of saving time, money etc and reduction in pollution and CO2 emission level.

(iv) Better Roadways allows faster accessibility of health, education and other facilities and services.

(v) Indian roadways serve as the lifeline of Indian trade, as they connect consumers with producers. For example; rural centers are producers of agricultural goods which are transported through roadways to consumers, i.e., urban centers.

Section – D
(Long Answer Type Questions) (3 x 5 = 15)

Question 7.
How do Quaternary services differ from Tertiary services? Give three reasons why the service sector in developing and developed countries is growing faster than the manufacturing sector? [5]
Answer:
The activities which involve intangible outputs and are relatively attached from material products such as the services of a technician or a teacher are referred to as Tertiary activities. The activities concerning knowledge such as education, information, research and development and more intellectual activities where the major task is to think, research and develop ideas are Quaternary activities.

(i) The rising per capita income in both, developed and developing countries has generated proportionately larger increases in the many kinds of services.

(ii) There is also demand for educational services at all levels with the increase in the demand for literacy and computer skills at the workplace.

(iii) Demand for non-direct production workers is also increasing proportionally in most manufacturing companies as these companies need more clerical staff, salespeople, research and other workers.

(iv) Medical services have also increased in Europe, North America and Japan because of an increase in demand for medical care from the elderly population.

(v) The increasing value of time has led to more household functions being accomplished outside of the home.

CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions

Question 8.
How is the use of plastic bags harmful for environmental degradation? Evaluate it by citing suitable reasons. [5]
OR
The disposal of urban waste has become a serious concern for the local authorities. Analyze the statement with suitable examples. [5]
Answer:
Plastic is a non-biodegradable substance and its use and production should be minimum. Plastic debris is found everywhere, from the Arctic to Antarctica. It clogs street drains in our cities; it litters campgrounds and national parks, and is even piling up on Mount Everest. Thanks to runoff, and to our fondness for directly dumping our trash into the nearest river or lake, plastic is growing increasingly common in the world’s oceans. When plastics are broken down, this simply means one large piece of plastic is reduced into a bunch of smaller pieces of plastic.

These smaller pieces of plastic can be consumed by smaller animals, but are still indigestible. It affects all organisms in the food chain from tiny species like plankton to whales. Toxins work their way up the food chain when plastic is ingested and can even be present in the fish people eat. From cell phones to bicycle helmets to IV bags, plastic has molded society in ways that make life easier and safer. But the synthetic material has also left its harmful imprints on the environment.

(i) Chemicals added to plastics are absorbed by human bodies. Some of these compounds have been found to alter hormones or have other potential human health effects.

(ii) Plastic debris, laced with chemicals, is often ingested by marine animals, which injured and poison wildlife.

(iii) Floating plastic waste, which can survive for thousands of years in water, serves as mini transportation devices for invasive species, disrupting habitats.

(iv) Plastic buried deep in landfills can leach harmful chemicals that spread into groundwater.

(v) Around 4 percent of world oil production is used as a feedstock to make plastics, and a similar amount is consumed as energy in the process.

OR

The problem of the overcrowded, congested and insufficient infrastructure of urban areas results in the accumulation of huge urban waste. There are two sources of urban waste- Household or domestic sources and industrial or commercial sources. The mismanagement of urban waste disposal is a serious problem in big cities.

(i) Tons of waste come out daily in metropolitan cities and is burnt. The smoke released from the waste pollutes the air.

(ii) Lack of sewers or other means to dispose of human excretes safely and the inadequacy of garbage collection sources adds to water pollution.

(iii) The concentration of industrial units in and around urban centres gives rise to a series of environmental problems. Dumping industrial waste into rivers is the major cause of water pollution. The solid waste generation continues to increase in both absolute and per capita in cities.

(iv) This improper disposal of solid waste attracts rodents and flies which spread diseases. The thermal plants release a lot of smoke and ash in the air. For example, a plant producing 500mw electricity releases 2000 tons of ash which is difficult to manage.

(v) In most cities and towns, about 30 to 50 percent of the waste generated is left uncontrolled which accumulate on streets, in open spaces between houses and in wastelands leading to serious health hazards.

Question 9.
Attaining Sustainable development in the command area requires major thrust upon the measures to achieve ecological sustainability. Highlight the measures proposed to promote sustainable development in the command area of Indira Gandhi Rajasthan Canal. [5]
Answer:
Seven measures proposed to promote sustainable development in the command area are meant to restore ecological balance.

(i) The first requirement is strict implementation of water management policy. The canal project envisages protective irrigation in Stage-I and extensive irrigation of crops and pasture development in Stage-II.

(ii) In general, the cropping pattern shall not include water intensive crops. It shall be adhered to and people shall be encouraged to grow plantation crops such as citrus fruits.

(iii) The CAD programmes such as lining of water courses, land development and leveling and warabandi system (equal distribution of canal water in the command area of outlet) shall be effectively implemented to reduce the conveyance loss of water.

(iv) The areas affected by water logging and soil salinity shall be reclaimed.

(v) The eco-development through afforestation, shelterbelt plantation and pasture development is necessary particularly in the fragile environment of Stage-II.

(vi) Social sustainability in the region can be achieved only if the land allottees having poor economic background are provided adequate financial and institutional support for cultivation of land.

(vii) The economic sustainability in the region cannot be attained only through the development of agriculture and animal husbandry. The agricultural and allied activities have to develop along with other sectors of the economy. This shall lead to diversification of economic base and establishment of functional linkages between basic villages, agro-service centers and market centers.

Section – E
(Map Based Question) (1 x 5 = 5)

Question 10.
On the outline map of India indicate and mark the following features (Attempt any 5).
(A) Iron ore mines of Chhattisgarh [1]
Answer:
Bailadila

(B) Oil Refinery located in Uttar Pradesh. [1]
Answer:
Mathura

(C) The largest Lignite coal mines. [1]
Answer:
Neyveli, Tamil Nadu

CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions

(D) Easternmost terminal of East-West Corridor. [1]
Answer:
Silchar

(E) Southernmost Metropolitan city connected by Golden Quadrilateral. [1]
Answer:
Chennai

(F) Oldest Copper mines of Rajasthan. [1]
Answer:
Khetri
CBSE Sample Papers for Class 12 Geography Term 2 Set 1 with Solutions 1

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

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

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

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 7, 8 and 12.

Section – A
(2 Marks Each)

Question 1.
Write equivalent postfix expressions for the following infix expression : a+b*d = (a+(b*d))

Question 2.
(a) Expand the following:
ARPANET, MAN

(b) Which device is used to connect all computers to the Internet using telephone wire?

Question 3.
What is the need of DBMS? HD

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

Question 4.
List the most common parameters and the usage that are passed to communicate with the database.

Question 5.
Write the output (a) to (d) based on the table, CABHUB given below:
Table: CABHUB

Vode VehicleName Make Colour Capacity Charge
100 Innova Toyota White 7 15
102   SX4 Suzuki Blue 4 14
104 C Class Mercedes Red 4 35
105 A-Star Suzuki White 3 14
108 Indigo Tata Silver 3 12

(a) SELECT SUM(Charges) FROM CABHUB WHERE Capacity>3;

(b) SELECT MIN(Capacity) FROM CABHUB;

(c) SELECT VehicleName, Colour FROM CABHUB WHERE Capacity>5 AND Make LIKE “T%”;

(d) SELECT Make FROM CABHUB WHERE Colour IN (“BLUE”, “RED”);

Question 6.
(a) Which declaration represents that “character data will consume the same number of bytes as
declared and is right padded”?

(b) Name any two DDL commands.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

Question 7.
Consider the table, BOOK given below:
TABLE BOOK

CODE BNAME TYPE
F101 The Priest Fiction
L102 German easy Literature
C101 larzan in the lost world Comic
F102 Untold Story Fiction
C102 War heroes Comic

(a) Identify the degree and cardinality of the table.

(b) Which field should be made the primary key? Justify your answer

OR

(a) Identify the candidate key(s) from the table BOOK.

(b) Consider the table AUTHOR, whose fields are A_ID, CODE, N AME
Which field will be considered as the foreign key if the tables BOOK and AUTHOR are related in a database?

Section – B
(3 Marks Each)

Question 8.
Write an algorithm to implement push operation and pop operation.

OR

Siya has created a dictionary containing names and salary as key value pairs of 5 employees.
Write a program, with separate user defined functions to perform the operation as Push the keys (name of the employee) of the dictionary into a stack, where the corresponding value (salary) is greater than 25000 and also perform the operation as Pop and display the content of the stack.
For example:
If the sample content of the dictionary is as follows:
details = {“Rahul”:25000, “Jai”:45000, “Kinshu”:20000, “Riya”:18000, “Anu”:28000}
The output from the program should be:
Anu Rahul

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

Question 9.
(a) What are all the domain names possible in gender?

(b) Differentiate between cardinality and degree of a table with the help of an example.

Question 10.
Write a Python code to insert following records into table Orders as follow:
Database → Sales
userid → Salesmanl password → orders
Table: Orders

ORDNUMB CUSTNO ORDDTE
12489 124 01-03-98
12491 311 10-3-98
12495 315 31-03-98
12498 522 10-4-98

Section – C
(4 Marks Each)

Question 11.
Write query (a) to (d) based on the tables, ACTIVITY and COACH given below:
Table: ACTIVITY

ACode Activity Name Stadium Participants Num Prize Money Schedule Date
1001 Relay 100 x 4 Star Annex 16 10000 23-Jan-2004
1002 High Jump Star Annex 10 12000 12- Dec-2003
1003 Shot Put Super Power 12 9000 01-Jan-2004
1005 Long Jump Star Annex 12 9000 01-Jan-2004
1008 Discuss Throw Super Power 10 15,000 19-Mar-2004

Table: COACH

PCode Name ACode
1 Ahmad Hussain 1001
2 Ravinder 1008
3 Janila 1001
4 Naaz 1003

(a) To display the names of all activities with their Acodes in descending order.

(b) To display sum of PrizeMoney for the Activities played in each of the Stadium separately.

(c) To display the coach’s name and acodes in ascending order of Acode from the table Coach.

(d) To display the activity name and coach name whose participants are more than 15.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

Question 12.
(a) What is URL? Identify the domain name and URL from the following:
http://www.income.in/home.aboutus.html

OR

Write the features of Gateways in networking.
(b) Distinguish between MAN and WAN.

Question 13.
Rovenza Communications International (RCI) is an online corporate training provider company for IT related courses. The company is setting up their new campus in Kolkata. You as a network expert have to study the physical locations of various blocks and the number of computers to be installed. In the Physical Location of the building of RCI computers to be installed. In the
possible answers for the queries (i) to (iv) raised by them.
CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice 1
Block to block distance (in Mtrs)

From To Distance
Administrative Building Finance Building 60
Administrative Building Faculty Studio 120
Finance Building Faculty Studio Building 70

Expected computers to be installed in each block
(a) Suggest the most appropriate block, where RCI should plan to install the server.

(b) Name the topology that form to connect all three blocks for efficient communication.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 10 for Practice

(c) Which type of network out of the following is formed by connecting the computers of these three blocks?

  • LAN
  • MAN
  • WAN

(d) Which wireless channel out of the following should be opted by RCI to connect to students from all over the world?

  • Infrared
  • Microwave
  • Satellite

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 9 for Practice

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

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 9 for Practice

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 7, 8 and 12.

Section – A
(2 Marks Each)

Question 1.
Evaluate the following postfix notation of expression,show status of stack after every operation. 12,2,4 34,20,-, +, 5, +

Question 2.
(a) Expand the following:
HTTPS, POP3

(b) Which device is used to connect all computers inside a lab?

Question 3.
Name the keys used in DBMS.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 9 for Practice

Question 4.
What is a cursor? Also, write a checklist before connecting to a database.

Question 5.
Write the output of the queries (a) to (d) based on the table, RESORT given below:
Table: RESORT

RCODE PLACE RENT TYPE STARTDATE
R001 GOA 15000 5 STAR 12-Jan-02
R002 HIMACHAL 9000 4 STAR 20-Dec-07
R003 KERALA 12500 5 STAR 10-Jan-06
R004 HIMACHAL 10500 2 STAR 25-Jan-05
R005 GUJARAT 8000 4 STAR 01-Jan-03
R006 GOA 18000 7 STAR 30-Jan-08
R007 ORISSA 7500 2 STAR 12-Jan-99
R008 KERALA 11000 5 STAR 03-Jan-03
R009 HIMACHAL 9000 2 STAR 15-Jan-08
R010 GOA 13000 5 STAR 12-Jan-06

(a) SELECT PLACE FROM RESORT WHERE RENT>15000;

(b) SELECT RCODE, TYPE FROM RESORT WHERE PLACE LIKE ‘%CHAL’;

(c) SELECT MAX (RENT) FROM RESORT;

(d) SELECT DISTINCT TYPE FROM RESORT;

Question 6.
(a) What is the maximum length of the char columns?

(b) “Numeric Data” is used to store, what type of value?

Question 7.
Observe the table, CLUB given below:
Table: CLUB

Member_ID Member_Name Address Age Fee
M0001 Sumit New Delhi 20 2000
M0002 Nisha Gurgaon 19 3500
M0003 Niharika New Delhi 21 2100
M0004 Sachin Faridabad 18 35000

What is the Cardinality and Degree of the given table?
If a new column Contact No is added and three more members join the club then how these changes will affect the degree and cardinality of the table.
OR
Identify the primary key of table CLUB.
Identify the candidate key(s) of table CLUB.

Section – B
(3 Marks Each)

Question 8.
Write a Python program to check if a string is a palindrome or not.

OR

What are infix, prefix, postfix notations? Also, convert following infix to postfix notation.
((A+B)*C/D+Et)/G

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 9 for Practice

Question 9.
(a) A table CUSTOMER has 10 columns but no row. Later, 10 new rows are inserted and 3 rows are
deleted in the table. What is the degree and cardinality of the table CUSTOMER?

(b) Define the following:
Equi-Join, Natural Join

Question 10.
Write a Python code to create a table EMPLOYEE, whose fields with their data type are

  • FIRST_NAME CHAR(20) NOT NULL
  • LAST_NAME CHAR(20)
  • AGE INT
  • SEX CHAR(l)
  • INCOME FLOAT

Section – C
(4 Marks Each)

Question 11.
Write queries (a) to (d) based on the tables, WORKER and PAYLEVEL given below:
Table: WORKER

ECODE NAME DESIGN PLEVEL DOJ DOB
11 Radhe Shyam Supervisor P001 13-Sep-2004 23-Aug-1981
12 Chander Nath Operator P003 22-Feb-2010 12-Jul-1987
13 Fizza Operator P003 14-Jun-2009 14-Oct-1983
15 Ameen Ahmed Mechanic P002 21-Aug-2006 13-Mar-1984
18 Sanya Clerk P002 19-Dec-2005 09-Jun-1983

Table: PAYLEVEL

PLEVEL PAY ALLOWANCE
P001 26000 12000
P002 22000 10000
P003 12000 6000

(a) To display the name of all Workers in descending order of DOB.

(b) To display NAME and DESIGN of those Workers, whose PLEVEL is either P001 or P002.

(c) To display the content of all the worker table, whose DOB is in between T9-JAN-1984′ and ’18- JAN-1987′.

(d) To display name of workers with their allowance whose pay is more than 20000.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 9 for Practice

Question 12.
(a) Define microwave transmission media.
OR
What is Hypertext Transfer Protocol?

(b) Give any four differences between LAN and MAN.

Question 13.
Software Development Company has set up its new center at Raipur for its office and web based activities. It has 4 blocks of building named Block A, Block B, Block C, Block D.
Number of Computers

Block A 25
Block B 50
Block C 125
Block D 10

Shortest distances between various Blocks in meters:

Block A to Block B 60
Block B to Block C 40
Block C to Block A 30
Block D to Block C 50

(a) Name the most suitable block where the server should be installed.

(b) Suggest the type of network to connect all the blocks with suitable reason.

(c) The company is planning to link all the blocks through secure and high-speed wired medium. Suggest a way to connect all the blocks.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 9 for Practice

(d) Suggest the most suitable wired medium for efficiently connecting each computer installed in every block out of the following network cables:

  • Coaxial Cable
  • Ethernet Cable
  • Single Pair Telephone Cable

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice

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

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice

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 7, 8 and 12.

Section – A
(2 Marks Each)

Question 1.
Explain any one example of stack.

Question 2.
(a) Expand the following:
HTTE IRC

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice

(b) Neha wants to transfer data within a city at very high speed. Write the wired transmission medium and type of network.

Question 3.
What keys are used in DBMS?

Question 4.
What is a database connection? How is a database connection established?

Question 5.
Write the output of the queries (a) to (b) based on the table, Teacher given below
Table: Teacher

T_ID Name Age Department Date_of_join Salary Gender
1 Jugal 34 Computer Sc 10/01/2017 12,000 M
2 Sharmila 31 History 24/03/2008 20,000 F
3 Sandeep 32 Mathematics 12/12/2016 30,000 M
4 Sangeeta 35 History 01/07/2015 40,000 F
5 Rakesh 42 Mathematics 05/09/2007 25,000 M
6 Shyam 50 History 27/06/2008 30,000 M
7 Shiv Om 44 Computer Sc 25/02/2017 21,000 M
8 Shalakha 33 Mathematics 31/07/2018 20,000 F

(a) SELECT Name FROM Teacher WHERE Salary>2 5000 ;

(b) SELECT Name, Department FROM Teacher WHERE Department LIKE ‘%Sc’;

(c) SELECT T_ID, Department FROM Teacher WHERE Gender = ‘F’;

(d) SELECT DISTINCT Department FROM Teacher;

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice

Question 6.
(a) Which declaration doesn’t use the same number of bytes and consumption of bytes depend on the
input data?

(b) Write any two aggregate function used in SQL.

Question 7.
Consider the table, STUDENT given below:
Table: STUDENT

Admn. No. Roll No. Name Class Makrs
2715 1 Ram 12 90
2716 2 Ajay 11 98
2811 3 Jayesh 12 98
2914 4 Tarun 11 94

(a) Which field should be made the primary key? Justify your answer.

(b) Identify the degree and cardinality of given table.

OR

(a) Identify the candidate key(s) of table STUDENT.

(b) Identify the alternate key of table STUDENT

Section – B
(3 Marks Each)

Question 8.
Write an algorithm to evaluate postfix expression.

OR

Riya has a list containing 8 integers. You need to help her create a program with separate user defined functions to perform the following operations based on this list.

  • Traverse the content of the list and push the odd numbers into a stack.
  • Pop and display the content of the stack.

For Example:
If the sample Content of the list is as follows:
Listl = [26,45,89,32,44,61,41,99]
Sample Output of the code should be:
99 41 61 89 45

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice

Question 9.
(a) What is the default format for “Datetime” &”Timestamp” data type?

(b) Define Equi join.

Question 10.
Consider the following table, Emp given below:
Table: Emp

EmpNo EmpName Job Mgr Hiredate Sal DeptNo
7839 Mahesh President 7872 17/11/01 5,000 10
7698 Krishna Manager 7839 01/5,81 2,600 25
7872 Anubhav Manager 7839 31/3/83 2,700 30
7566 Siddhant Manager 7839 23/6/82 2650 15
7564 Arnav Asst. Manager 7698 18/7/81 1,000 25
7560 Khyati Receptionsit 7872 21/2/84 1,000 30

Write Python code to insert 2 records with suitable data in the above table taking system date as Hiredate.

Section – C
( 5 Marks Each)

Question 11.
Write SQL queries for (a) to (d) on the basis of table, ITEMS and TRADERS given below:
Table: ITEMS

CODE INAME QTY PRICE COMPANY TCODE
1001 DIGITAL PAD 12i 120 11,000 XENTA T01
1006 LED SCREEN 40 70 38,000 SANTORA T02
1004 CAR GPS SYSTEM 50 21,500 GEOKNOW T01
1003 DIGITAL CAMERA 12X 160 8,000 DIGICLICK T02
1005 PEN DRIVE 32 GB 600 1,200 STOREHOME T03

Table: TRADERS

TCODE TNAME CITY
T01 ELECTRONIC SALES MUMBAI
T03 BUSY STORE CORP DELHI
T02 DISP HOUSE INC CHENNAI

(a) To display the details of all the items in ascending order of item names (i.e., INAME).

(b) To display item name and price of all those items,whose price is in the range of 10000 and 22000 (both values inclusive).

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice

(c) To display the number of items, which are traded by each trader. The expected output of this query should be:
T01 2 T02 2 T03 1

(d) To display item names and traders name from both tables who are in Delhi.

Question 12.
(a) Name the protocol:

  • Used to transfer voice using packet switched network.
  • Used for chatting between two groups or between two individuals.

OR

What is web hosting?
(a) What is ARPANET?

Question 13.
Uplifting Skills Hub India is a knowledge and skill community which has an aim to uplift the standard of knowledge and skills in the Society. It is planning to setup its training centers in multiple towns and villages pan India with its head offices in the nearest cities. They have created a model of their network with a city, a town and 3 villages as follows:

As a network consultant, you have to suggest the best network related solutions for their issues/problems raised in (a) to (b) keeping in mind the distance between various locations and given parameters.
CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice 1

Shortest distance between various location:

VILLAGE 1 to B_TOWN 2 KM
VILLAGE 2 to B_TOWN 1.0 KM
VILLAGE 3 to B_TOWN 1.5 KM
VILLAGE 1 to VILLAGE 2 3.5 KM
VILLAGE 1 to VILLAGE 3 4.5 KM
VILLAGE 2 to VILLAGE 3 2.5 KM
A_CITY Head Office to B HUB 25 KM

Number of Computers installed at various locations are as follows:

BTOWN 120
VILLAGE 1 15
VILLAGE 2 10
VILLAGE 3 15
A_CITY Head OFFICE 6

Note:

  •  In Villages, there are community centres, in which one room has been given as training centre to this organization to install computers.
  • The organization has got financial support from the government and top IT companies.

(a) Suggest the most appropriate location of the SERVER in the the B_HUB out of the 4 locations), to get the best and effective connectivity. Justify your answer.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 8 for Practice

(b) Suggest the best wired medium and draw the cable layout (location to location) to efficiently connect various locations within the B_HUB.

(c) Which hardware device will you suggest to connect all the computers within each location of B_HUB?

(d) Which service/protocol will be most helpful to conduct live interactions of Experts from Head Office and people at all locations of B_HUB ?

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 for Practice

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

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 for Practice

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 7, 8 and 12.

Section – A
(2 Marks Each)

Question 1.
Define the term Overflow and Underflow in stack.

Question 2
(a) Expand the following:
WWW, RJ45

(b) XYZ company is planning to connect all computers, each spread over a distance of 50 meters. Suggest an economic cable type having high speed data transfer to connect these computers.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 for Practice

Question 3.
Define Database Management System.

Question 4.
Consider the following statement: db.rollback()
(a) What is the function of this statement in a program?

(b) Name the method when, rollback() method can be used to retrieve the original data that was changed through that method.

Question 5.
Write the output of the queries (a) to (d) based on the table, TRIP given below:
Table: TRIP

No Name TDATE KM TCODE NOP
11 Tanish Khan 2015-12-13 200 101 32
13 Danish Sahai 2016-06-21 100 103 45
15 Ram Kumar 2016-02-23 350 102 42
12 Fen Shen 2016-01-13 90 102 40
17 Aan Kumar 2015-02-10 75 104 2
14 Veena 2016-06-28 80 105 4
16 Raj pal Kirti 2016-06-06 200 101 25

Note :
NO is Driver Number
(a) SELECT NAME FROM TRIP WHERE KM>100;

(b) SELECT SUM (NOP) FROM TRIP WHERE TCODE=102;

(c) SELECT MAX (KM) FROM TRIP;

(d) SELECT * FROM TRIP WHERE NAME LIKE ‘%Kumar%’;

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 for Practice

Question 6.
(a) Explain the degree of table.

(b) Which clause is used to remove the duplicating rows of the table?

Question 7.
Consider the table PERSON given below:
Table: PERSON

Name BankA/CNum AadharNum
Rahul 1290889909 1800991222
Gopal 1909090909 1908909090
Bhavish 1902090909 8298291282

(a) Differentiate between the primary key and alternatekey.

(b) Identify the primary key of given table.

OR

(a) Identify the candidate key(s) of table PERSON.

(b) Identify the alternate key of table PERSON.

Section – B
(3 Marks Each)

Question 8.
Write a program to implement a stack for these book details (book no, book name). That is, now each item node of the stack contains two types of information -a book no and its name. Just implement push and display operations.

OR

Convert the following infix into postfix form using stack.
(True AND False) OR (False AND True)

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 for Practice

Question 9.
(a) In SQL, write the query to display the current Date and Time.

(b) Give Some examples of integrity constraints.

Question 10.
Write Python code to insert following records into the order details table.
Database → sales
Userid → Admin Password →salAd345 table name OrderDetails

ORDNUMB RARTNUMS NUMBORD QUOTPRIC
12489 AX12 11 14.95
12491 BT04 1 402.99
12492 BZ66 1 311.95
12498 CX11 2 57.95

Section – C
(4 Marks Each)

Question 11.
Write queries (a) to (d) based on tables, SCHOOL and ADMIN given below: IBB
Table: SCHOOL

CODE TEACHER SUBJECT DOJ PERIODS EXPERIENCE
1001 RAVI

SHANKAR

ENGLISH 12/3/2000 24 10
1009 PRIYA RAI PHYSICS 03/09/1998 ! 26 12
1203 LIS ANAND ENGLISH 90/04/2000 27 5
1045 YASHRAJ MATHS 28/8/2000 24 15
1123 GAGAN PHYSICS 16/7/1999 ! 28 3
1167 1 lansh B Chemistry 19/10/1999 | 27 5
1215 Umesh Physics 11/05/1998 i 22 16

Table: ADMIN

CODE Gender Designation
1001 Male Vice Principal
1009 Female Co-ordinator
1203 Female Co-ordinator
1045 Male HOD
1123 Male Senior Teacher
1167 Male Senior Teacher
1215 Male HOD

(a) To display TEACHERNAME, PERIODS of all teachers whose periods are more than 25.

(b) To display all the information from the table SCHOOL in descending order of experience.

(c) To display DESIGNATION without duplicate entries from the table ADMIN.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 for Practice

(d) To display TEACHERNAME, CODE and corresponding DESIGNATION from tables SCHOOL and ADMIN of Male teachers.

Question 12.
(a) Differentiate between Web server and web browser. Write any two popular web browsers.
OR
Write one advantage of star topology of network. Also, illustrate how five(5) computers can be connected with each other using star topology of network.

(b) What is an IP address?

Question 13.
ABC is professional consultancy company. The company is planning to set up their new offices in India with its hub at Bengaluru. As a network adviser, you have to understand their requirement and suggest them the best available solutions.
Their queries are mentioned as (a) to (d) below:
Block to Block distances (in Mtr):

Block (From) Block (To) Distance
Human Resource Conference 110
Human Resource Finance 40
Conference Finance 80

Expected Number of computers to be installed in each block:

Block Computers
Human Resource 25
Finance 120
Conference 90

(a) What will be the most appropriate block,where ABC should plan to install their server?

(b) Draw a block diagram showing cable layout to connect all the buildings in the most appropriate manner for efficient communication.

CBSE Sample Papers for Class 12 Computer Science Term 2 Set 7 for Practice

(c) What will be the best possible connectivity out of the following, you will suggest to connect the new setup of offices in Chennai with its London based office.

  • Satellite link
  • Infrared
  • Ethernet cable

(d) Which of the following device will be suggested by you to connect each computer in each of the buildings?

  • Switch
  • Modem
  • Gateway