Answer / vikas

Test Paper :2
Paper Type : Whole Testpaper
Test Date : 21 June 2008
Posted By : Nisha
CGI PAPER ON 21st JUNE 2008

1. Why we use Treeview Control?
To list the hierarchial list of the node objects. Such of files and
Directories.

2. Why we need OLE-Automation? Advantages?
Enables an application to exposes objects and methods to other
Applications. No need to reserve memory. No need to write functions.
Object library that simplify programming tasks. i.e., No need to Object
library. (OLB, TLB).

3. What is the diff between the Create Object and Get object?
Create Object - To create an instance of an object.
Get Object ? To get the reference to an existing object.

4. Have you create Properties and Methods for your own Controls?
Properties ? Public variable of a Class
Method ? Public procedure of a classWhat is Collection Objects?
Similarly to arrays but is preferred over an array because of the following
reasons.
1. A collection objects uses less Memory than an array.
2. It provides methods to add and delete members.
3. It does not required reason statement when objects are added or deleted.
4. It does not have boundary limitations.

5. What is Static Variable?
Its Scope will be available through out the life time.
Private Dim x as integer. Is it true?
No. Private cannot be used in front of DIM.

6. What is Implicit?
Instance of specific copy of a class with its own settings for the
properties defined in that class. Note: The implicity defined variable is
never equal to nothing.

7. What are the scope of the class?
Public , private, Friend
Can we able to set Instancing properties like Singleuse, GlobalSingleuse to
ActiveXDll?
No.
In project properties if we set Unattended what is it mean?
This cannot have user interface. This can be used for the COM creation.What
are the Style Properties of Combo Box?
Simple, Dropdown list ? We can type and select.
Dropdown Combo ? Only Drop Down.

8. What are the Style properties of List Box?
Simple ?Single Select , Extended. ? Multiple Select.

9. What are the different types of Dialog Box?
Predefined, Custom, User Defined.

10. What is Parser Bug?
It is difficult to use database objects declared in a module from within a
form.

11. What is the Dll required for running the VB?
Vbrun300.dllCan We create CGI scripts in VB?
Yes.

12. How to change the Mouse Pointer?
Screen. Mouse Pointer = VBHourGlass/VBNormal.

13. How to check the condition in Msgbox?
If (Msgbox("Do you want to delete this Record",VbYesNo)=VbYes)Then End if

14. What is difference between datagrid and flexgrid?
Datagrid ? Editable.
Flexigrid ? Non-Editable. (Generally used for Read only purpose.)

15. What is ADO? What are its objects ?
ActiveX Data Object. ADO can access data from both flat files as well as
the databases. I.e., It is encapsulation of DAO, RDO, and OLE that is why
we call it as OLE-DB Technology. Objects are Connection, Record Set,
Command, Parameter, field, Error, Property.

16. What is Dataware Control?
Any control bound to Data Control.
Ex:- Textbox, Check Box, Picture Box, Image Control, Label, List box, Combo
Box, DB Combo, What are two validate with Data Control?
Data_Validate, Data_Error.
Record set types and Number available in VB?
3. 1- Dynaset, 0 ? Table, 2 ? Snap Shot.
Referential Integrity (Take care By jet database Engine).
Cascade Delete, Cascade Update ? is done setting property of Attributes.
Db Relation Delete Cascade,
Db Relation Update Cascade.

17. What are the locks available in Visual Basic?
Locking is the process by which a DBMS restricts access to a row in a
multi-user environment
4 types of locks. They are
1.Batch Optimistic
2.Optimistic
3.Pessimistic
4.ReadOnly

18. What is the diff between RDO and ADO?
RDO is Hierarchy model where as ADO is Object model. ADO can access data
from both flat files as well as the data bases. I.e., It is
encapsulation of DAO, RDO , OLE that is why we call it as OLE-DB Technology.

19. How can we call Stored procedure of Back End in RDO and ADO ?
In RDO ? We can call using RDO Query Objects.
In ADO ? We can call using Command Objects.

20. What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?
Microsoft ODBC driver will support all the methods and properties of Visual
Basic. Where as the Oracle not.

21. What are the Technologies for Accessing Database from Visual Basic?
DAO, Data Control, RDO, ODBCDIRECT, ADO, ODBC API.
Calling Stored Procedures in VB?
1. Calling Simply the Procedure with out Arguments "Call Procedure Name}"
If it is with Arguments Means then
Declare the Query Def qy
Set Qy as New Query def
Qy.SQL = "{Call ProcedureName(?,?,?)}"
qy(0)=val(Txt1.Text)
qy(1)=val(Txt2.Text)
qy(2)=val(Txt3.Text)
Set Rs = Qy.OpenresultSet
Txt(1)=Rs.RdoColumns(0)






