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
 
Categories  >>  Software  >>  ERP CRM  >>  SAP  >>  ABAP
 
 


 

 
 Basis interview questions  Basis Interview Questions
 ABAP interview questions  ABAP Interview Questions
 SAPScript interview questions  SAPScript Interview Questions
 SD interview questions  SD Interview Questions
 MM interview questions  MM Interview Questions
 QM interview questions  QM Interview Questions
 PP interview questions  PP Interview Questions
 PM interview questions  PM Interview Questions
 PS interview questions  PS Interview Questions
 FI CO interview questions  FI CO Interview Questions
 HR interview questions  HR Interview Questions
 SAP CRM interview questions  SAP CRM Interview Questions
 SRM interview questions  SRM Interview Questions
 APO interview questions  APO Interview Questions
 Business Warehouse interview questions  Business Warehouse Interview Questions
 Business Workflow interview questions  Business Workflow Interview Questions
 SAP Security interview questions  SAP Security Interview Questions
 SAP Interfaces interview questions  SAP Interfaces Interview Questions
 Netweaver interview questions  Netweaver Interview Questions
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions
 SAP B1 interview questions  SAP B1 Interview Questions
 SAP AllOther interview questions  SAP AllOther Interview Questions
Question 
Table ztest has a secondary index on the following fields:
tnum, tcode.
Select * from ztest where tnum ne '123' and tcode = '456'.

Why is the index not used in the above case?
Choices:
    a) Indexes are not allowed on Z tables
    b) Variables must be used, NOT literals
    c) Select individual fields, not select *
    d) Client is not in the where clause
    e) NE invalidates the use of an index

Info: Can someone explain in detail why this happened? It
will be really helpful to handle to case in Secondary index:
 Question Submitted By :: Blaster
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Table ztest has a secondary index on the following fields: tnum, tcode. Select * from ztest where tnum ne '123' and tcode = '456'. Why is the index not used in the above case? Choices: a) Indexes are not allowed on Z tables b) Variables must be used, NOT literals c) Select individual fields, not select * d) Client is not in the where clause e) NE invalidates the use of an index Info: Can someone explain in detail why this happened? It will be really helpful to handle to case in Secondary index:
Answer
# 1		 
In my opinion, the correct answer is 
E: NE invalidates the use of an index
 
Is This Answer Correct ?    5 Yes 1 No
Vkbpl6012
[LY]
 
  Re: Table ztest has a secondary index on the following fields: tnum, tcode. Select * from ztest where tnum ne '123' and tcode = '456'. Why is the index not used in the above case? Choices: a) Indexes are not allowed on Z tables b) Variables must be used, NOT literals c) Select individual fields, not select * d) Client is not in the where clause e) NE invalidates the use of an index Info: Can someone explain in detail why this happened? It will be really helpful to handle to case in Secondary index:
Answer
# 2		 
Correct Answer Is : " E ".

Reason(s) : Negation (In this case 'NE') of Index fields 
(in this case 'TNUM' will prevent DB Optimizer from 
considering the field when searching for a suitable Index)
 
Is This Answer Correct ?    5 Yes 0 No
Shatanjay
 
 
 

 
 
 
Other ABAP Interview Questions
 
  Question Asked @ Answers
 
sort statement can sort?  3
what is the diffrence between driver program and print program in sap script Satyam7
How to handle Error in LSMW. This is urgent anybody know this answer plz post me... Cap-Gemini2
what is the RANGES stmt used in ABAP. if anybody know this answer. plz post imdtly Accenture3
in bdc which method is suitable for back ground processing? HP4
After preparing the SAP script.what is the procedure to send that script to e-mail? Honeywell2
what is a ticket?  4
Types of windows and Difference between them in Scripts EDS1
explain any one in briefly what are the books we have to buy to study dont say see the help or abap 21 days if u have any other materials to study please suggest me i am unable to understand  2
can you create a table with out a data element? can you create a field with out a data element?  1
Smartform : how to print a smartform with portrait style and landscape style at the same time? TCS1
1.Can we see the output without print program in sap script,and can we fetch the data without printprogram?if yes how,pls reply in details. 2.What is table control in BDC? how can we handled in bdc? pls reply in details Accenture1
hai iam srinivas. I have done client copy in sccl for 800 client and i have stopped the process in middle unexceptedely and after some time iam unable to login into the client 800. error message is incorect password or inclient username. how to refresh the client or solve the problem. please me out in it.  3
What is the reason, a BDC program is working in 'A' mode but not in 'N' mode ? Syntel3
what is message type? Accenture3
what is the client on which u have worked? In real time ?  1
What is the significance of at line-selection event? Infosys3
difference b/w classical report and intractive report  7
types of windows in smartforms?difference between them?  1
what are the similarities between internal tables and structures?  3
 
For more ABAP Interview Questions Click Here 
 
 
 
 
 
   
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