BLOSSOM PUBLIC SCHOOL
CLASS XII - Volume 2 (Set 1)
COMPUTER SCIENCE - (083)
Maximum Marks : 70 Time : 3 Hours
The question paper is divided into 3 sections – A, B and C
Section A, consists of 18 questions (1-18). Each question carries 1 mark.
Section B, consists of 7 questions (19-25). Each question carries 2 marks.
Section C, consists of 5 questions (26-30). Each question carries 3 marks.
Section D, consists of 3 questions (31-33). Each question carries 5 marks.
Section E, consists of 2 questions (34-35). Each question carries 4 marks.
Q.N Part
Question Marks
o No.
SECTION A
Each Question carries 1 marks 18 x 1= 18
1 Write the commands for DDL and DML
2 Write the commands for aggregate functions
3 Write the clause commands.
4 Write the constraints commands
5 ______ command is used to remove primary key from the table in SQL
(a) update (b)remove (c) alter (d)drop
6 ____________ commands will delete the table from MYSQL database?
(a) DELETE TABLE (b) DROP TABLE (c) REMOVE TABLE (d) ALTER TABLE
7 _________ is a non-key attribute, whose values are derived from the primary key of some other table.
(a) Primary Key (b) Foreign Key (c) Candidate Key (d) Alternate Key
8 The SELECT statement when combined with __________ clause, returns records without repetition.
(a) DESCRIBE (b) UNIQUE (c) DISTINCT (d) NULL
9 ______is a communication methodology designed to deliver both voice and multimedia
communications over Internet protocol.
(a) VoIP (b) SMTP (c) PPP (d)HTTP
10 Which function is used to display the total number of records from table in a database?
(a) sum(*) (b) total(*) (c) count(*) (d) return(*)
11 What will the following expression be evaluated to in python?
print(15.0/4+(8+3.0))
12 To establish a connection between Python and SQL database, connect() is used. Which of the following Page 1
, arguments may not necessarily be given while calling connect() ?
(a) host (b) database (c) user (d) password
13 Explain the use of ‘Foreign Key’ in a Relational Database Management System.
14 Write the full forms of the following:
(i) SMTP (ii) PPP
15 What is the use of TELNET?
16 Differentiate between count() and count(*) functions in SQL with appropriate example.
17 Differentiate between char() and varchar() in SQL with appropriate example.
18 Give one example for joins
SECTION B
Each Question carries 2 marks 7x2=14
19 What is difference between star topology and bus topology of network? 2
20 Differentiate between packet switching and message switching technique in network communication. 2
21 What is the difference between HTTP and FTP? 2
22 Write two advantages of using an optical fibre cable over an ethernet cable to connect two service 2
stations, which are 190 m away from each other.
23 Define the term firewall. 2
24 What is the difference between HTML and XML 2
25 What is the difference between Radio waves and Microwaves 2
SECTION C
Each Question carries 3 marks 5x3=15
26 3
What will be the output of the following statement?
mysql> Select Sid,Sna,Gna,Sch from Student Natural Join Sports;
Page 2
CLASS XII - Volume 2 (Set 1)
COMPUTER SCIENCE - (083)
Maximum Marks : 70 Time : 3 Hours
The question paper is divided into 3 sections – A, B and C
Section A, consists of 18 questions (1-18). Each question carries 1 mark.
Section B, consists of 7 questions (19-25). Each question carries 2 marks.
Section C, consists of 5 questions (26-30). Each question carries 3 marks.
Section D, consists of 3 questions (31-33). Each question carries 5 marks.
Section E, consists of 2 questions (34-35). Each question carries 4 marks.
Q.N Part
Question Marks
o No.
SECTION A
Each Question carries 1 marks 18 x 1= 18
1 Write the commands for DDL and DML
2 Write the commands for aggregate functions
3 Write the clause commands.
4 Write the constraints commands
5 ______ command is used to remove primary key from the table in SQL
(a) update (b)remove (c) alter (d)drop
6 ____________ commands will delete the table from MYSQL database?
(a) DELETE TABLE (b) DROP TABLE (c) REMOVE TABLE (d) ALTER TABLE
7 _________ is a non-key attribute, whose values are derived from the primary key of some other table.
(a) Primary Key (b) Foreign Key (c) Candidate Key (d) Alternate Key
8 The SELECT statement when combined with __________ clause, returns records without repetition.
(a) DESCRIBE (b) UNIQUE (c) DISTINCT (d) NULL
9 ______is a communication methodology designed to deliver both voice and multimedia
communications over Internet protocol.
(a) VoIP (b) SMTP (c) PPP (d)HTTP
10 Which function is used to display the total number of records from table in a database?
(a) sum(*) (b) total(*) (c) count(*) (d) return(*)
11 What will the following expression be evaluated to in python?
print(15.0/4+(8+3.0))
12 To establish a connection between Python and SQL database, connect() is used. Which of the following Page 1
, arguments may not necessarily be given while calling connect() ?
(a) host (b) database (c) user (d) password
13 Explain the use of ‘Foreign Key’ in a Relational Database Management System.
14 Write the full forms of the following:
(i) SMTP (ii) PPP
15 What is the use of TELNET?
16 Differentiate between count() and count(*) functions in SQL with appropriate example.
17 Differentiate between char() and varchar() in SQL with appropriate example.
18 Give one example for joins
SECTION B
Each Question carries 2 marks 7x2=14
19 What is difference between star topology and bus topology of network? 2
20 Differentiate between packet switching and message switching technique in network communication. 2
21 What is the difference between HTTP and FTP? 2
22 Write two advantages of using an optical fibre cable over an ethernet cable to connect two service 2
stations, which are 190 m away from each other.
23 Define the term firewall. 2
24 What is the difference between HTML and XML 2
25 What is the difference between Radio waves and Microwaves 2
SECTION C
Each Question carries 3 marks 5x3=15
26 3
What will be the output of the following statement?
mysql> Select Sid,Sna,Gna,Sch from Student Natural Join Sports;
Page 2
