Please refer to Class 12 Computer Science Sample Paper Term 2 With Solutions Set A provided below. The Sample Papers for Class 12 Computer Science have been prepared based on the latest pattern issued by CBSE. Students should practice these guess papers for class 12 Computer Science to gain more practice and get better marks in examinations. The Term 2 Sample Papers for Computer Science Standard 12 will help you to understand the type of questions which can be asked in upcoming examinations.
Term 2 Sample Paper for Class 12 Computer Science With Solutions Set A
1. Direction Read the following passage and answer the questions that follows
Mr. Rajeshwar has created a stack whose size is fixed for 10 elements and wants to perform some operations on it. He wants to push certain elements and pop some elements from it. He is confused about the operations and how the elements will behave on pushing and popping?
Help him to find the answers of the following questions.
(i) How many elements can he push more to the stack?
(ii) How many elements he needs to take out before “RolsRoyce” will come out?
(iii) If 3 elements are popped out and 2 pushed in , what will be the strength of the stack?
(iv) If “Tata” and “Datsun” are pushed to the initial stack respectively , which element will be popped out as a result of a pop operation now?
(v) If 2 elements are popped out and 4 pushed into the initial stack, how many times a loop needs to iterate to traverse the stack?
2. Write the name of benefits of networking.
Ans. Some of the benefits of networking are
(i) File sharing
(ii) Hardware sharing
(iii) Application sharing
(iv) User communication
(v) Access to remote database
Write any two uses of Internet.
Ans. Two uses of Internet are as follows
(i) Internet is used for communication and information sharing.
(ii) Business use the Internet to provide access to complex databases.
3. What do you understand by the term database?
Ans. A database is a huge collection of data accumulating in a particular system. It comprises of historical data, operational and transactional data. The database grows everyday with the transactions dealing with it.
A database has the following properties
(i) It is a collection of data elements representing real-world information.
(ii) It is logical, coherent and internally consistent.
What is a DBMS? Expand and explain in short.
Ans. A Database Management System is a software system that enables users to define, create and maintain the database and provides controlled access to this database.
The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient. Data in a database can be added, deleted, changed, sorted or searched, all using a DBMS.
4. Differentiate between ALTER and UPDATE commands in SQL.
Ans. Differences between ALTER and UPDATE commands in SQL are
How is char data type different from varchar data type?
Ans. Differences between char data type and varchar data type are
5. Which data will get added in table Company by following code?
con = mysql.connector.connect (
host = “localhost”,
user = “system”,
passwd = “hello”,
database = “connect”)
cur = con.cursor ( )
sql = “insert into Company
(Name, Dept, Salary)
values (%s, %s, %s)”
val = (“ABC”, “DBA”, 35000)
cur.execute (sql, val)
con.commit ( )
Ans. “ABC”, “DBA”, 35000
6. What is the use of baud rate?
Ans. Baud rate is a measure of the number of symbols (signals) transferred or line changes every second. It may represent more than one binary bit.
Every symbol can represent or convey one or several bits of data. For a binary signal of 20 Hz, this is equivalent to 20 baud.
A company wants to form a network on their five computers to a server within the company premises. Represent star and ring topologies diagrammatically for this network.
7. Trine Tech Corporation (TTC) is a professional consultancy company. The company is planning to set up their new offices in India with its hub at Hyderabad. As a network adviser, you have to understand their requirement and suggest them the best available solutions. Their queries are mentioned as (i) to (v) below.
Physical locations of the blocks of TTC
(i) Which will be the most appropriate block, where TTC should plan to install their server?
(ii) Draw a block to block cable layout to connect all the buildings in the most appropriate manner for efficient communication.
(iii) What will be the best possible connectivity out of the following, you will suggest to connect the new set up of offices in Bengalore with its London based office.
(a) Satellite Link
(iv) Which of the following device will be suggested by you to connect each computer in each of the buildings?
(v) Company is planning to connect its offices in Hyderabad which is less than 1 km. Which type of network will be formed?
Ans. (i) TTC should install its server in finance block as it is having maximum number of computers.
The above layout is based on minimum cable length required, which is 120 metres in the above case.
(iii) (a) Satellite Link
(iv) (a) Switch
Granuda consultants are setting up a secured network for their office campus at Faridabad for their day-to-day office and web based activities. They are planning to have connectivity between 3 buildings and the head office situated in Kolkata.
Answer the questions (i) to (v) after going through the building positions in the campus and other details, which are given below.
(i) Suggest the most suitable place (i.e. block) to house the server of this organisation. Also, give a reason to justify your suggested location.
(ii) Suggest a cable layout of connections between the building inside the campus.
(iii) Suggest the placement of the following devices with justification:
(iv) The organisation is planning to provide a high speed link with its head office situated in the Kolkata using a wired connection. Which of the following cable will be most suitable for this job?
(a) Optical fibre
(b) Co-axial cable
(c) Ethernet cable
(v) Consultancy is planning to connect its office in Faridabad which is more than 10 km from Head office. Which type of network will be formed?
Ans. (i) The most suitable place to house the server is JAMUNA because it has maximum number of computers.
(iii) (a) Switches are needed in every building to share bandwidth in every building.
(b) Repeaters may be skipped as per above layout, (because distance is less than 100 m) however, if building RAVI and building JAMUNA are directly connected, we can place a repeater there as the distance between these two buildings is more than 100 m.
(iv) (a) Optical fibre
8. Explain the role of database management system in maintaining huge volumes of data of different domains.
Explain your views using an example.
Ans. A database management system is a specialised software that helps maintain large volumes of data pertaining to a real life system . Examples of such systems include business houses , transport systems, libraries , schools etc.
It not only stores bulk data in structured way but also helps to add , modify ,search , update and delete data from such databases. Examples of DBMS softwares are MySQL , Microsoft SQL Server , Oracle etc.
Application program accesses the data stored in the database by sending request to the DBMS.
For example, MySQL, INGRES, MS-ACCESS etc.
The purpose of a Database Management System is to bridge the gap between information and data. The data stored in memory or on disk must be converted to usable information
A table “Sports” exists with 3 columns and 5 rows. What is its degree and cardinality? 2 rows are added to the table and 1 column deleted. What will be the degree and cardinality now?
Ans. The term degree refers to the total number of columns in a table. The term cardinality refers to the total number of rows in a table.
Initially, Sports table has 3 columns and 5 rows, so
Degree : 3
Cardinality : 5
After operations, 2 rows are added to the table and 1 column deleted.
Now, degree : 2 cardinality : 7.
9. Answer the questions (i) to (v) on the basis of the following tables SHOPPE and ACCESSORIES.
(i) To display Name and Price of all the Accessories in ascending order of their Price.
(ii) To display Id and SName of all Shoppe located in Nehru Place.
(iii) To display Minimum and Maximum Price of each Name of Accessories.
(iv) To display Name, Price of all Accessories and their respective SName, where they are available.
(v) To display name of accessories whose price is greater than 1000.
Ans. (i) SELECT Name, Price
ORDER BY Price;
(ii) SELECT Id, SName
WHERE Area = ‘Nehru Place’;
(iii) SELECT MIN(Price) “Minimum Price”,
MAX(Price) “Maximum Price”, Name
GROUP BY Name;
(iv) SELECT Name, Price, SName
FROM ACCESSORIES A, SHOPPE S
WHERE A.Id = S.Id;
but this query enable to show the result because
A.Id and S.Id are not identical.
(v) SELECT Name From
What is the differences between HAVING clause and WHERE clause?
Ans. Differences between HAVING clause and WHERE clause are