Test Paper :3
Paper Type : Aptitude - Numerical
Posted By : Mrunal


Sample test paper

Q. A man leaves office daily at 7pm A driver with car comes from his home
to pick him from office and bring back home
One day he gets free at 5:30 and instead of waiting for driver he starts
walking towards home. In the way he meets the car and returns home on car
He reaches home 20 minutes earlier than usual. In how much time does the
man reach home usually??
Ans. 1hr 20min

Q The following truth table is given What is Y equal to??

A


B


C


Y

0


0


0


1

0


0


1


1

0


1


0


0

0


1


1


0

1


0


0


0

1


0


1


0

1


1


0


1

1


1


1


1

Ans. (A')(B')(AB) , where ' stands for complement.

Q. A works thrice as much as B. If A takes 60 days less than B to do a work
then find the number of days it would take to complete the work if both
work together?
Ans. 22½days

Q. How many 1's are there in the binary form of 8*1024 + 3*64 + 3
Ans. 4

Q. In a digital circuit which was to implement (A B) + (A)XOR(B), the
designer implements (A B) (A)XOR(B)
What is the probability of error in it ?

Q. A boy has Rs 2. He wins or loses Re 1 at a time If he wins he gets Re 1
and if he loses the game he loses Re 1.He can loose only 5 times. He is out
of the game if he earns Rs 5. Find the number of ways in which this is
possible?
Ans. 16

Q. If there are 1024*1280 pixels on a screen and each pixel can have around
16 million colors Find the memory required for this?
Ans. 4MB

Q. On a particular day A and B decide that they would either speak the
truth or will lie. C asks A whether he is speaking truth or lying? He
answers and B listens to what he said. C then asks B what A has said B says
"A says that he is a liar"What is B speaking ?
(a) Truth
(b) Lie
(c) Truth when A lies
(d) Cannot be determined
Ans. (b)

Q. What is the angle between the two hands of a clock when time is 8:30Ans.
75(approx)

Q. A student is ranked 13th from right and 8th from left. How many students
are there in totality ?

Q. A man walks east and turns right and then from there to his left and
then 45degrees to his right.In which direction did he go
Ans. North west

Q. A student gets 70% in one subject, 80% in the other. To get an overall
of 75% how much should get in third subject.

Q. A man shows his friend a woman sitting in a park and says that she the
daughter of my grandmother's only son. What is the relation between the two
Ans. Daughter



Quantitative:

1. Data sufficiency. there were about 15 questions of the type A question
is given with 2 options. U have 2 conclude ans can be determined by only
option 1 or 2 or both or both r insufficient.

2. Data interpretation. This was dam tough. U have to manipulate a graph
and answer about 12 questions. there were also the questions on graphs and
tables.

3. Contractor has 2 complete work within a fixed time. If he is late he
has to pay fine. The first day it is Rs 200 and from then on it increases
by 25 per day. He has to pay Rs 9450. How many days he got late.

Ans is 21.

4. Sphere of diameter 6 cm is melted to form a cone with diameter 12 cm.
Find height of cone.

5. Shakuntala devi sum of the number of glasses received intact.

6. Sum on Cisterns, Pipes a, B and C r there a and b can fill the tank in 4
and 5 hours respectively. C can empty tank in 2 hours. If the pipes were
opened at 1.00 and 2.00 am successively by what time will the tank be empty.

7. a question on cost of painted area.

8. A brick size is 8" x 6". An L shaped wall has to be built with width of
4, other two dimmensions are 21 and 7. Find no of Bricks reqd.

9. Ratio of base and heights of a cone and cylinder is given. Find ratio of
their curved surfaces.

PAPER : CGI PLACEMENT PAPER PATTERN (2006)

1. Factorize y**2 + 8y - 48 =0
Ans. (y+12) (y-4)

2. 1,40,00,000 pencils are put up straight. all the pencils are of length
range 3 to 6 inches. 80% of the pencils have average of five inches. so the
find out the total length spanned by the pencils.
Ans. 1000 to 1500 miles.

3. boys are not girl . Jill is not a girl
ans Jill is not a girl.

4. Price of cotton today is 50 corore what will it be after 100 years
ans c) unknown

5. if ELECTRICITY - GAS =100
then JACK - JILL = ?

6. 8 man work for 6 days to complete a work. How many men are required to
complete same work in 1/2 day. Ans. 96 men.

