Provided by www.YuvaJobs.com - CSC Whole Testpaper 2


CSC PAPER  ON 14th JULY 2006  AT   NOIDA 
 
hi, all! 
i am Kavita Gupta, i am placed in CSC recently on 14th july 2006 so i m sharing my experience of CSC and whtever i remember abt questions. 
frnds i remember only those questions wich vr aksed from meand as ther r many questions interview was very long so i m posting questions subjectwise
NETWORKS1) whn u open web browser, thn wht will happen wht do u do first thing?2) wht u write first thing, i said DNS or webaddress concept thtn he asked complete web adress like i toldhttp//:www.orkut.comthn he asked meaning of each word-http,www,com etc3) wht is URL4) tel complete procedure how a site open after opening explorer5) other layers understand DNS or not if not thn wht will happen (concept of mapping to ip adress comes here) thy asked how mapping takes place and at wich layer6) dns procedure use wht tcp/ip or osi7) how many layers in tcp/ip and wich layers are extra in osi model8) tcp/ip conection oriented or conectionless9) wht is DNs he was trying to ask in detail but as i havnot read so i said tht10) wht is arp11) wht is rarp12) wht is ATM(asynchronous mode transfer) 
DBMS1) wht is primary key2) if ther is no primary key how will u uniquely identify each tuple (i said composite key or super key)3) diff between tuple and attribute4) wht r anomalies explain each in detail (like insertion anomaly deletion and modification anomaly)5) wht is foreign key constraint6) if i want to delete a tuple from a table having reference in so other table thn wht will happen (concept of cascade comes else error)7) wht r triggers explain8) if i want to hav som tuples havind null value wht to do (outer join)9) wht if i join two tables and no primary key (spurious tuples generate redundant data)10) he asked me wht will u do if need to retrieve this so basically queryand select first four tuplesselect *from employeewhere salarythn apply rownum<=4 to select first four tuples11) diff betweenoracle 9i and oracle 812) diff between dbms, rdbms, ordbms 
    OS1) wht is os2) wht is a process3) diff between process and thread4) if threads share data section wht will happen(concept of semaphore and crtitcal section comes so )5) wht is semaphore6) wht other thing semaphore do except synchronisation7) wht else happen in threads and process so deadlock concept comes8) deadlocks, and i told abt 4 conditons of deadlocks also9) in os wher do u use stacks and queues(like stacks for saving process satate , on system call context switch etc and queue in scheduling so he asked do we hav only fifo scheduling)10) so types of scheduling 
    Data Structure1) u hav fifteen boxes in kitchen and ur mom asked u to make foos for 1 month, wht will u do to make food fast (thn concept of sorting came)i said i will put name tag on boxes and thn sort thm in ascending order or i can put thm in order of color shade firstly lightest and thn little darker and soon but tht can create confusion so first is better way2)u hav 1000 names in unorder manner and i asked u to pick any name of my choice randomly and thn giv me complete info of tht person so wht ds will u usei said firstly i will sort thm thn i will use hashing/btrees as thy r faster in decreasing search domain,thy asked wich sort will u usei said radix as good for strings , he asked if one more name increase or decrease i said radix sort take linear time so doesnot affect much on timehe said if names r vary in length like one is venkateshraman other is raj i said sort from 3rd last letter or use padding.3) wht is heapsort, concept . wher u can apply it4) wht all ds u knowi said heaps binomial fiboncaai, liked list stacks queues trees arrays etc5) advantage and disadvantage of linked list and array over each other in temrs of memory allocation6) insert and delete a node in a linked list write a code(not from me)
basically thy asked asll application based question on data structure 
java/c/c++1) he write a java code of swapping to name via calling object as parameter and asked whther result will reflect in main or not(as object passed as a reference so reuslt will be reflected)2) in java we use call by reference or call by value3) wht r interfaces4) diff between interfaces and abstraction
NOTE- before going for interview i hav heard tht thy ask ur fav subject note tht and thn asked ques accordingly but today thy start taking interview without asking any fav subjects from all of us- so be prpeared for DBMS, os, ds, java, networks and c/c++(little bit)- n/w questions vr all concept based no theory thy just want to see how things happen-either u,ll go offcampus or oncampus thy take 35 minutes to 1 hr interview of each person). mine was 35 minutes so u can see no of ques asked think abt my frnd whose interview was of complete 1 hr even whn we vr oncampus  
Provided by www.YuvaJobs.com - CSC Whole Testpaper 2