| Back to Questions Page |
| |
| Question |
in SDLC,at what phase life cycle stops?and what are the
input and output of each phase? |
Rank |
Answer Posted By |
|
Question Submitted By :: Priya |
| This Interview Question Asked @ Tanla-Solutions |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | In SDLC life cycle never stops untill the pplication/product
becomes outdated or obsolete.
One thing i want to clear you friends
Typical SDLC phase looks like
Requirement Gathering
\
Requirement Analysis
\
Design
\
Coding & integration
\
Testing
\
Deployment
\
maintanenece
The above Seven are the major and important SDLC Phases.
ofcourse one can think that after deployment of
application/product in client enviroment development
process will be ended.
But in real it never ends like that.After deployment client
may need some changes or some additions or some pathches
to fix bugs or support.
So life cycle never ends until the product/application
alive.
ok friends Byee
Rajendra Prasad
rajendra-penumalli@yahoo.com
hyd
9885162742  |
| Rajendra Prasad Reddy |
| |
| |
| Answer | Priya if you agree that answer ok others wise give question
once again
With clearly please.
My name is k.chandra sekhar
My phone no is 09246540049
I am in hyderabad
My mail id is ndra_143@yahoo.co.in
If any body want full explain send that mail  |
| K.chandra Sekhar |
| |
| |
| Answer | Hi rajendra ,
I too agree with your answer , but i want one small
clarification from your end, why "water fall model"
is only used by few organization . (most of the people are
having Opinion like, all the stages in this model are
interdependend ,if one stage out put or input went wrong
total project will colapse, do u have any idea on this.  |
| Praveen |
| |
| |
|
|
| |
| Answer | hai rajendra this is abhinav
THE MOST OF THE COMPANIES USED WATER FALL MODEL WHY BECAUSE
IN THIS MODEL THE COST OF THE PROJECT IS TOO LOW WHEN
COMPARED WITH ANOTHER MODELS
THIS MODEL IS USED WHEN THE CLIENT
REQUIREMENTS ARE CLEAR FOR THAT PROJECT  |
| Abhinav |
| |
| |
| Question |
How many key flexfields are there in Oracle HRMS? What are
they? |
Rank |
Answer Posted By |
|
Question Submitted By :: Oracle Hrms Consultant |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | There are 7 key flexfields in oracle HRMS. They are
1. Job Flexfield
2. Grade Flexfield
3. Position Flexfield
4. People Group Flexfield
5. Competence Flexfield
6. Collective agreement grade Flexfield
7. Cost Allocation Flexfield
 |
| Oracle Hrms Consultant |
| |
| |
| Answer | KEY FLEXFIELD (KFF)IN HRMS APPLICATION
JOB FLEXFIELD (JOB)
POSITION FLEXFEILD (POS)
GRADE FLEXFEILD (GRD)
PERSONAL ANALYSIS FLEXFEILD (PEA)
SOFTCODED FLEXFEILD (SCL)
WE HAVE OTHER 3 MORE WHICH ARE USED IN PAYROLL
BANK DETAILS (BANK)
COST ALLOCATION (COST)
PEOPLE GROUP (GRP)  |
| Ravi Kumar |
| |
| |
| Answer | first is the correct one  |
| Ashic |
| |
| |
| Answer | JOB FLEXFIELD (JOB)
POSITION FLEXFEILD (POS)
GRADE FLEXFEILD (GRD)
PERSONAL ANALYSIS FLEXFEILD (PEA)
SOFTCODED FLEXFEILD (SCL)
CCOMPETENCE FLEXFEILD(CMP)
COLLECTIVE AGREEMENT(CAGR)
WE HAVE OTHER 3 MORE WHICH ARE USED IN PAYROLL
BANK DETAILS (BANK)
COST ALLOCATION (COST)
PEOPLE GROUP (GRP)  |
| Ravi Kumar |
| |
| |
| Answer | There are 8 key flexfields in oracle HRMS. They are
1. Bank Details Flexfield
2. Cost Allocation Flexfield
3. Grade Flexfield
4. Job Flexfield
5. People Group Flexfield
6. Personal Analysis Flexfield
7. Position Flexfield
8. Softcoded Flexfield
 |
| Dayaram Lo |
| |
| |
| Answer | There are totally 37 Kef Flexfield
in which HRMS we have 7 KFF
1. Job Flexfield
2. Grade Flexfield
3. Position Flexfield
4. People Group Flexfield
5. Competence Flexfield
6. Collective agreement grade Flexfield
7. Cost Allocation Flexfield  |
| Magesh |
| |
| |
| Answer | The main 6 Key Flexfields are
Grade
Position
Jobs
People Group
Cost Allocation
Competenicies  |
| Natasha Blazey |
| |
| |
| Answer | There are 8 flexfields in oracle HRMS
1. Job Flexfield
2. Grade Flexfield
3. Position Flexfield
4. People Group Flexfield
5. Competence Flexfield
6. Collective agreement grade Flexfield
7. Cost Allocation Flexfield
8. Item Contexts Keyflex  |
| Vivek Tyagi |
| |
| |
| Answer | There are 8 Key FlexFields in Oracle Apps(HRMS Module).
They are broadly classified as
1.Oracle Payroll
2.Oracle Core HR
Under Oracle Payroll the flexfields are :
:People Group
:Cost Allocation
:Bank Details
Under Oracle Core HR the flexfields are :
:Job
:Position
:Grade
:Competency
:Personal Analysis  |
| Arun Samal |
| |
| |
| Question |
what is the basic knowledge required to work in BFSI
domain ? |
Rank |
Answer Posted By |
|
Question Submitted By :: Srinivas |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Well, you can discuss it in www.bfsiforums.com - The free
online communities for the Banking, Financial Services, and
Insurance (BFSI) World. BAs, PMs, Professors and many
others join there to discuss several types of topics.  |
| Shailaja |
| |
| |
| Question |
plz explain vss? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ MBT |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Vss ( Visual source safe ) .It is a common repository where
we maintain all our information like documents
(FRS,SRS,TP,Test case documents etc). In this all the
documents are read-only . If we want to modify that first
we need to check out (download ) the required file to our
local system then modify the file and then check in
(upload) the modified one.  |
| Jhansi |
| |
| |
| Answer | Ur Correct Jhansi..
and can u explain the working directory in the VSS  |
| Archana |
| |
| |
| Answer | vss is configuration tool which stores sourcecode saftly
and creates no of duplicate duplicate builds which are
released to testing team, so that even though testing
modifies the source code or built that will not effect
original source code.  |
| Masaram |
| |
| |
| Answer | a) VSS stands for visual source safe.
b) VSS is nothing but configuration management tool
c) VSS is a virtual library of computer files.
d) VSS is a common repository
e) In VSS store the information like FRS, SRS, TP,
Test cases documents
f) In VSS documents read only but not modifying
g) If we want to modify that first we need to check
out (download) the required file to our local system then
modify the file and then check in (upload) the modified one.
My name is k.chandra sekhar,
My phone no is 09246540049,Hyderabad.
My mail id is ndra_143@yahoo.co.in
I am take the class for projects if you interst contact
If any body want full explain send the mail  |
| K.chandra Sekhar |
| |
| |
| Answer | as our friends said it has the ability to safe running of
the project, by useing this we can know the modifications
made, and the persons who had done the modifications by
selecting the "History"(Give the Right click on the file or
project then select the History, u vil get the history of
that). One more advantage with this is u can differentiate
the present project r file with the older (Comarision of
files or projects can be done)by simply selecting the two
files or any thing which u want and then give the right
click then click on the "Compare". We get the differences
between the two. it has lot of uses. if possible i vil
attach the material regaring VSS , but i need a couple of
days,k.
Guys if i am wrong, pls correct me  |
| Divya |
| |
| |
| Answer | 1.vss is configuratuion management tool
2. main advantage is when ever we make change in any file
it will autogenerate the new version
3.security
4.in vss we have check-in and check-out i.e the file will
be in read only mode,if we want to make any changes in that
file we have to check-in after completion we have to check
out.  |
| Ramarao |
| |
| |
| Answer | VSS- VISUAL SOURCE SAFE,
1)WHERE THE DEVELOPERS KEEP CODE SECURE,i e . NO ONE PERSON
CAN ENTER
2)ONLY ADMIN HAS RIGHTS TO DO ANY THING
3) IN OUR COMPANY WE ARE MAINTAINING URL-INETPUB-WWWROOT....
4) IF DEVELOPER DEVLOPS THE CODE AND SEND A MESSAGE TO THE
ADMIN TO GET THE LATEST VERSION OF PARTICULAR MODULE(IT
WILL HAPPEN BY TAKING RIGHT CLICK AND GET LATEST VERSION)
5)AFTER THAT TAKE A RIGHT CLICK AND REBUILD THE PROJECT IN
DEBUG MODE
6)MAKE SURE THAT TAKE BACK UP FOR EVERY MODIFICATION( i e
IS BETTER FOR U ONLY MY DEAR
7)EVERY WEEK MAKE SURE THAT, TAKE A BACK UP FROM THE VSS
SERVER  |
| Vamsi Krishna |
| |
| |
| Question |
write a test case on web login and bank application and
client server |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ MBT , Semantic Space, Tcs |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | a) Enter the URL check the login page open or not
b) Default focus should be on user name
c) Pass word should be encrypt ional format or not
d) Pass word should not get copy or not (that is
ctrl+c, mouse right click, edit have copy disable not work)
e) Input domain testing on user name (that is boundary
value analysis)
f) Input domain testing on pass word (that is boundary
value analysis)
g) Properties check on buttons (that is able or
disable or not)
h) Functionality check on the buttons (it work correct
or not)
i) Authorization testing (that is valid or invalid
values are allow or not)
j) Ceysincitive check on the login page (that is allow
the cap or small letters)
k) After the sing out login come back to your previous
page login is must and should expired text.
l) Enter into the after login page copy the URL and
click after on the logout past the URL then open should not
allow.
m) Check the assignation time with respect to client
n) Check the cockers
o) Check the single user or multi-user are use
p) Check the usability of the login page
q) Under usability look and fell, spieling mistakes,
colures, font sieges and so on.
My name is k.chandra sekhar,
My phone no is 09246540049,Hyderabad.
My mail id is ndra_143@yahoo.co.in
I am take the class for projects if you interst contact
If any body want full explain send the mail  |
| K.chandra Sekhar |
| |
| |
| Answer | # 1 a) Enter the URL check the login page open or
not
b) Default focus should be on user name
c) Pass word should be encrypt ional format or not
d) Pass word should not get copy or not (that is
ctrl+c, mouse right click, edit have copy disable not work)
e) Input domain testing on user name (that is boundary
value analysis)
f) Input domain testing on pass word (that is boundary
value analysis)
g) Properties check on buttons (that is able or
disable or not)
h) Functionality check on the buttons (it work correct
or not)
i) Authorization testing (that is valid or invalid
values are allow or not)
j) Ceysincitive check on the login page (that is allow
the cap or small letters)
k) After the sing out login come back to your previous
page login is must and should expired text.
l) Enter into the after login page copy the URL and
click after on the logout past the URL then open should not
allow.
m) Check the assignation time with respect to client
n) Check the cockers
o) Check the single user or multi-user are use
p) Check the usability of the login page
q) Under usability look and fell, spieling mistakes,
colures, font sieges and so on.
My name is k.chandra sekhar,
My phone no is 09246540049,Hyderabad.
My mail id is ndra_143@yahoo.co.in
I am take the class for projects if you interst contact
If any body want full explain send the mail  |
| Srikanth |
| |
| |
| Answer | Mr. Chandra sekhar, i think you need to join some tution
instead of urging others to join your coaching classes. You
badly need to improve your English. Hope my point justifies
the lack of students in your coaching classes.  |
| Suresh |
| |
| |
| Answer | You are correct Suresh.  |
| Rams |
| |
| |
| Answer | I too agree with u guys the person need improve his english
alot instead of posting answers for the questions  |
| Aravind Kumar |
| |
| |
| Answer | Hi Everyone,
the important thing is k.chandra has specified the correct
testcases for the login page.
but you can give hime suggesstions regarding english
improvement  |
| Kavita |
| |
| |
| Answer | Chandra shekhar has really done a good job, i mean his test
cases are really good covers almost all requirements.
Thing here is to appreciate for his test cases and not to
point his language.
I know communcation really plays a role but here its thing
more to appreciate rather than discouraging the person.
I agree that it will be more helpfull to chandra shekhar if
he can improve his language or vocabulary.  |
| Nuthan |
| |
| |
| Answer | Though his test cases are right, without good written
skills even the best tester can't be a successful tester.
There is a lot of difference between being a good tester
and a successful and recognised one.Tester job is not only
to test but to communicate his test findings to others. Bug
reporting etc.  |
| Testing Is An Art |
| |
| |
| Answer | it would be better if u people give answers rather that
these junk suggestions..  |
| Suman |
| |
| |
| Answer | Mr Suresh,
I think you are an overconfident, idiot and worst person on
the earth who can not understand the answer and checkinh
the grammar.
You donot have any manners .... Nobody taught you basic
manners..???
Be ashamed of your indulgence.  |
| Anjali |
| |
| |
| Answer | Dear Anjali,
I am strongly agree with you and also appreciate Mr.
Chandra Shekhar that he has posted answers. But It is also
very important thing to communicate and writing well. So I
give Chandra to 6 points out of 10. Moreover, he should
also concentrate on his grammatical mistakes.
Good Luck,  |
| Mukesh Kumar Chauhan (mkc) |
| |
| |
| Answer | Hey fellows,
Its a bad thing to criticise a person.No body is genius
from beginning.If you are in good position dont let other
people down please.That's a very bad habbit.We have to
appreciate his knowledge in testing,which we dont have.  |
| Xyz |
| |
| |
| Answer | Hi..Gays
Chandu covered all the possibilities. thanks chandu keep
answering.
i think suresh,rams, and chamcha aravind should change
there mind setup. he given an idea, if u people like this
post thanks(he did't expect that also), but don't discourage
him.
i thihnk suresh need yoga. be cool man...  |
| Naresh |
| |
| |
| Answer | Test Cases rae really good.  |
| Pc |
| |
| |
| Question |
in script can i print the back page of a paper |
Rank |
Answer Posted By |
|
Question Submitted By :: Niladri.pradhan |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Easy - page FRONT lists page CONTACTS as next page and
CONTACTS lists FRONT as next page. Since CONTACTS does not
contain a MAIN
window, it will print the contacts info and then continue
on to FRONT for the rest of the main items. Additionally,
set print mode on FRONT to
D (duplex) and set CONTACTS to 'blank' (for both resource
name and print mode - this is the only way to get to the
back of the page).  |
| Komal |
| |
| |
| Question |
if a problem on client side is restarting of PC then what
are u going to do and say me the methods to solve the problem? |
Rank |
Answer Posted By |
|
Question Submitted By :: Abhesheke |
| This Interview Question Asked @ Mantra-Group |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | 1) check the connections i.e all the connections should be
tight & accurate
2)scan for viruses sometypes of viruses causes restarting
of computer
3) in very rare cases there may be problem in button of
restarting the computer on cabinet  |
| Ramandeep |
| |
| |
| Answer | Restarting of PC happens when
1.CPU temperature is exceeded than rated temperature
Normally this is due to Improper contact between Heatsink
surface and CPU surface.When the conact is week or improper
between the cpu and Heat sink the CPU core teparature rises
enormously and the CPU thermalShutdown protection system
causes to cuttoff the powersupply for the CPU to safe guard
from thermal damage.
The above cuase is general and Most happening.
apart from this cause some other factor may also cause
system restart.
Viruses will terminate the OS processes so it causes to
shutdown.
Incompatible extension cards,unstable software
installations are the other class of causes for system
shutdown.
ok
byeeeeeee
rajendra_penumalliyahoo.com
hyd
9885162742  |
| Rajendra Prasad Reddy |
| |
| |
| Answer | a) Actual that is not tester problem
b) That is client side problem
c) Why I am involving
d) If any case I involve the time then I will give the
some suggestion also.
e) If I can possible some adjust meant after work it
ok, no problem other wise call to the hardware engineer
that is the main solutions
My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in
If any body want full explain send that mail  |
| K.chandra Sekhar |
| |
| |
| Question |
say me any problem u faced in the project after delivering
to client? |
Rank |
Answer Posted By |
|
Question Submitted By :: Abhesheke |
| This Interview Question Asked @ Mantra-Group |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Mainly the project will be divided in to builds. Build
wise, we can come to conclusion what is the percentage of
testing finished. After delivering the Build to customer we
will be getting the build status and where the events has
failed. keep track of those events and see that those are
not repeated in the next build. Like wise at the last
deliverable the client comes and we come to conclusion that
the product is stable.
After delivering it to client, and if any problem arises
they will be having the back up of documents. Before that
the product will be in support for some months according to
the client. Once the client has given SOW sign off and then
the problem comes, we are not responsible for it. But there
will be set of people if any problem co9mes in the project
after delivering to client to solve the problems.
If any queries, call me to 9440567637.  |
| Arjun Reddy.n |
| |
| |
| Answer | a) Actually I am not involved this type problem that
not client side problem but I am not involve in my
experience
b) I thing that maintain the other team product team
c) In client side have lot of problems have but I
never not face
My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in
If any body want full explain send that mail  |
| K.chandra Sekhar |
| |
| |
| Question |
what is the testing process followed in your company? |
Rank |
Answer Posted By |
|
Question Submitted By :: Abhesheke |
| This Interview Question Asked @ Mantra-Group |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | The testing process differs from company to company
according to their quality standards. But 90% of the
companys will be using the V process model for accurate
results.
Follow V process model, thats enough.  |
| Arjun Reddy N |
| |
| |
| Answer | say hybrid a combination of many models so that what ever
you say you can defend.  |
| Kumar |
| |
| |
| Answer | a) This is very silly question
b) Every interview person asked this question, but I
will give the one ex
c) What is the your daily work mean what is your answer
d) That answer is your choice because every one has
the good daily work but not the same constant same like the
company tell to the some v-mode but not 100% follow the v-
mode
e) The v-model is the one of the good measurement of
testing that why all companies saying using v-mode and so
on.
My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in
If any body want full explain send that mail  |
| K.chandra Sekhar |
| |
| |
| Question |
what is meant by spiral model?explain with picture? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ TCS |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | a) Spiracle model is nothing but version by version
model
b) That is 1st version when completed after the hear
UAT is done after go to the next version or build
c) This is very risk modal according to application
developments companies.
d) The project have so many risks
e) And Client requirements also be changes
continuously in the project
f) Picture is not necessarily
My name is k.chandra sekhar,
My phone no is 09246540049,
Hyderabad.
My mail id is ndra_143@yahoo.co.in
If any body want full explain send that mail  |
| K.chandra Sekhar |
| |
| |
| Answer | Whenever the requirement is not stable and cannot to freeze
the requirement, Spiral model will be followed.
picture
requirement ---> design ---->code ----> implementation
Then it stats from the requirement. ie, whenever the
requirement is coming the flow will start from requirement
phase to the implementation phase.
 |
