Friday, April 29, 2011

OS-LECTURE-NOTES



OS - LECTURE NOTES




Your's friendly,
[MOHANRAM.G],
ADMIN...

OPERATING SYSTEMS -Q- BANK & 2-MARK Q & A



OS - Q-BANK-I



OS - Q-BANK-II



2-MARK QUESTION & ANSWER



Your's friendly,
[MOHANRAM.G],
ADMIN...

Wednesday, April 20, 2011

DESIGN & ANALYSIS OF ALGORITHMS -QUESTION PAPER-2009



QUESTION PAPER-2009

Click here to download


http://www.free-car-magazines.com/images/download-button-animated.gif

Your's friendly,
[MOHANRAM.G],
ADMIN...

Monday, April 18, 2011

FOURTH SEMESTER- THEORY EXAMINATION TIME TABLE


19-04-2011 PROBABILITY & QUEUEING THEORY

21-04-2011 DESIGN & ANALYSIS OF ALGORITHMS

26-04-2011 MICROPROCESSOR & MICROCONTROLLER

28-04-2011 COMPUTER ORGANIZATION & ARCHITECTURE.

30-04-2011 OPERATING SYSTEMS

03-05-2011 DATABASE MANAGEMENT SYSTEMS





YOUR'S FRIENDLY,
[MOHANRAM.G]
ADMIN...

DATABASE MANIPULATION LANGUAGE - COMMANDS



insert into STUDENTDB (SN,ROLLNO,NAME,M1,M2,M3,M4,M5,M6) values(1,'O9BC001','ANISH',80,76,85,98,84,90)
insert into STUDENTDB (SN,ROLLNO,NAME,M1,M2,M3,M4,M5,M6) values(2,'O9BC005','ABILASH',46,66,89,56,74,60)
insert into STUDENTDB (SN,ROLLNO,NAME,M1,M2,M3,M4,M5,M6) values(3,'O9BC037','JAMES',84,73,85,88,74,50)
insert into STUDENTDB (SN,ROLLNO,NAME,M1,M2,M3,M4,M5,M6) values(4,'O9BC041','RAMESH',65,56,45,78,67,66)
insert into STUDENTDB (SN,ROLLNO,NAME,M1,M2,M3,M4,M5,M6) values(5,'O9BC055','SARAVANAN',67,76,56,73,65,73)
select * from STUDENTDB

update STUDENTDB set TOTAL=M1+M2+M3+M4+M5+M6

select * from STUDENTDB

update STUDENTDB set DEPT='CSE'

select * from STUDENTDB

update STUDENTDB set DOB='1991-10-26' where ROLLNO='O9BC001'
update STUDENTDB set DOB='1991-5-29' where ROLLNO='O9BC005'
update STUDENTDB set DOB='1992-1-15' where ROLLNO='O9BC037'
update STUDENTDB set DOB='1992-2-6' where ROLLNO='O9BC041'
update STUDENTDB set DOB='1991-9-26' where ROLLNO='O9BC055'

select NAME from STUDENTDB

select ROLLNO from STUDENTDB

select TOTAL from STUDENTDB

select count (distinct NAME) from STUDENTDB


select * from STUDENTDB where TOTAL >= (select AVG(TOTAL) from STUDENTDB)


select * from STUDENTDB where TOTAL >=300 and NAME like ‘A%’



Your's friendly,
[MOHANRAM.G],
ADMIN...

DATABASE DESIGN LANGUAGE - COMMANDS



create db SKYNET

connect to SKYNET

create table STUDENTDB (SN integer not null,ROLLNO varchar(7) not null unique, NAME varchar(25) not null,M1 integer check (M1>0),M2 integer check (M2>0),M3 integer check (M3>0),M4 integer check (M4>0),M5 integer check (M5>0),M6 integer check (M6>0))

select * from STUDENTDB

alter table STUDENTDB add TOTAL integer

select * from STUDENTDB

alter table STUDENTDB add DOB date

select * from STUDENTDB

alter table STUDENTDB add DEPT varchar(3) check (DEPT in ('CSE' ,'IT'))

select * from STUDENTDB

drop table STUDENTDB

Your's friendly,
[MOHANRAM.G],
ADMIN...

COMPUTER ORGANISATION & ARCHITECTURE - PREVIOUS YEAR QUES-PAPERS AND Q-BANKS

Previous year question papers

MAY-JUNE-2006

NOVEMBER- DECEMBER-2006

MAY-JUNE-2007

NOVEMBER- DECEMBER-2007-I

NOVEMBER- DECEMBER-2007-II

APRIL-MAY-2008-I

APRIL-MAY-2008-II

Question Banks

QUESTION BANK-I

QUESTION BANK-II

QUESTION BANK-III

UNIT-V-Q&A

Your's friendly,
[MOHANRAM.G],
ADMIN...

COMPUTER ARCHITECTURE - NOTES

LECTURE NOTES

MEMORY ORGANISATION NOTES


Your's friendly,
[MOHANRAM.G],
ADMIN...