ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 


 

Company >> 3i Infotech >> 3i Infotech Questions
 
 3i Infotech technical test questions  3i-Infotech Technical Test Questions (1)  3i Infotech aptitude test questions  3i-Infotech Aptitute Test Questions (1)  3i Infotech interview questions  3i-Infotech Interview Questions (31)
 
Back to Questions Page
Question   Dont work with 3i-infotech or 3i-icsl with SAMBA financial group -Riyadh, Saudi Arab. These people not properly treated here and there. They treated like labour or bonded labour. Not given proper respect, sorry not given any respect. Salary & allowance too much low. Accomodation also not upto mark. These 3i people just dumping here in Riyadh and just playing with your feelings. Rank Answer Posted By  
 Interview Question Submitted By :: Fire Resources
I also faced this Question!!   © ALL Interview .com
Answer
Dont work with 3i-infotech or 3i-icsl with SAMBA financial 
group -Riyadh, Saudi Arab.  These people not properly 
treated here and there.  They treated like labour or bonded 
labour.  Not given proper respect, sorry not given any 
respect.  Salary & allowance too much low.  Accomodation 
also not upto mark.  These 3i people just dumping here in 
Riyadh and just playing with your feelings. After coming 
back to India, these people sack (fire) the resources 
without notice.
 
0 Fire Resources
 
 
Question   Requirement is: try { \\SQL Query } catch(Exception i) { print a } catch(SQLQueryException e) { \\SQL Query } Qu)I Got Exception in "try" block. Which "catch" statement (i.e. 1st catch or 2nd catch ) catches the exception and Why??? Rank Answer Posted By  
 Interview Question Submitted By :: Shaan.sunswift
I also faced this Question!!   © ALL Interview .com
Answer
when the exception is thrown it will search for mostly
likely to least likely exception so it will catch in second
catch
 
0 Sabir
 
 
Answer
it will give compile time error as, the sequence of 
exception class has to be Most Specific => General.
 
0 Parikshit
 
 
 
Answer
In try block the SQL query will be executed so the exception
will match the SQLException catch because all type of SQL
exception will be match in this SQLException

if we wrote normal query in try block then it will match
Exception catch
 
0 Meena
 
 
Question   Hi, Requirement is: try { \\SQL Query } catch(Exception i) { print a } catch(SQLQueryException e) { \\SQL Query } Got Exception in "try" block. Which "catch" throws exception and Why??? Please provide the answer in detail.. Thanks for the help!!! Rank Answer Posted By  
 Interview Question Submitted By :: Shaan.sunswift
I also faced this Question!!   © ALL Interview .com
Answer
catch(SQLQueryException e)
{
 \\SQL Query
}
 would throw exception as a try can have more than one catch
block that the related exception can be handled individually
 
0 Kaushik
 
 
Answer
I tried I got the following ...

Error	1	A previous catch clause already catches all exceptions of this or of a super type ('System.Exception')	E:\dotnet\ConsoleApplication1\ConsoleApplication1\Program.cs	58	20	ConsoleApplication1
 
0 Djana
 
 
Question   if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes.. Rank Answer Posted By  
 Interview Question Submitted By :: Sandy
I also faced this Question!!   © ALL Interview .com
Answer
Take a example as to find the same student who got first and
second marks in each of sub.

SELECT RollNo,COUNT(Rank) FROM Student GROUP BY RollNo,rank
ORDER BY rank
 
0 Hitesh Kumar Vyas S
 
 
Answer
select top 10 cast(key as varchar)
+ '(' + cast(count(key) as varchar) + ')' 
from TableName
group by key


Hanamesh Havale
Influx Infotech
 
4 Hanamesh Havale
 
 
Answer
Select cast(idKey as varchar)+'('+cast(count(idKey) as 
varchar)+')' 
from #tbl1 group by idKey
 
0 Saravanan P
 
 
Answer
create table #temp1(id int) 

insert into #temp1 values(4)


declare @str nvarchar(500)
select @str=''
select @str =@str+ id  from (select  cast(id as varchar) +'('+
cast(count(id) as varchar(22))+ ')'  id  from #temp1  group
by id) t
select @str


output will be :1(5)2(1)3(2)4(1)
 
0 Praveen Singh
 
 
Answer
select  convert(varchar,key) + '('+ convert(varchar,
count(key))+')' from table_name group by key

