PRACTICE PAPER-1
Class - XII
COMPUTER SCIENCE
Μ.Μ.: 40
1. Answer the following:
(i) The number of columns in a table is known as the___of a table.
(ii) FTP stands for___.
(iii) The full form of LAN is___.
(iv) To add record in the table in SQL we use ___command.
(v) ___software is essential for protecting computers.
(vi) The full form of FIFO is___
(vii) To add element in a stack we use___ operation
(viii) ___is unit to measure speed of data transfer.
(ix) ___is a malicious software.
(x) ___is a device used for modulation and demodulation.
2. Answer the following:
(i) What is tuple?
(ii) What is zero division error?
(iii) What is the create table command in SQL?
(iv) Define alternate key.
3. Answer the following:
(i) What is primary key and candidate key?
(ii) Define MΑΝ.
(iii) Write <a>,<w>,<r>, <wb+> accessing modes.
(iv) What are tree and bus topologies?
(v) How to open and close a text file in Python? Write the syntax.
4. Answer the following:
(i) What are the components of communication system?
(ii) Define pickle module and load(), dump ()methods.
(iii) What is Stack? What are its operations?
(iv) Define index error, type error, value error, keyboard interrupt error.
OR
What is Queue? Write the operations of Queue?
□□
PRACTICE PAPER-2
Class - XII
COMPUTER SCIENCE
Μ.Μ.: 40
[Section - A]
1. What does SMTP stands for?
(a) secure mail transmission protocol
(b) simple mail transfer protocol
(c) server mail text protocol
(d) system maintenance and transmission protocol
2. Which SQL function is used to retrieve the maximum value from a given column?
(a) AVG ()
(b) MEAN()
(c) MAX ()
(d) COUNT()
3. Elements 2,7, 5 and 8 are entered in Stack. In what order will they remove?
(a) 2,7,5,8
(b) 5,7,2,8
(c) 2,5,8,7
(d) 8,5,2,7
4. Which of the following is not a valid mode to open a file in Python?
(a) ab
(b) rw
(c) r +
(d) w +
5. Full form of LAN
6. command is SQL is used to modify existing record.
7. A name Error occurs when division by zero takes place.(True/False)
8. Opening file in open() mode erase is the previous data.(True/False)
9. In the questions given below. two statements are given Assertion(A) and Reason (R)
Chonse the correct option for your answer
(a)Both A and correct and R is the correct. R is correct explanation of A
(b) Both A and R are correct and R is not the correct explanation of A.
(c) A is true but R is false
(d) A is false but R is true
(i) Assertion (A): In SQL, insert command is used to add new data in the database.
Reason(R): insert command is primarily used for updating existing records in a database.
(ii) Assertion (A): Antivirus software is essential for protecting computers.
Resaon (R): Anti-virus programs help to detect and remove harmful software from the computers.
[Section - B]
1. Name any two file processing modes in Python.
2. Define exception.
3. Define data.
4. Name any two network topologies.
[Section - C]
1. Wriite Syntax for following methods used for file operations in Python
(a) open()
(b) close()
2. What are the following built in functions in Python.
(a) zero division error
(b) index error
3. Explain the syntax of SUM() function.
4. Name the main components of data communication.
5. What is computer virus? Name any two computer virus.
6. Write a short note on
(a) http
(b) Bluetooth
7. (i) Rajat surf website to learn new things and play online games. One day he receives on his computer screen claiming that he has won a free gift card to his favourite online fore Excited Rajat clicks on the popup to claim his prize. What type of cyber security threat is Rajat most likely encountering in this scenario?
(a) Bluetooth
(b) virus
(c) spyware
(d) Adware,
4) Rohan is curious student who loves learning about different Lopes of communication technology. One dav he decides to research hon date is transmitted over the internet and devices through cables while exploring various online resources Rohan comes across some units by which we can also measure the speed of transmission.Which unit is used to ineasure the speed of data transfer?
(a) bytes per second
(b) hz
(c) khz
(d) Mbps.
[Section - D]
1. What is Queue Data Structure? Write a Python program to insert element in a Queue.
2 Explain primary key, alternate key, degree of relation.
3. Explain the following:
(a) router
(b) hub
(c) Gateway
PRACTICE PAPER-3
Class - XII
COMPUTER SCIENCE
Μ.Μ.: 40
1. Answers of following questions(2marks):
(i) What is FTP?
(ii) What is anti-virus?
(iii) Explain Star Topology.
(iv) What is firewall in computer networks?
(v) Explain Twisted Pair cable.
(vi) What is primary key and tuple?
OR
What is foreign key and degree?
(vii) Explain Ethernet card.
2. Answer the following questions(1marks):
(i) Write the full form of SQL.
(ii) What is the range of radio waves?
(iii) Define Bluetooth ?
(iv) What is Gbps ?
3. Answer the following(1marks):
(i) ___can act as primary key in the absence of primary key.
(ii) ___is the number of rows (records) in a table.
(iii) A table is also called____
(iv) Full form of DBMS is___
(v) ___is a popular anti-virus.
(Vi) PAN can cover an area around___
(vii) Full form of WLAN is___
(viii) Attribute is also called___
(ix) DBMS is the network. (True/False)
(x) PPP is known as Personal Protected Protocol. (True/False)
4. Explain the following questions(4marks):
(i) Explain the types of data communication.
(ii) Explain TCP/IP and SMTP.
(iii) Explain optical fibre and co-axial cable.
OR
Write the SQL statement
(a) create table (b) insert into
No comments:
Post a Comment