Technology problems
- 1. 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 Also asked in: Analyst, Database Administrator, IT Trainer
Correct Answer: All of the above
- 2. Which of the following is a comparison operator in SQL?
Options- A. =
- B. <>
- C. `
- D. / Also asked in: AIEEE, Bank Exams, Analyst, Bank Clerk, Bank PO, Database Administrator, IT Trainer
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.
- 3. AND, OR and NOT are examples of
Options- A. Clauses
- B. Boolean operators
- C. Conjuctive operators
- D. Exclusive operators Also asked in: Bank Exams, Analyst, Bank Clerk, Database Administrator, IT Trainer, Project Manager
Correct Answer: Boolean operators
- 4. Oracle SQL developer is an Also asked in: Analyst, Database Administrator, IT Trainer
Correct Answer: Oracle SQL developer is an Oracle Database IDE
- 5. Which of the following is not a relational database?
Options- A. 4th Dimension
- B. Reflex
- C. dBASE IV
- D. FoxPro Also asked in: Database Administrator, IT Trainer
Correct Answer: Reflex
- 6. A subquery in an SQL SELECT statement is enclosed in
Options- A. [ ]
- B. { }
- C. < >
- D. ( ) Also asked in: Database Administrator, IT Trainer, Software Architect
Correct Answer: ( )
Explanation:
A subquery in an SQL SELECT statement is enclosed in parenthesis (...).
- 7. The SQL SELECT statement is capable of
Options- A. Projection
- B. Selection
- C. Protection & Security
- D. Both A & B Also asked in: AIEEE, Bank Exams, CAT, Analyst, Bank Clerk, Bank PO
Correct Answer: Both A & B
- 8. 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. Also asked in: AIEEE, Bank Exams, CAT, Analyst, Bank Clerk, Bank PO
Correct Answer: Hard-coded SQL statements in a program language such as Java.
- 9. Which SQL keyword is used to sort the result-set?
Options- A. ORDER
- B. ORDER BY
- C. SORT BY
- D. SORT Also asked in: Analyst, Database Administrator, IT Trainer
Correct Answer: ORDER BY
Explanation:
SQL keyword ORDER BY is used to sort the result-set.
- 10. How can u write programmatically value help to a field without using search help and match code? Discuss
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
More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.