Hanamesh, why top 20?
 
0 Pradip Jain
 
 
Question   hot to set the indian payroll in oracle HRMS? how to integrate the OTL with payroll? if any one have the document or tell me the procedure to set my mail id is ravichandan.g@gmail.com Rank Answer Posted By  
 Interview Question Submitted By :: Ravichandan.g
I also faced this Question!!   © ALL Interview .com
Answer
You can download oracle HRMS related docs from below site.


http://download-
east.oracle.com/docs/cd/B25516_11/current/html/docset.html
 
0 JM
 
 
Question   What Is the command to change a file's creation time. means one file is created at the time 15:19 then time should br changed to 14:14 Rank Answer Posted By  
 Interview Question Submitted By :: Pranab
I also faced this Question!!   © ALL Interview .com
Answer
use touch command to change the date
 
0 Ravikumar
 
 
Answer
touch :- used to change the time stamps

Syntax :- touch  options expression filename(s)
          where expression consists of eight digit number 
using the format MMDDhhmm(month,day,hr & min)
E.g :- $ touch 03091245 emp.lst ; ls -l emp.lst 
-rw-r--r-- 1 kumar  metal  870 Mar 09  12:45 emp.lst

The -m & -a options chng the modifications & access times.
$ touch -m 02281030 emp.lst ; ls -l emp.lst
-rw-r--r-- 1 kumar  metal  870 Feb 28 10:30 emp.lst
 
0 Deepti Shrivastava
 
 
Answer
touch -d '14:14' emp.lst
 
0 Jin
 
 
Answer
TOUCH -T [CCYYMMDhhmm] Filename in HP-UNIX
 
0 Anilkumar
 
 
Answer
For linux user, use the following command.
$touch -t yyyymmddhhmm.ss filename
 
0 Ashok Shah
 
 
Answer
The folwing command used for the above question

touch -m -a -t 08271113 abc.txt

here the format which we nee to specify is as below.
08271113 
mmddhhmi

Regards,
Sudhir
 
0 Sudhir
 
 
Question   How can we create more than 20 ID's in Gmail.com from one IP ? Rank Answer Posted By  
 Interview Question Submitted By :: Scott
I also faced this Question!!   © ALL Interview .com
Answer
You could as long as every session goes with different 
protocol number. 

Port address translation does that.
 
0 Gnanaprakash
 
 
Question   What is the exact difference between Integration & System testing; give me examples Rank Answer Posted By  
 Interview Question Submitted By :: Gayathriseetha11
I also faced this Question!!   © ALL Interview .com
Answer
integration testing is performed when any of the two or more
components are joined together to work as one. it may be
integration of two systems or two modules or so. in case of
integration testing we test that are those components
capable of working together. In case of integration testing
interfaces of joined components is given more importance. it
is checked that the data flow b/w the components is correct
and their shld be no leakage at the interface and so on.
But in case of system testing we test the sys as whole for
both its functional and non functional requirements.
 
0 Meenakshi
 
 
Answer
intergration testing means data flowing between 2 modules.

system testing means end to end testing done by end user 
and testing engineer.
 
0 Pradeep.s
[3i-infotech]
 
 
Answer
Integration Testing;

The unit tested module has to be integrated to build the 
application.

For Eg: When we test the With draw and Deposit option after 
integrating both the functionality it is the integration 
testing

where as System Testing involves testing the entire 
functionality of the application.

EG; Testing the all the functionalities in Banking
 
0 Lakshmi
[3i-infotech]
 
 
Answer
A. integration testing:testing of combined parts of an 
application to determine if they function together 
correctly. The 'parts' can be code modules, individual 
applications,client and server applications on a network, 
etc. This type of testing is especially relevant to 
client/server and distributed systems.


System Testing:system testing will conducted on the entire 
system to check whether 
it is meeting the customer requirements r not
 
0 Malaprabakar
[3i-infotech]
 
 
Answer
Integration Testing:
its the process of testing that the testing conducts at 
the  combination of all modules of the application to check 
app behaves as per the requirement
ex: 1.Dataflow
    2.comined modules
system Testing:
its the process of testing to check entire application that 
if the app behaves as per the requirement
ex: 1.end to end testing
    2.site testing
    3.menu testing
    4.navigation testing 
