Discussion
Home ‣ Interview ‣ Technology Comments
- Question
Embedded SQL is which of the following?
Options- A. The process of making an application capable of generating specific SQL code on the fly.
- B. Hard-coded SQL statements in a trigger.
- C. Hard-coded SQL statements in a program language such as Java.
- D. Hard-coded SQL statements in a procedure.
- Correct Answer
- Hard-coded SQL statements in a program language such as Java.
- 1. The SQL SELECT statement is capable of
Options- A. Projection
- B. Selection
- C. Protection & Security
- D. Both A & B Discuss
- 2. A subquery in an SQL SELECT statement is enclosed in
Options- A. [ ]
- B. { }
- C. < >
- D. ( ) Discuss
- 3. Which of the following is not a relational database?
Options- A. 4th Dimension
- B. Reflex
- C. dBASE IV
- D. FoxPro Discuss
- 4. Oracle SQL developer is an Discuss
- 5. AND, OR and NOT are examples of
Options- A. Clauses
- B. Boolean operators
- C. Conjuctive operators
- D. Exclusive operators Discuss
- 6. Which SQL keyword is used to sort the result-set?
Options- A. ORDER
- B. ORDER BY
- C. SORT BY
- D. SORT Discuss
- 7. How can u write programmatically value help to a field without using search help and match code? Discuss
- 8. 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? Discuss
- 9. What are session method and call transaction method and explain about them? Discuss
- 10. If you have 10000 records in your file, which method you use in BDC? Discuss
Technology problems
Search Results
Correct Answer: Both A & B
Correct Answer: ( )
Explanation:
A subquery in an SQL SELECT statement is enclosed in parenthesis (...).
Correct Answer: Reflex
Correct Answer: Oracle SQL developer is an Oracle Database IDE
Correct Answer: Boolean operators
Correct Answer: ORDER BY
Explanation:
SQL keyword ORDER BY is used to sort the result-set.
Correct Answer: By using two types of function modules to be called in SAP Script: 1)HELP_OBJECT_SHOW_FOR_FIELD 2)HELP_OBJECT_SHOW
Correct Answer: strat_form using this we can open many layoutses open_form using this we can open the layout performance will be high
Correct 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
Correct 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
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.