Discussion
Home ‣ Interview ‣ Technology Comments
- Question
Which SQL keyword is used to sort the result-set?
Options- A. ORDER
- B. ORDER BY
- C. SORT BY
- D. SORT
- Correct Answer
- ORDER BY
ExplanationSQL keyword ORDER BY is used to sort the result-set.
- 1. 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. Discuss
- 2. The SQL SELECT statement is capable of
Options- A. Projection
- B. Selection
- C. Protection & Security
- D. Both A & B Discuss
- 3. A subquery in an SQL SELECT statement is enclosed in
Options- A. [ ]
- B. { }
- C. < >
- D. ( ) Discuss
- 4. Which of the following is not a relational database?
Options- A. 4th Dimension
- B. Reflex
- C. dBASE IV
- D. FoxPro Discuss
- 5. Oracle SQL developer is an Discuss
- 6. How can u write programmatically value help to a field without using search help and match code? Discuss
- 7. 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
- 8. What are session method and call transaction method and explain about them? Discuss
- 9. If you have 10000 records in your file, which method you use in BDC? Discuss
- 10. 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 Discuss
Technology problems
Search Results
Correct Answer: Hard-coded SQL statements in a program language such as Java.
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: 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
Correct 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 (_)
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.