Dictionary

ABAP DATA Dictionary
 1.     Search help is assigned to which level of the table? 
Answer:
A. Field
B. Domain
C. Data Element
D. A and C

 2.    Why ‘+’ sign is displayed instead of the field description while maintaining the table entries using tcode SM30? 
Answer:
A. Short description is not provided for the field
B. Data element Field label is not maintained
C. A and B
D. None of the above

 3.    Lock object is created with the initial letter ________?
Answer:
A. A
B. B
C. C
D. E

 4.  Value table can be assigned to ____?
Answer:
A. Data Element
B. Domain
C. Field
D. All the above

 5.  Conversion routine is assigned to ____?
Answer:
A. Field
B. Domain
C. Data Element
D. None of the above

 6.  We provide reference table and reference field to which type of fields?   
Answer:
A. Decimal
B. Currency
C. Quantity
D. B and C

 7.  Can we create transaction code for the table maintenance?   
Answer:
A. Yes
B. No

 8.  Without maintaining the following, the table cannot be activated:   
Answer:
A. Entry help/Check
B. Technical settings
C. Primary key
D. B and C

 9.  Text table should consist of?   
Answer:
A.  All the key fields of main table
B.  All the fields of main table
C. SPRAS field for the language key
D. A and C

 10.  What is the maximum number of structures that can be included in a table or structure?   
Answer:
A.  9
B.  8
C. 4
D. 7

 11.  Can we include customizing include or an append structure with Pooled or Cluster tables? 
Answer:
A.  Yes
B.  No

 12. Difference between table and structure:

   1. Table hold data only during runtime of program and structure hold it all the time
   2. Structure hold data only during runtime of program and table hold it all the time
   3. We need to define the primary keys for the structure and not for the table.
   4. We need to define the primary keys for the table and not for the structure. 

Answer:
A.  2 and 4
B.  1 and 2
C. 2 and 3
D. 3 and 4

13. We can assign search help to the select option or parameter using below statement:
Answer:
A.  Matchcode object
B.  Batchcode object
C. User command
D. None of the above  

 14.  Single record buffering should be used when _________.   
Answer:
A.  It should be used for large tables when there are few record accesses
B.  It should be used in large tables that have frequent access to
records
C. It should be used for those tables where some of the fields of
the table are needed
D. All the above

 15.  Difference between the projection view and the database view.   
Answer:
A.  Projection view can be created using one or more tables and database view be created using a single table
B.  Database view can be created using one or more tables and Projection view be created using a single table
C. None of the above

16.  Prerequisite for creating foreign key relationship are_____.   
Answer:
A.  The domain of the foreign key field and the primary key of the check table should be different.
B. The foreign key field and the primary key of the check table should have the same domain
C. A value table to the domain must be assigned
D. B and C

 17.  Whenever we create and activate the table below index will get automatically created.   
 Answer:
 A.  Secondary index
 B. Primary index
 C. Unique index
 D. None of the above

 18.  When we create the table, text table will automatically gets created.   
 Answer:
 A.  True
 B. False

 19.  We can create the table maintenance with below types of screens.   
 Answer:
 A. Overview screen
 B. Single screen
 C. A and B
 D. None of the above

 22.  Among the below which is not the valid delivery class.   
 Answer:
 A.  A – Application table  (Master and transaction data)
 B. C – Customizing table
 C. T  -  Temporary storage data
 D. S – System table

Ans : 1. D  2. B 3. D  4. B 5. B 6. D 7. A  8.D 9.D  10. A 11.B 12.A 13.A 14.A 15.B 16.D 17.B     18.B   19.C  20.C