Questions – Exam Papers – Computer Sir Ki Class

Login


Lost your password?

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


Shop
siteicon
Exam Paper: Questions - Exam Papers () siteicon No. of Q.13

Section-C


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



Consider the following DEPT and EMPLOYEE tables. Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii).
Table: DEPT

DCODE DEPARTMENT LOCATION
D01 INFRASTRUCTURE DELHI
D02 MARKETING DELHI
D03 MEDIA MUMBAI
D05 FINANCE KOLKATA
D04 HUMAN RESOURCE MUMBAI

Table: EMPLOYEE

ENO NAME DOJ DOB GENDER DCODE
1001 George K 2013-09-02 1991-09-01 MALE D01
1002 Ryma Sen 2012-12-11 1990-12-15 FEMALE D03
1003 Mohitesh 2013-02-03 1987-09-04 MALE D05
1007 Anil Jha 2014-01-17 1984-10-19 MALE D04
1004 Manila Sahai 2012-12-09 1986-11-14 FEMALE D01
1005 R SAHAY 2013-11-18 1987-03-31 MALE D02
1006 Jaya Priya 2014-06-09 1985-06-23 FEMALE D05

Note: DOJ refers to date of joining and DOB refers to date of Birth of employees.

(i) To display Eno, Name, Gender from the table EMPLOYEE in ascending order of Eno.

(ii) To display the Name of all the MALE employees from the table EMPLOYEE.

(iii) To display the Eno and Name of those employees from the table EMPLOYEE w ho are born between ‘1987-01-01’ and ‘1991-12-01’.

(iv) To count and display FEMALE employees who have joined after ‘1986-01-01’.

(v) SELECT COUNT(*),DCODE FROM EMPLOYEE GROUP BY DCODE HAVING COUNT(*)>1;

(vi) SELECT DISTINCT DEPARTMENT FROM DEPT;

(vii) SELECT NAME, DEPARTMENT FROM EMPLOYEE E, DEPT D WHERE E.DCODE=D.DCODE AND EN0<1003;

(viii) SELECT MAX(DOJ), MIN(DOB) FROM EMPLOYEE;




Verify the following using Boolean Laws.
U’+ V= U’V’+U’.V +U.V




Draw the Logic Circuit for the following Boolean Expression :
(X’+Y).Z+W’




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

P Q R F(P,Q,R)
0 0 0 1
0 0 1 0
0 1 0 0
0 1 1 1
1 0 0 1
1 0 1 0
1 1 0 0
1 1 1 1



Reduce the following Boolean Expression to its simplest form using K-Map :
F(X,Y,Z,W) = ∑(0,1,4,5,6,7,8,9,11,15)




Illustrate the layout for connecting 5 computers in a Bus and a Star topology of Networks.




What kind of data gets stored in cookies and how is it useful?




Differentiate between packet switching over message switching?




Out of the following, which is the fastest (i) wired and (ii) wireless medium of communication?
Infrared, Coaxial Cable, Ethernet Cable, Microwave, Optical Fiber





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.




Xcelencia Edu Services Ltd. is an educational organization. It is planning to set up its India campus at Hyderabad with its head office at Delhi. The Hyderabad campus has 4 main buildings -
ADMIN, SCIENCE, BUSINESS and MEDIA.
You as a network expert have to suggest the best network related solutions for their problems raised in (i) to (iv), keeping in mind the distances between the buildings and other given parameters.

Shortest Distances between various buildings:

ADMIN to SCIENCE 65M
ADMIN to BUSINESS 100M
ADMIN to ARTS 60M
SCIENCE to BUSINESS 75M
SCIENCE to ARTS 60M
BUSINESS to ARTS 50M
DELHI Head Office to HYDERABAD Campus 1600KM

Number of Computers installed at various building are as follows:

ADMIN 100
SCIENCE 85
BUSINESS 40
ARTS 12
DELHI Head Office 20

(i) Suggest the most appropriate location of the server inside the HYDERABAD campus (out of the 4 buildings), to get the best connectivity for maximum no. of computers. Justify your
answer.

(ii) Suggest and draw the cable layout to efficiently connect various buildings ‘within the HYDERABAD campus for connecting the computers.

(iii) Which hardware device will you suggest to be procured by the company to be installed to protect and control the intemet uses within the campus?

(iv) Which of the following will you suggest to establish the online face]to]face communication between the people in the Admin Office of HYDERABAD campus and DELHI Head Office?
(a) E]mail (b) Text Chat (c) Video Conferencing (d) Cable TV



Total Marks.26
×