Monday, December 9, 2013

SAP ABAP Interview Questions and Answers - 7

LOGICAL DATABASE
1. Preparation of the data records by the L.D.B and reading of the data
records in the actual report are accomplished with the command pair Put
and Get.
2. The three main elements of LDB are Structure, Selections, and
Database Program.
3. In LDB what determines hierarchy of the tables?
Structure.
4. In general what are the two ways in which one can retrieve data from
tables?
Using Select statements, Database Program.
5. With LDB one can modify the pre-generated selection screen to their
needs (T/F).
Yes.
6. Logical databases are programs that read data from Database tables
(Dictionary Structures).
7. The event Get LATE process all tables that are hierarchically superior to
the
. (True/False)
False. It processes all tables that are hierarchically inferior to the
.
8. The Database Program of LDB is a collection of SUBROUTINES, which selects data and
passes it to the report.
9. The layout of the Database program is determined by both Structure and Selections.
10. The order in which data is made available to the report depends on Structure of the
LDB.
11. Apart from the structure and selections of the LDB the GET statements in the report
determines the behavior of the database at runtime.
12. Node at the highest level in the structure is known as Root.
13. There can be more than one node at the highest level in the structure. (T/F)
False. One can define only one node at the highest level in the structure on LDB.
14. All nodes in the structure of LDB need not be defined in the ABAP/4 Dictionary (T/F).
False. One has to define all nodes in the Dictionary or one has to select all nodes that are
defined in the Dictionary.
15. It is not possible to use ABAP/4 Dictionary Structures without an underlying database
using LDB. (T/F)
True. One can use additionally related tables, along with the tables defined in the structure
of LDB.
16. Dynamic selections allow the user to define further selections for database access in
addition to the selection criteria already defined in the LDB selections.
17. Check statement can be used along with the event GET in the report for checking the
selections, which are not table-specific values.
18. In sense of Database Management System (DBMS) LOGICAL DATABASE is a
database Structure. (T/F).
False.
19. It is not necessary to maintain the Parent-Child relationship between the tables in
Logical Database Structure. (T/F)
False. One has to maintain the Parent-Child relationship.


20. Is it possible to extract data from tables without using the event 'GET' in the report
with an appropriate LDB. (T/F).
False. One can extract data from tables using Select statements in a report, though the
report is having a LDB attribute.
21. What sorts of tables one can se in designing the hierarchy of a LDB?
Tables, which are having Foreign Key relations.
22. A report program, which uses only SELECT statements, is called SQL Report.
23. One cannot use SELECT statements in a report program linked to a Logical Database
(T/F).
False.


24. Is it true that the Logical Database reads the data from the database tables using Select
Statements (T/F).
Yes. We are coding that in Database part of LDB.
25. In a report with an LDB attribute, you do not have to define how the information
should be retrieved from the database tables, but only how the data should be represented
on the screen. (T/F).
True.
26. One can use the event GET in a report without LDB attribute. (T/F).
False.





Finance  economy  finance & insurance money derivatives wall street young money  got money cash money  get money


27. The last character of the LDB name denotes Application.
28. The structure of Logical Databases reflects the Foreign Key dependencies of
hierarchical tables in the SAP system.
29. It is mandatory that for each table in the LDB hierarchy there should exist one GET
statement in the report. (T/F).
False. It is not necessary.
30. What happens if a report does not contain a GET statement for a particular node of a
Logical Database.
Process will transfer to the next event.

No comments:

Post a Comment