| Krishnaveni |
| |
| |
| Answer | spiral model was developed by Garry boehm.It combines the
systematic aspects of the water fallmodel & itertative
nature of the prototyping model.It is used for the projects
which involves greater risk.  |
| Sarita |
| |
| |
| Question |
How you will do client copy? If SAP * user is not available
at all
in your system then how u will do client copy?
|
Rank |
Answer Posted By |
|
Question Submitted By :: Shrikant_mhaske |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | First define a client using SCC4, login into target client
using SAP* and then run SCCL to do client copy.  |
| Zack |
| |
| |
| Answer | there is no question of not having sap* in the system.why
because even if the sap star is deleated it will get back
when ever the system is restarted at that time the password
must be PASS.  |
| Ganesh |
| |
| |
| Answer | i think, goto instance profile from RZ10 and change parameter
0 to 1. so that now u can login with SAP*. and u can do the
client copy.  |
| Nirgun |
| |
| |
| Answer | go to rz10 and change parameter
login/no_automatic_user_sapstar 0 to 1. so u can login with
sap*.  |
| Nirgun |
| |
| |
| Answer | Client Copy:we do it by the transaction Sccl.
now coming to the question (sap* user if not available)
i never heard of this question as i am a fresher but if
such case exists cant we go for Remote client copy
think...?This is my answer.  |
| Manjula |
| |
| |
| Answer | Just goto RZ04 and increase the number of background
processes in the specified operation mode.
We do a system copy using SCCL transaction.
If SAP* is not available, login at OS level as SIDADM and
sqlplus /nolog
connect /as sysdba;
delete sapsr3.usr02 where mandt='<client no.>' and
bname='SAP*';
goto /usr/sap/SID/SYS/profile and change the default
profile.
Add the parameter login/no_automatic_user_sapstar=0
0R
goto RZ10,select default profile and extended maintenance
and change.
add the parameter login/no_automatic_user_sapstar=0 here
Hope it helps.
Raghu Chukkapalli  |
| Raghu Chukkapalli |
| |
| |
| Answer | There are 2 types of client copies
Remote Client copy
Local Client copy
Local client copy : it is in the system , between different
clients
Remote client copy : it is between the different systems on
landscape
for these client copies to take place parameters required
are
source system
target system
rfc destination
and the transport layer should be fine assumin all this ok
now go to other system
create a new client
copy the sap* to newly created client
try to import that client , by copying the changes to
transport directory or via ftp  |
| Karthik |
| |
| |
| Answer | Whenever you create new client ,automatically sap* login is
created by default in new client,with pass word pass .
so how we can say that if sap* not available at all
sO EXPERT GUYS GIVE ME THE ANSWER OF THIS QUESTIONS ?
i THINK QUESTION ITSELF IS A GOOGLY QUESTION PLS REPLY IA M
RIGHT OR WRONG ?  |
| Rohit Kawankar |
| |
| |
| Answer | look up the anwser in oss lazybones  |
| Bb |
| |
| |
| Answer | the is no question of not having a user sap* .
and if you forget the password, just go and delete the user
from os level. system will create the user sap* by itself
and password will be pass.
and i think any superuser can do the client copy.  |
| Arjun |
| |
| |
| Answer | When ever we create new client user SAP* is default for new
client. Make sure values for
login/no_automatic_user_sapstar parameter set to 0. And
login to new client as SAP* with password. Until SAP* is
created in any new client the validation is always from OS
level. If SAP* creates in client then the validation is
from database.  |
| Patchipala |
| |
| |
| Question |
If a user wants to execute a background job immediately but
there is no Background work process available. How u will do?
|
Rank |
Answer Posted By |
|
Question Submitted By :: Shrikant_mhaske |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | there is no other chance we have to wait for the work
process to complet. if not give A in catagery...  |
| Ganesh |
| |
| |
| Answer | You can use transaction RZ04 to define Operation mode with
background work process.  |
| Krushna Biswal |
| |
| |
| Answer | Please don't post the same questions again and again..
Anyways..
Goto /nrz04 and change the number of background jobs in the
given operation mode.
Hope it helps.
Raghu Chukkapalli  |
| Raghu Chukkapalli |
| |
| |
| Answer | Using the concept of operation mode you can define the
additional background work process by Tcode RZ04
we can than perform a manual operation mode switch using
tcode RZ03.Then there is no need to restart the systen.
VIKRAM SINGH  |
| Vikram Singh |
| |
| |
| Question |
What are Homogenous system copy and Heterogeneous system
copy and
how you will do that?
|
Rank |
Answer Posted By |
|
Question Submitted By :: Shrikant_mhaske |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Homogeneous copy is done when the source and target system
are on the same OS and Databse.
Heterogeneous Copy is done when the source and target
system differ either in OS or Database. Any ONE difference
needs a heterogeneous copy.
Homogenous copy is done by export/import technique.
Heterogenous copy is done by system migration. It is same
as export/import except that it will ask for target OS and
DB type and needs a key to be entered.
Hope it helps.
Raghu Chukkapalli.  |
| Raghu Chukkapalli |
| |
| |
| Question |
How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table? |
Rank |
Answer Posted By |
|
Question Submitted By :: Seshu |
| This Interview Question Asked @ Wipro , Wipro |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | select * from education where rownum < ( select max(rownum)
from education group by <column_name> )  |
| Harish |
| |
| |
| Answer | SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>  |
| Lavanya |
| |
| |
| Answer | SELECT COUNT(EMPNO),ENAME FROM EDUCTION
GROUP BY ENAME;  |
| Dawood |
| |
| |
| Answer | select * from emp a ,
(select empno,count(*) from emp group by empno having count
(*) > 1) b
where a.empno = b.empno  |
| Lakshmi Narayana |
| |
| |
| Answer | In the above query we have to add distinct before *. Else
duplicate rows will be fetched twice.
Thanks,
Lakshmi  |
| Lakshmi |
| |
| |
| Answer | select * from taruntest1 b where rowid not in (select min
(rowid) from taruntest1 a where a.a=b.a );  |
| Amit |
| |
| |
| Answer | select a.empno, a.empname from education a,
(select empno, count(*) cnt from education group by empno
having count(*) > 1) b
where a.empno = b.empno
is the correct answer  |
| Smita |
| |
| |
| Answer | For Sample:
----------
select count(pmid) as Occurances,pmid from tablename group
by pmid having count(pmid)>1  |
| Balaji |
| |
| |
| Answer | SELECT ProductName
FROM Products
WHERE (ProductName IN
(SELECT ProductName
FROM Products
GROUP BY ProductName
HAVING COUNT(*) > 1))  |
| Rajesh Kumar Patnaik |
| |
| |
| Answer | SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;  |
| Seshu |
| |
| |
| Answer | select SPAN_UUID, SPAN_UNIT_UUID, count(*) from
SPAN_SPAN_UNIT group by SPAN_UUID, SPAN_UNIT_UUID having
count(*) > 1;  |
| Aravind |
| |
| |
|
| |
|
Back to Questions Page |