Questions – Exam Papers – Computer Sir Ki Class

Exam Paper: Questions - Exam Papers () No. of Q.10

Section-C

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
M003 HANSRAJ SCIENCE
M004 SHIVAK COMMERCE

RESULT

NO MNAME STREAM

Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables
DVD

DCODE DTITLE DTYPE
F101 Henry Martin Folk
C101 The Planets Classical
F102 Universal Soldier Folk
R102 A day in life Rock

MEMBER

MID NAME DCODE ISSUEDATE
101 AGAM SINGH R102 2017-11-30
103 ARTH JOSEPH F102 2016-12-13
102 NISHA HANS C101 2017-07-24

(i) To display all details from the table MEMBER in descending order of ISSUEDATE.

(ii) To display the DCODE and DTITLE of all Folk Type DVDs from the table DVD

(iii) To display the DTYPE and number of DVDs in each DTYPE from the table DVD

(iv) To display all NAME and ISSUEDATE of those members from the table MEMBER who
have DVDs issued (i.e ISSUEDATE) in the year 2017

(v) SELECT MIN(ISSUEDATE) FROM MEMBER;

(vi) SELECT DISTINCT DTYPE FROM DVD;

(vii) SELECT D.DCODE,NAME,DTITLE
FROM DVD D, MEMBER M WHERE D.DCODE=M.DCODE ;

(viii) SELECT DTITLE FROM DVD
WHERE DTYPE NOT IN ( ” Folk ” , ” Classical ” );

State DeMorgan’s Laws of Boolean Algebra and verify them using truth table.

Draw the Logic Circuit of the following Boolean Expression using only NOR Gates:
( A+B).(C+D)

Derive a Canonical POS expression for a Boolean function G, represented by the following truth table:

X Y Z G(X,Y,Z)
0 0 0 0
0 0 1 0
0 1 0 1
0 1 1 0
1 0 0 1
1 0 1 1
1 1 0 0
1 1 1 1

Reduce the following Boolean expression to its simplest form using K-Map:
E(U,V,Z,W)= Ó (2,3,6,8,9,10,11,12,13)

Differentiate between communication using Optical Fiber and Ethernet Cable in context of wired medium of communication technologies.

Janish Khanna used a pen drive to copy files from his friend’s laptop to his office computer. Soon his office computer started abnormal functioning. Sometimes it would restart by itself and sometimes it would stop different applications running on it. Which of the following options out of (i) to (iv), would have caused the malfunctioning of the computer? Justify the reason for your chosen option:
(i) Computer Virus
(ii) Spam Mail
(iii) Computer Bacteria
(iv) Trojan Horse

Ms. Raveena Sen is an IT expert and a freelancer. She recently used her skills to access the Admin password for the network server of Super Dooper Technology Ltd. and provided confidential data of the organization to its CEO, informing him about the vulnerability of their network security. Out of the following options (i) to (iv), which one most appropriately defines Ms.Sen? Justify the reason for your chosen option:
(i) Hacker
(ii) Cracker
(iii) Operator

Hi Standard Tech Training Ltd is a Mumbai based organization which is expanding its office set-up to Chennai. At Chennai office compound, they are planning to have 3 different blocks for Admin, Training and Accounts related activities. Each block has a number of computers, which are required to be connected in a network for communication, data and resource sharing. As a network consultant, you have to suggest the best network related solutions for them for issues/problems raised by them in (i) to (iv), as per the distances between various blocks/locations and other given parameters.

Shortest distances between various blocks/locations:

 Admin Block to Account Block 300 Metres Accounts Block to Training Block 150 Metres Admin Block to Training Block 200 Metres MUMBAI Head Office to CHENNAI Office 1300 KM

Number of computers installed at various blocks are as follows:

 Training Block 150 Accounts Block 130 Admin Block 40

(i) Suggest the most appropriate block/ location to house the SERVER in the CHENNAI Office (out of the 3 blocks) to get the best and effective connectivity. Justify your answer.
(ii) Suggest the best wired medium and draw the cable layout (Block to Block) to efficiently connect various blocks within the CHENNAI office compound.
(iii) Suggest a device/software and its placement that would provide data security for the entire network of the CHENNAI office.
(iv) Suggest a device and the protocol that shall be needed to provide wireless Internet access to all smartphone/laptop users in the CHENNAI office

Total Marks.26
×