Discussion
Home ‣ Interview ‣ Technology Comments
- Question
A subquery in an SQL SELECT statement is enclosed in
Options- A. [ ]
- B. { }
- C. < >
- D. ( )
- Correct Answer
- ( )
ExplanationA subquery in an SQL SELECT statement is enclosed in parenthesis (...).
- 1. Which of the following is not a relational database?
Options- A. 4th Dimension
- B. Reflex
- C. dBASE IV
- D. FoxPro Discuss
- 2. Oracle SQL developer is an Discuss
- 3. AND, OR and NOT are examples of
Options- A. Clauses
- B. Boolean operators
- C. Conjuctive operators
- D. Exclusive operators Discuss
- 4. Which of the following is a comparison operator in SQL?
Options- A. =
- B. <>
- C. `
- D. / Discuss
- 5. A DBMS query language is designed to
Options- A. Specify the structure of a database
- B. Support in the development of complex applications software
- C. Support end users who use English-like commands
- D. All of the above Discuss
- 6. The SQL SELECT statement is capable of
Options- A. Projection
- B. Selection
- C. Protection & Security
- D. Both A & B Discuss
- 7. 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
- 8. Which SQL keyword is used to sort the result-set?
Options- A. ORDER
- B. ORDER BY
- C. SORT BY
- D. SORT Discuss
- 9. How can u write programmatically value help to a field without using search help and match code? Discuss
- 10. 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
Technology problems
Search Results
Correct Answer: Reflex
Correct Answer: Oracle SQL developer is an Oracle Database IDE
Correct Answer: Boolean operators
Correct Answer: =
Explanation:
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.
Correct Answer: All of the above
Correct Answer: Both A & B
Correct Answer: Hard-coded SQL statements in a program language such as Java.
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
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.