Friday, July 25, 2014

Freshers Technical Interview Question - CGI



CGI recent paper
1st round -Aptitude
2nd round -GD
3rd round-Technical
4th round-short HR+Technical
5th round- HR
In 1st technical they asked about my .net final yr project..along with web form coading means how to create connection wid database n alll type of SQL queries..so try to tel all d things which u knw vry well from ur side..my 1st technical duration was 45 min..quite long as compare to other
2-) what is the use of web config page.?
3-)OOps concept (Abstraction ,polymorphism,inheritance,encapsulation)
so prepare wid example...n dey asked to me..give real time eg: of Abstaction?????
4) How to Implement interface in .net??
5) what is the use of abstract class??
6)write the program of method overloading??
7) Diff b/w method overloading n overriding??
8) what r the types of access modifier ???
2 nd technical:-
1-)they asked dat how to host web application ..n sm SQL queries again..
2)write the Procedure n How to create View in PLSQL
3) Wt is d diff b/w desktop application n web application n sm 3-4 ques..which i forget..short intro n basic things ..only 30-35 min.
4)How to find second highest salary of Employee in SQL.
5)what is Sub quries???
A train running at the speed of 60 km/hr crosses a pole in 9 seconds. What is the length of
the train?
puzzle- six person, six profession, six instruments(each person plays a single instrumnt)...
. very easily this puzzled can be solved..- 5 questions
another puzzle.. 3 questions.. its the easiest puzzle...
more 5 quanti questns.. all r easy xcpt one..
englsh is bit tough..
one paragraph will be given.. 4 sentences will be missing within the paragraph. options
r given below.. u need to put the correct sentence on correct place..
rest of the english questns: each questn has separate paragraph.. so this part is very time
consuming..
1st solve two puzzles thn quanti part.. & at the end go for english.. it will be helpful to
manage time..
********* this is the pattern of apti questn that CGI follows*******
‪#‎GD‬
1.corruption in india
2.social networking
3.electronic media vs news paper
4.traffic in bangalore
this round is not so tough.. be confident.. they will select u.. out of 10 candidate they
choose 7-8.. so no need to take tension.
‪#‎TECH1‬:
this the most most importnt round i think.. u have to face 30-50 questn(avg).. prepare
ur projct very well.. most of the questn will be asked from project.. some basic technical questns
will be asked.. so answer confidently all questns..
‪#‎TECH2‬:
if u can clear tech1 thn ur chnce is 95%.. most of the time this round is non-rejection round..
some tough technical questn will be asked.. try to answr properly.. this round will be taken by
managers.. so be careful when u r speaking..
‪#‎HR‬:
this is formal..
why CGI?
location?
who reffered u?
family background....
1st round is written test on apti and english 25 questions 30 min it somewhat difficult manage the
time well
2nd round gd for my batch he gives the topic and ask all the people to talk about it for 2 minutes
3rd round is 1st technical i went for java he asks me about basics questions on java... and basic
programs like pallendrome largest of three nos
4th round is 2nd technical he asks some deep question in this round see the topics of collections
program for add retrieve the elements...
5th round is hr it just a formality round if u clear the 4th one u r almost selected..
they will send u the offer letter in one week
all the best for all who r attending for the interview..
Plsql cgi
For pl/sql guys... these kind of questions i hv faced 2day in cgi in both technical rounds...
1. what is %type and %rowtype?
2. There is a 'student' table with attributes like Name and age ... you hv to create one cursor
and write a pl/sql program code for dat table using %type and %rowtype 3.what is stored procedure?
what is anonymous block?
4. what is d difference b/w function and procedure?
5.what kind of security u hv used in your oracle 10g project?
6. sql query for 2nd/3rd highest salary
7.write a c program for prime number?
8. what is trigger and give one example throgh a pl/sql program code?
9.How many different database u know
10. sql query for delete duplicate record from a table 10.2 puzzles 11. what is 2nd normal form?
11. HR also asked me two puzzles also
those who r going for CGI.
CGI PROCESS
1> Written:
There were 25 Questions u have to solve in 30 mins,12 is cut off!
I>1 to 5 English grammer questions like verb,tenses etc
II>5to10 Pragraph u have to relate the words.
III>10 to 20 aptitude
a>profit & loss
b>time & work
c>average
d>ages
e>Boolean etc
IV>20 to 25 relationship questions may be in the form of paragraph or charts.
2>Group Decision :
a>social networking site good or bad.
b>newspaper
c>Delhi rape case
I knw only these topics.
Its not debate kind of but every one gets time to speek about it.
3>Techical 1 followed by technical2 questions depend on ur profile.
Go prepared for technical.
I was interviewed for Testing:
Types of testing.
White box testing
Grey box testing
Regression testing
Test case template
Test case for water bottle,pen.etc
4>HR:Its just formality round
Brief intro, go through about CGI,why CGI,general questions,hobbies..
point to remember-
1. make sure u have original certificate(mean duplicate b ho to uska original printout.)
2.attempt all the ques coz no negative marking , make sure 12 out of 25 r correct.
3. in GD, they will give a simple topic so speak whatever u can speak, coz if u will not speak
and hesitate they they will simply reject you.