in system testing it covers all the functional and non-
functional and usability testing.
f.testing is +ve,-ve,valid,invalid,within range,without 
range.
non.f.t is 
relibility,compatability,configuratation,installation,datavo
lum testing....
usabulity testing is userinterface and manual supported 
testing.
 
0 D.radhika
[3i-infotech]
 
 
Question   How do you go about testing a web application? Rank Answer Posted By  
 Interview Question Submitted By :: Gayathriseetha11
I also faced this Question!!   © ALL Interview .com
Answer
We can test a web application by measuring the response 
time by using visual studio.
 
0 Darshan
 
 
Question   What is an equivalence class Rank Answer Posted By  
 Interview Question Submitted By :: Gayathriseetha11
I also faced this Question!!   © ALL Interview .com
Answer
Equivalence Class Testing is when you create sets of input
that have equivalent expected behavior. You do this until
all possible inputs show up in one of the groupings. Now
when you test one item from each of the inputs you should be
covering all the possible inputs in that grouping.

Some types of inputs lend themselves really well to this
type of testing – the first is a range of values. You break
it down into values within the valid range, invalid values
above the valid range and invalid values below the valid
range. Lets have an example to better illustrate what I am
trying to describe. We are going to test the
appointment-making part of the program. An appointment has
four fields:

   1. Time
   2. Day
   3. Month
   4. Year


Lets look at the month input field. Depending on how it is
implemented it could take valid values from 1-12 or it could
take the months in a string format. Lets look at the input
of values from 1-12 and what equivalence classes world be
necessary to test this input.

    * valid range of 1-12
    * invalid range below the valid range <1
    * invalid range above the valid range >12


If the input was a string you would end up with two sets.
One that had the valid inputs in it and one that had every
thing else you could think to put in it.

So along with the month input you would also have a day,
year, and time input. The program is written in such a way
that they all have to be tested at the same time. So you
list all the groupings for all the other inputs fields and
test them at the same time. You will notice that you can
test most of the valid test cases at the same time, but you
will have to test the error cases one field at a time so you
can make sure the error is handled appropriately.

This kind of testing will allow you to keep the number of
test cases small, and you could use this type of testing at
any level of testing from unit all the way up to acceptance
testing. One of the limiting factors of this type of testing
is that it assumes identical behavior for all items in a
grouping. This is best suited to testing programs where
inputs are within ranges or values in sets
 
0 Gayathri
 
 
Answer
EQC =equlience class particision, this is used to find the 
defect in less time, by dividing 
example in a login screen user ID accpect up 100 string ,if 
we want to test every time we have to pass onstring and it 
is time waste ,so we divide in to 10 parts and check
 
0 Bayana
[3i-infotech]
 
 
Answer
E.C.P is equivalence class Partision.
Its one of the Block box testingteschnique.
In this the data can be devided into two different classes.
those are
1.valid
2.invalid
ex for valid data:
for ex user enter name with alphabets and 4 to 16 chracters 
long
Then it allows only alphabets and 4 to 16.then only cond. 
is pass
ex for invalid test:
if user enter name field <4 then test fail
if user enter name field >16 then also test fail
if user enter name with special character like ,.?
*&@...test fail
all these are invalid data
 
0 D.radhika
[3i-infotech]
 
 
Question   What are the properties of a good requirement? Rank Answer Posted By  
 Interview Question Submitted By :: Gayathri
I also faced this Question!!   © ALL Interview .com
Answer
Requirements should clear, complete and precise.

PK
 
0 Pk
 
 
Answer
A Good Requirement is one which covers all the required 
features(Functions).The Required features should be met.
Even the usability features and Performance requirements 
should be mentioned in it.
 
0 Chethan P
 
 
Question   How to do test if we have minimal or no documentation about the product? Rank Answer Posted By  
 Interview Question Submitted By :: Gayathri
I also faced this Question!!   © ALL Interview .com
Answer
Well one can proceed with adhoc testing .

mail:akshay_bali2001@yahoo.co.in
 
0 Akshay
 
 
Answer
Proceed with Exploratory testing
 
0 Narendra
 
 
Answer
In this case we can perform exploratory testing.There is 
one more option before commencing actual testing we can 
consider application as specifiaction & use it. we can take 
out notes regarding different functions in application.How 
it should work? Now we can refer this document as 
substitute for specification.
 
0 Varsha
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com