Question 1

A DBMS query language is designed to

Accepted Answer

All of the above

Question 2

Which of the following is a comparison operator in SQL?

Accepted Answer

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Question 3

AND, OR and NOT are examples of

Accepted Answer

Boolean operators

Question 4

Oracle SQL developer is an

Accepted Answer

Oracle SQL developer is an Oracle Database IDE

Question 5

Which of the following is not a relational database?

Accepted Answer

Reflex

Question 6

A subquery in an SQL SELECT statement is enclosed in

Accepted Answer

A subquery in an SQL SELECT statement is enclosed in parenthesis (...).

Question 7

The SQL SELECT statement is capable of

Accepted Answer

Both A & B

Question 8

Embedded SQL is which of the following?

Accepted Answer

Hard-coded SQL statements in a program language such as Java.

Question 9

Which SQL keyword is used to sort the result-set?

Accepted Answer

SQL keyword ORDER BY is used to sort the result-set.

Question 10

How can u write programmatically value help to a field without using search help and match code?

Accepted Answer

By using two types of function modules to be called in SAP Script: 1)HELP_OBJECT_SHOW_FOR_FIELD 2)HELP_OBJECT_SHOW

Question 11

What is the difference between start_form and open_form in scripts? Why is it necessary to close a form always once it is opened?

Accepted Answer

strat_form using this we can open many layoutses open_form using this we can open the layout performance will be high

Question 12

What are session method and call transaction method and explain about them?

Accepted Answer

Call Transaction Method: In Call Transaction method we call the transaction in BDC program itself If we want this program is executed by some one else then we need to expose the code to him Call Transaction Method Works in Foreground No Display Mode is equal to Background Processing in call transaction method Call Transaction Method can handle only one Application at a time In Call Transaction Method no Log File by Default We have to design Log File by using BDCMSGCOLL Call Transaction Method Updates the Database Asynchronously (Note: Asynchronous updation is Faster than Synchronous) Batch Session Method: On the other hand in batch session method we create a session which can be executed at any time by any authorized person without exposing the code of the program Session Method works in Background and as well as in Foreground Session Method can handle Multiple Applications at a time Session Method holds Log File by Default Session Method Updates the Database Synchronously

Question 13

If you have 10000 records in your file, which method you use in BDC?

Accepted Answer

Call transaction is faster than session method But usually we use session method in real time…because we can transfer large amount of data from internal table to database and if any errors in a session, then process will not complete until session get correct

Question 14

Which of the following are acceptable names of an ABAP program? A. ZQSDABAP B. YMYFIRSTABAPPROGRAM C. Z”MyFirst ABAP PROGRAM D. Z==FIRSTABAPPROGRAM E. THISISMYFIRSTABAPPROGRAMME

Accepted Answer

Answer: A, B, E The name of an ABAP program can be between 1 and 30 characters long The following symbols and signs must not be used in program names: Period (), comma (,), space ( ), parentheses (), apostrophe (‘), inverted commas ("), equals sign (=), asterisk (*), accented characters or German umlauts (à, é, ø, ä, ß, and so on), percentage signs (%), or underscores (_)

Question 15

What is an ABAP?

Accepted Answer

ABAP (Advanced Business Application Programming) is a high level programming language created by the German software company SAP It is currently positioned as the language for programming SAP's Web Application Server, part of its NetWeaver platform for building business applications Its syntax is somewhat similar to COBOL

Question 16

What is an ABAP/4 Query?

Accepted Answer

ABAP/4 Query is a powerful tool to generate simple reports without any coding ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the simple reports Statistics: Reports with statistical functions like Average, Percentages Ranked Lists: For analytical reports - For creating a ABAP/4 Query, programmer has to create user group and a functional group Functional group can be created using with or without logical database table Finally, assign user group to functional group Finally, create a query on the functional group generated

Question 17

What is the differences between structure and table in data dictionary in ABAP?

Accepted Answer

Structure and table both are 2/2 matrices but there are many differences between table and structure 1 Table can store the data physically but a structure dose not store 2 Table can have primary key but a structure dose not have 3 Table can have the technical attribute but a structure dose not have structure doesn't contain technical attributes structure doesn't contain primary key structure doesn't stores underline database level

Question 18

What is the difference between SAP memory and ABAP memory?

Accepted Answer

sap memory is a global memory whereas abap memory is local memory For example, we have four programs in abap memory and assigned some varibles to a particular program in abap memory then those varibles can't be used by anyother program in abap memory ie, the variables are only for that program and also local to that memory,whereas sap memory can access all the abap memory or else it can perform any kind of modifications

Question 19

Explain about roll area , Dispatcher, ABAP-Processor.

Accepted Answer

Dispatcher recieves the request from client and assigns the request to one of the work process Roll area: Each workprocess works in a particular memory that memory is known as Role Area, which consists of User context and session data ABAP- Processor :is an interpretor which can execute logic

Question 20

What are the advantages and disadvantages of using views in ABAP programming ?

Accepted Answer

advantages: view is used to retrieve the data very fastly from the database tables * memory wastage is reduced * faster than joins to retrieve the data from database tables disadvantages: * view is not a container,it will not hold the data * view memory is not permanent memory

Technology Questions