Wednesday, 7 March 2012

100 TOP SAP - ABAP DATA Dictionary Interview Questions

Latest DATA Dictionary Interview Questions and Answers for freshers and experienced pdf
1.    What is an ABAP data dictionary?
2.    What are domains and data element?
3.    What is foreign key relationship?
4.    Describe data classes?
5.    What are indexes?
6.    Difference between transparent tables and pooled tables.?
7.    What are logical databases? What are the advantages/ dis-advantages of logical databases?
8.    When is it better to buffer the table?
9.    wher does information come from when you press f1 on a screen field?
10.    What is the differences between structure and table in data dictionary in ABAP?
11.    What is the difference between Table and Template?
12.    What is table buffer? Which type of tables used this buffer?
13.    What is Tcode SE16. For what is it used. Explain briefly?
14.    What is lock object ?
15.    What are the advantages and disadvantages of using views in ABAP programming ?
16.    How data is stored in cluster table?
17.    What are the different types of data dictionary objects?
18.    Can a transparent table exist in data dictionary but not in the data base physically?
19.    Can we create field without data element and how?
20.    Name the table name to store the output program names?
21.    Difference between .include and  .append structures?
22.    Buffering concept usage?
23.    What are the different buffering methods?
24.    Different types of locks?
25.    What is TMG?
26.    how we can retrive data using secondary index.explain with simple example
27.    How many types of tables exists and what are they in data dictionary? 
28.    What are the Different types of tables?
29.    Can a transparent table exist in data dictionary but not in the data base physically?
30.    Can you create a table with fields not referring to data elements? 
31.    What is the advantage of structures? How do you use them in the ABAP programs? 
32.    What does an extract statement do in the ABAP program? 
33.    When you extract the data, the record is filled with the current values of the corresponding fields?
34.    How are the date and time field values stored in SAP? 
35.    What happens when a table is activated in DD? 
36.    What is a check table and what is a value table? 
37.    What are match codes? describe? 
38.    What are logical databases? What are the advantages/disadvantages of logical databases? 
39.    How do you find if a logical database exists for your program requrements? 
40.    How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures? 
41.    How do you get help in ABAP? 
42.    What is cardinality? 
43.    You have added an append structure to a standard SAP table. What happens to the standard table when a new version of the table is imported during an upgrade?
44.    What are pooled table?
45.    What Function does data dictionary perform?
46.    What is view? Different types of view. Explain?
47.    What are the check tables and value tables?
48.    What is the difference between tables and structures?
50.    How many types of tables exist and what are they in data dictionary?
51.    What is a data dictionary?
52.    What functions does a data dictionary perform?
53.    What are the features of ABAP/4 Dictionary?
54.    What are the uses of the information in the Data dictionary?
55.    What are the basic objects of the data dictionary?
56.    What are the aggregate objects in the data dictionary?
57.    In the ABAP/4 Dictionary Tables can be defined independent of the underlying database?
58.    What is the significance of Technical settings (specified while creating a table in the data dictionary)?
59.    What is a Table attribute?
60.    What is the significance of Delivery Class?
61.    What is the max. no. Of structures that can be included in a table or structure.
62.    What are two methods of modifying SAP standard tables?
63.    What is the difference between a Substructure and an Append Structure?
64.    To how many tables can an append structure be assigned.
65.    If a table that is to be extended contains a long field, we cannot use append structures why?
66.    Can we include customizing include or an append structure with Pooled or Cluster tables?
67.    What are the two ways for restricting the value range for a domain?
68.    Structures can contain data only during the runtime of a program (T/F)
69.    What are the aggregate objects in the Dictionary?
70.    What are base tables of an aggregate object?
71.    The data of a view is not physically stored, but derived from one or more tables (t/f)
72.    What are the 2 other types of Views, which are not allowed in Release 3.0?
73.    What is a Match Code?
74.    What are the two levels in defining a Match Code?
75.    What is the max no of match code Id's that can be defined for one Match code object?*
76.    Can we define our own Match Code ID's for SAP Matchcodes?
77.    What is an Update type with reference to a Match code ID?
78.    Can matchcode object contain Ids with different update types?
79.    What are the update types possible?
80.    What are the two different ways of building a match code object?
81.    What are the differences between a Database index and a match code?
82.    What is the function of a Domain?
83.    Can you delete a domain, which is being used by data elements?
84.    What are conversion routines?
85.    What is the function of a data element?
86.    Can a domain, assigned to a data element is changed?
87.    Can you delete data element, which is being used by table fields?
88.    Can you define a field without a data element?
89.    What are null values?
90.    What is the difference between a structure and a table?
91.    What is a view?
92.    How many types of Views are there?
93.    What is locking?
94.    What is database utility?
95.    What are the basic functions of Database utility?
96.    What is Repository Info. Systems?
97.    What’s ABAP dictionary and its role in SAP?
98.    What are the main object types of ABAP dictionary?
99.    What are the components of a table definition.
100.    What are the assignment options to the field?

No comments: