DDIC(Data dictionary) interview questions
1. What is the search help? How many types of search helps?
Ans: Search help is used to provide the list of possible values to the
Input variable
There are 2 types of search helps: 1.Elementary search help
2. Collective search help
2. What is the match code object? In which scenario we use match code object?
Ans: Match code objects are used to provide the list of possible values to
The input variable. This is similar as search help
In real time, whenever we are working with material doc number (MBLNR),
Then we must provide the match code object because MBLNR have no
Search help.
3. What is the hotkey?
Ans: Hotkey permits the user, to select an elementary search help from collective
Search help by using short notions.
4. Can we create the search help with more than one db table Fields? If yes then
how?
Ans: Yes we can create.
With the help of database view or help view
5. What are the types of DB tables and example?
Ans: There are 3 types of db tables
1. Transparent tables (ex: t001, kna1...)
2. Pooled tables (ex: A012.)
3. Cluster tables (ex: BSEG)
6. What is the TMG? What is the transaction code for TMG?
Ans: TMG is used to insert, update, delete the data of database table without any coding.
The transaction code for TMG is SM30
7. What are the events in TMG?
Ans: 1.Save before data
2. Save after data
3. Before deleting the data
4. After deleting the data
5. Create a new entry...
8. What are the maintenance types in TMG?
Ans: There are 2 types of maintenance types
1. One step
2. Two step
Maintenance type is one step means both maintaining data and display the data
In a single screen
Maintenance type is two step means maintaining the data in one screen and
Display the data in some other screen
9. What are differences between primary and secondary indexes?
Ans:
1. Without a primary index, we can't create data base table,
Without a secondary index we can create the database tables
2. We can place up to 16 primary keys per DB table,
We can place up to 9 secondary indexes per DB table
10. What are the pre-requisitions / Technical requirements to establish foreign key
Relationship?
Ans : 1.The domain name of the both the fields in both the tables must be the
Same
2. The check table field must be primary field
11. What is the use of buffering? What are the types of buffering?
Ans: Buffering is used to improve the performance of the system
There are 3 types of buffering: 1.Single record buffering
2. Generic area buffered
3. Fully buffered
12. What are the differences between value table and check table?
Ans: 1.In value table, the possible values are available in domain level
In check table, the possible values are available in check table
2. Value table is domain level mapping
Check table is field level mapping.
13. What are the differences between INCLUDE STRUCTURE and APPEND
Structure?
Ans: 1.Include structure is used to adding some additional fields to custom
DB table
Append structure is used to adding some additional fields to standard
DB table
2. The same include structure can be included in any number of custom
DB tables
The same append structure can't appended to more than 1 db table
14. What are the differences between Structure and DB table?
Ans: 1.Structure does not contains primary field
DB table must contains at least one field as primary field
2. Structure does not contains the data
DB table contains data
15. What are the differences between View and DB tables?
Ans: 1.Views are logical database, it does not contains the data permanently
DB Tables are physical database, it contains the data permanently
2. Fetching the data from view is little bit faster
Fetching the data from DB table is little bit slowly
16. What are the types of VIEWS?
Ans: There are 4 types of views
1. Projection view
2. Database view
3. Maintenance view
4. Help view
17. What is the use of MAINTENANCE VIEW?
Ans: Maintenance view is used to insert, update, delete the foreign key table data
Based on check table data, without any coding
18. What is the lock object? What are the types of lock modes?
Ans: Lock objects are used to avoid the concurrent access of multiple users on
the same Database
Here are 3 types of lock modes: 1.Write lock, 2.Read lock, 3.Exclusive but
not cumulative lock
19. What happened, when we create the lock object?
Ans: It generates 2 function modules
1. ENQUEUE ------->for locking
2. DEQUEUE ------->for unlocking
20. What is the use of custom include?
Ans: Custom include is used to adding some additional fields to standard db table
21. What is the default buffering at the time of creating the db table?
Ans: Buffering is not allowed
22. What are the differences between db view and help view?
Ans : 1.Database view pick the data from both the tables, if and only if there is
one or more than one entry is available in right hand side table, with
Corresponding left hand side table
Help view pick the data from left hand side table, even though there
is no match found in right hand side table
2. We can fetch the data from database view
we can't fetch the data from help view
23. Can we create the database table without data element?
Ans: Yes ,by using direct/ predefined type
24. Why we go for data element type to create the table?
Ans: if we want to link the any two db tables, then we must maintain the
same domain name in both the tables, in direct / predefined method there is no domain
concept, so we go for data element type
25. Can we delete the data element which is already used in table?
Ans : No
26. Can we delete the domain which is already used in data element?
Ans: No
27. What is the delivery class? What are the delivery classes are available?
Ans: Delivery class controls the transport of the data from one table to another table
Delivery class are: A,L,S...
28. What is the data class? And tell me some of the data classes?
Ans: Data class defines the physical area of the database, in where our table
is logically stored
some of the data classes are : APPL0,APPL1,APPL2....
29. What is the use of table type?
Ans: Table types are global, based on table type we declare the internal table directly.
30. What is the domain and data element?
Ans: Domain is the collection of data type and length
Data element is the collection of domain and short description
31. What is the use of field label?
Ans: if we are maintaining field labels in data element,
Whenever we create the TMG, then automatically we can get the heading
32. In which table contains unit of measurements and currencies?
Ans : T006 Contains all the unit of measurements
TCURC contains all the currencies
33. What is the transaction code for data browser?
Ans: SE16 is the transaction code for data browser
