Questions – Exam Papers – Computer Sir Ki Class

Login


Lost your password?

Don't have an account ?
Register (It's FREE) ×
  


Shop
siteicon
Question Typewise Collection-"Identification" Questions - Exam Papers (CPP) siteicon No. of Q.9
Q.1   Exam - CBSE12D-2017/C05A/2

Observe the following table CANDIDATE carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT ? Also, find the Degree and Cardinality of the RESULT.

TABLE: CANDIDATE

NO NAME STREAM
C1 AJAY LAW
C2 ADITI MEDICAL
C3 ROHAN EDUCATION
C4 RISHAB ENGINEERING

RESULT

NO NAME
C3 ROHAN


Q.2   Exam - CBSE12A-2015/C07F/1

Out of the following, which all comes under cyber crime?
(i) Stealing away a brand new hard disk from a showroom.
(ii) Getting in someone’s social networking account without his consent and posting on his behalf.
(iii) Secretly copying data from server of a organization and selling it to the other organization.
(iv) Looking at online activities of a friends blog.



Q.3   Exam - CBSE12A-2015/C05A/2

Observe the following table carefully and write the names of the most appropriate columns, which can be considered as (i) candidate keys and (ii) primary key.

Code Item Qty Price Transaction Date
1001 Plastic Folder 14” 100 3400 2014-12-14
1004 Pen Stand Standard 200 4500 2015‐01‐31
1005 Stapler Mini 250 1200 2015-02-28
1009 Punching Machine Small 200 1400 2015-03-12
1003 Stapler Big 100 1500 2015-02-02


Q.4   Exam - CBSE12A-2017/C05A/2

Observe the following table MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT. Also, find the Degree and Cardinality of the RESULT.

MEMBER

NO MNAME STREAM
M001 JAYA SCIENCE
M002 ADIYTA HUMANITIES
M003 HANSRAJ SCIENCE
M004 SHIVAK COMMERCE

RESULT

NO MNAME STREAM
M002 ADITYA HUMANITIES


Q.5   Exam - CBSE12A-2018/C07B/2

Classify each of the following Web Scripting as Client Side Scripting and Server Side Scripting:
(i) JavaScripting (ii) ASP (iii) VB Scripting (iv) JSP



Q.6   Exam - CBSE12A-2018/C05A/2

Observe the following tables VIDEO and MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown below, Also, find the Degree and Cardinality of the final result.
TABLE: VIDEO

VNO VNAME TYPE
F101 The Last Battle Fiction
C101 Angels and Devils Comedy
C102 Daredevils Adventure

TABLE: MEMBER

MNO MNAME
M101 Namish Gupta
M102 Sana Sheikh
M103 Lara James

FINAL RESULT

VNO VNAME TYPE MNO MNAME
F101 The Last Battle Fiction M101 Namish Gupta
F101 The Last Battle Fiction M102 Sana Sheikh
F101 The Last Battle Fiction M103 Lara James
C101 Angels and Devils Comedy M101 Namish Gupta
C101 Angels and Devils Comedy M102 Sana Sheikh
C101 Angels and Devils Comedy M103 Lara James
A102 Daredevils Adventure M101 Namish Gupta
A102 Daredevils Adventure M102 Sana Sheikh
A102 Daredevils Adventure M103 Lara James


Q.7   Exam - CBSE12A-2016/C07F/1

Categories the following under Client side and Server Side script category?
(i) Java Script
(ii) ASP
(iii) VB Sript
(iv) JSP



Q.8   Exam - CBSE12A-2016/C07B/1

Which protocol helps us to transfer files to and from a remote computer?



Q.9   Exam - CBSE12A-2016/C05A/2

Observe the following PARTICIPANTS and EVENTS tables carefully and write the name of the RDBMS operation which will be used to produce the output as shown in RESULT ? Also, find the Degree and Cardinality of the result.

PARTICIPANTS

PNO NAME
1 Aruanabha Tariban
2 John Fedricks
3 Kanti Desai
EVENTS

EVENTCODE EVENTNAME
1001 IT Quiz
1002 Group Debate

RESULT

PNO NAME EVENTCODE EVENTNAME
1 Aruanabha Tariban 1001 IT Quiz
1 Aruanabha Tariban 1002 Group Debate
2 John Fedricks 1001 IT Quiz
2 John Fedricks 1002 Group Debate
3 Kanti Desai 1001 IT Quiz
3 Kanti Desai 1002 Group Debate