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:
2 8722In Open SQL statements such as Insert update delete which one is FASTlLY retrieve the results and which one is Efficient?
4 10859Function Module to upload the Excel sheet into SAP Internal Tables. * a) GUI_UPLOAD b) CL_GUI_FRONTEND_SERVICES=>GET_UPLOAD_DOWNLOAD_PATH c) CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD d) All the above
2 19784Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.
1992By default SAP provides locking mechanism if db is being used by a user ,then what is the use of writing enque method in your code?
1 4764Post New SAP Labs SAP ABAP Interview Questions
Are database administrators in demand?
Define discount orientation & upscale orientation
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Can we inherit abstract class in c#?
Will microsoft office sharepoint server 2007 run on a 64-bit version of microsoft windows?
What is a natural primary key?
Difference between page views and sessions.
how to use of tally in retails chemist / medical shop ( show in MRP Batch Exp date )
Is android or iphone better?
What is the purpose of deselecting all() method?
Define Primary page and its benefits?
Can I reinstall windows 10 without a disk?
What is tier price in magento?
what is the similarity between networking devices?
Why is the importance of a consistent style?