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 _________ and _________.
- Put and Get.
2. The three main elements of LDB are _____________.
- Structure, Selections, 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 and using LDB.
5. With LDB one can modify the pre-generated selection screen to their needs. (True / False).
- Yes.
6. Logical databases are programs that read data from _________________.
- Database tables (Dictionary structures).
7. The event GET <table name> LATE process all tables that are hierarchically superior to the < table name>. (True / False).
- False. It processes all tables that are hierarchically inferior to the <table name>.
8. The Database Program of LDB is a collection of __________________ which selects the data and passes it to the report. (SUBROUTINES / FUNCTIONS ).
- Subroutines.
9. The layout of the Database program is determined by both ________________ and _________________ .
- Structure and Selections.
10. The order in which data is made available to the report depends on ______________ of the LDB.
- Structure.
11. Apart from the structure and selections of the LDB the ____________ statements in the report determines the behavior of the database at runtime.
- GET.
12. Node at the highest level in the structure is knows as ______________.
- Root.
13. There can be more than one node at the highest level in the structure. ( True / False ).
- 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. (True / False).
- 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. (TRUE / False).
- False. One can use additionally related tables, along with the tables defined in the structure of LDB.
16. ________________ selections allow the user to define further selections for database access in addition to the selection criteria already defined in the LDB selections.
- Dynamic.
17. ________________ statement can be used along with the event GET in the report for checking the selections which are not table-specific values.
- Check.
18. In sense of Database Management System (DBMS) LOGICAL DATABASE is a database. (True / False).
- False.
19. It is not necessary to maintain the Parent-Child relationship between the tables in Logical Database Structure. ( True / False ).
- 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. ( True / False ).
- False. One can extract data from tables using Select statements in a report, though the report is having a LDB attribute.
21. What sort of tables one can use 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 ___________ report. --- SQL Report .
23. One cannot use SELECT statements in a report program linked to a Logical Database. ( True / False ).
- False.
24. Is it true that the Logical Database reads the data from the database tables using Select Statements. ( True / False ).
- 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 represeneted on the screen. ( True / False ).
- True.
26. One can use the event GET in a report without LDB attribute. ( True / False ).
- False.
27. The last character of the LDB name denotes ___________________.
- Application.
28. The structure of Logical Databases reflects the ________________ dependencies of hierarchical tables in the SAP System.
- Foreign key
29. It is mandatory that for each table in the LDB hierarchy there should exists one GET statement in the report. ( True / False ).
- False, it is not necessary.
30. What happens if a report does not contain a GET statement for a particular node of a Logica Database.
- Process will transfer to the next event.
31. In a Logical Database, one can define input fields on the selection screen with _____________ and ____________ statements.
- Select-options & Parameters.
32. Suppose a logical database program contains the following lines: SELECT-OPTIONS CONNID FOR SPFLI-CONNID.
PARAMETERS CARRID LIKE SFLIGHT-CARRID FOR TABLE SFLIGHT If the tables statement in a report declares only SPFLI but not SFLIGHT what will be the output, for the above two statements.
Only select-options connid for spfli-carrid will be displayed on the screen.
33. Consider a report with F1S attribute, what will be the output for the following code. Whether you will get the data from spfli and sflight or not, with corresponding tables statement. GET SBOOK.
Write: / spfli-carrid, spfli-connid, sflight-fldate, sbook-bookid.
Yes, you will get the data from spfli and sflight.
34. Consider a report with F1S attribute, what will be the output of the following code. Whether you will get the data from sbook or not, with corresponding tables statement. GET SPFLI.GET SFLIGHT.
Write: / spfli-carrid, spfli-connid, sflight-fldate, sbook-bookid.
- You cannot extract data from sbook.
35. Identify any errors in the following code and correct the same, and what will be the output, if there exists corresponding tables statement, for spfli, sflight, sbook. GET SPFLI. GET SBOOK. Write : / spfli-carrid, spfli-connid, sflight-fldate, sbook-bookid, sbook-class.
- No syntax errors. You will get data from all the three tables.
36. Does the following two statements do the same task ? If so which one takes takes less time and which one is recommended SELECT * from spfli. Check : spfli-carrid = ‘LH’Where spfli-carrid = ‘LH’ And spfli-connid = ‘400’. And spfli-connid = ‘400’. ENDSELECT.ENDSELECT.
- Yes they will do the same task. Second Select statement takes less time and it is recomended.
37. If you want to improve the response time ( time to access data ) Logical DataBases permits you to achieve this using __VIEWS____
38. Is there any upper limit (max) to the possible number of nodes in a logical database structure ? If so what is that limit ?
- Yes, there is an upper limit for defining number of nodes in a Logical DataBase Structure. Maximim nodes = 1200 / length.Where length = maximum lenght of name in the structure.
39. In the structure of Logical DataBase nodes at different levels are displayed in the same columns. ( True / False ). If false what type of nodes are displayed in the same columns. If True what type of nodes are not displayed in the same columns.
- False. Nodes at same level are displayed in the same columns.
40. What are the advantages of Logical DataBases ?
- It offers an easy-to-use selection screen. You can modify the pre-generated selection screen to your needs. It offers check functions to check whether user input is complete, correct, and plausible. It offers reasonable data selections. It contains central authorization checks for database accesses. Enhancements such as improved performance immediately apply to all report programs that use the logical database.
41. Though the all the ABAP/4 Dictionary Structures that exists in the structure of the LDB, being defined in Database Program, we are defining the Dictionary Structures in the Report. What is the reason for such a declaration?
- By declaring so we are providing work areas for data passing between Logical Database and Report. In addition, the logical database configures the selection screen depending on the selection of database tables.
42. Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exists in the structure of LDB, and are being defined in the Database part of LDB.
- No, it is not mandatory to declare all tables in report.
43. If one wants to access data using Logical DataBase, the use of events is unavoidable. ( True / False ). - True .
