Questions – Exam Papers – Computer Sir Ki Class

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

Section-C

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
C3 ROHAN EDUCATION
C4 RISHAB ENGINEERING

RESULT

NO NAME
C3 ROHAN

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

Code BNAME TYPE
F101 The priest Fiction
L102 German easy Literature
C101 Tarzan in the lost world Comic
F102 Untold Story Fiction
C102 War Heroes Comic

TABLE: MEMBER

MNO MNANE CODE ISSUEDATE
M101 RAGHAV SINHA L102 2016-10-13
M103 SARTHAK JOHN F102 2017-02-23
M102 ANISHA KHAN C101 2016-06-12

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

(ii) To display the BNO and BNAME of all Fiction Type books from the table BOOK

(iii) To display the TYPE and number of books in each TYPE from the table BOOK

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

(v) SELECT MAX(ISSUEDATE) FROM MEMBER;

(vi) SELECT DISTINCT TYPE FROM BOOK;

(vii) SELECT A.CODE,BNAME,MNO,MNAME FROM BOOK A, MEMBER B
WHERE A.CODE=B.CODE ;

(viii) SELECT BNAME FROM BOOK
WHERE TYPE NOT IN (“FICTION”, “COMIC”);

State Distributive Laws of Boolean Algebra and verify them using truth table.

Draw the Logic Circuit of the following Boolean Expression using only NAND Gates:
X.Y + Y.Z

Derive a Canonical SOP expression for a Boolean function F, represented by the following truth table:

U V W F(U,V,W)
0 0 0 1
0 0 1 0
0 1 0 1
0 1 1 1
1 0 0 0
1 0 1 0
1 1 0 1
1 1 1 0

Reduce the following Boolean Expression to its simplest form using K-Map:
F(X,Y,Z,W)= Σ (0,1,2,3,4,5,10,11,14)

Differentiate between Radio Link and Microwave in context of wireless communication technologies.

Amit 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 functioning totally. 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 Worm
(ii) Computer Virus
(iii) Computer Bacteria
(iv) Trojan Horse

Jai is an IT expert and a freelancer. He recently used his skills to access the Administrator password for the network server of Megatech Corpn Ltd. and provided confidential data of the organization to its Director, informing him about the vulnerability of their network security. Out of the following options (i) to (iv), which one most appropriately defines Jai.
Justify the reason for your chosen option:
(i) Hacker
(ii) Cracker
(iii) Operator

Hi Speed Technologies Ltd is a Delhi based organization which is expanding its office setup to Chandigarh. At Chandigarh office campus, they are planning to have 3 different blocks for HR, Accounts and Logistics related work. Each block has 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 in (i) to (iv), keeping in mind the distances between various blocks/locations and other given parameters.

Shortest distances between various blocks/locations:

 HR Block to Accounts Block 400 Metres Accounts Block to Logistics Block 200 Metres Logistics Block to HR Block 150 Metres DELHI Head Office to CHANDIGARH Office 270 Km

Number of Computers installed at various blocks are as follows:

 HR Block 70 Account Block 50 Logistics Block 40

(i) Suggest the most appropriate block/location to house the SERVER in the CHANDIGARH 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 CHANDIGARH office compound.

(iii) Suggest a device/software and its placement that would provide data security for the entire network of CHANDIGARH office.

(iv) Which of the following kind of network, would it be
(a) PAN
(b) WAN
(c) MAN
(d) LAN

Total Marks.26
×