7. a man is running around a rectangle it takes time 2 time in travelling
lenth than travelling width total perimeter = 300 find area
ans 5000

8. A man drives at a speed of 40 miles/hr. His wife left 30 mins. late with
50 miles/hr speed. when will they meet ?
Ans. 2 hours

9. A farmer walks at constant speed on the perimeter of his rectangular
field. it takes him twice the time to cover longer side than shorter side.
if he walks total 300 m . then find out the area of field?
Ans. 5000 sq.m

10. There were some questions on series :
21, 463, 687, 238, 1134, ---- Ans. 297
0, 6, 24, 120, 210, ---, ----

11. REPUBLICAN = 108 so DEMOCRATE = ? (it is diffcult. i made guess on 84 )

12. if ELECTRICITY - GAS =100 then JACK - JILL = ?

SNAPDEAL QUESTIONS 1. A train is going at a speed of 60kmph towards Delhi and returned back at a speed of 30kmph. What is its average speed? ANS : (2*30*60)/(30+60) = 40kmph 2. How many different 4 letter words can be framed that have at least one vowel? ANS : 264 - 214 (total no of 4 digits words – no of words with no vowels) 3. Write an algorithm to find out a number from an array of numbers where only one number occurs once and rest all occurs twice. ANS : XOR all the numbers ,you will get the number with single occurrences . 4. Which among the following have the product of the distance between opposite sides of a regular polygon and it side equals one fourth of the area. A. hexagon B. octagon C. n=16 D. n=18 ANS : n=16.(area of regular polygon = apothem*perimeter/2 Apothem = distance between opposite sides/2 Area = (opp_side_dist * n * a )/4 Product of opp_side_dist and side of reg. polygon = opp_side_dist * a For n= 16 the ration becomes 1:4 5. Which of the following cannot be a relation between two variables? ANS = 4th diagram. 6.what will be the output of this program Void print (int n) { If (n>0) { printf(“hello”); print(n-1); } printf(“world”); } ANS : N times hello followed by N+1 times world. 7. Which among the following cannot be used for future prediction? ANS : 4th Diagram. 8. There are 25 horses. We have to find out the fastest 3 horses In one race maximum 5 horses can run. How many such races are required in minimum to get the result. ANS : 7 races (A. first run all horses = 5 races, eliminate 4th 5th of all races. B. Run horses who came 1st in those 5 races = 1 race , the horse coming first is the fastest Run horses a. 2nd and 3rd with the fastest horse (in first time race A) b. 2nd and 3rd coming horse in B. c. The horse who came 2nd with the horse(who came 2nd in race B) in race A You will have the fastest 3 horses.) 9. In a game of rolling dice you are given 2 dice and you have to roll them. Whatever is the outcome the player will win that many dollars. What should the game owner charge each player (optimum) so that he doesn’t have to bear any loss? ANS : $7 10. We have a function REV(“string”,m,n).This function is capable of reversing the caharacters in the string from mth location to nth location. e.g. REV(“abcd”,2,3)  the output will be acbd We need to swap a string from a position,e.g. SWAP(“abcdefg”,4)  output needs to be efgabcd. How can the REV function used do this. ANS : L = string length,N= position given in SWAP function. SWAP(“abcdefg”,4) = REV(REV(REV(“abcdefg”,N+1,L),1,N),1,L).

1 Answers   SnapDeal,

---

the effecs of unsteady power suply

0 Answers  

---

Consagous Technology pvt ltd indore inteview experience

1 Answers   Consagous,

---

IBM Placement Paper & Interview - 22 jul 2006 - Warangal.

1 Answers   IBM,

---

INTERVIEW QUESTIONS ...............

2 Answers   Apollo Tyres, Innominds, KPO, Maximum Company, Policy Bazaar, UPSC, Zycus Infotech,

---

---

NTPC paper for civil engineering

2 Answers   L&T, NHPC, NTPC, NTRC,

---

CANARA BANK INTERVIEW - 09 MAR 2006 - BANGALORE

3 Answers   Canara Bank,

---

Accenture Placements with Freshers Campus June 30 2007

3 Answers   Accenture,

---

INFOSYS PLACEMENT PAPERS ----- Placement Paper 2

1 Answers   Infosys,

---

Microsoft GDCI Recruitment Model Placement Paper ---- 2006

2 Answers   Google, Microsoft, Satyam,

---

Sonoa Systems - Testing

1 Answers  

---

INFOSYS PLACEMENT PAPERS ----- Placement Paper 6

1 Answers   Infosys,

---