Discussion
Home ‣ Interview ‣ Technology Comments
- Question
AND, OR and NOT are examples of
Options- A. Clauses
- B. Boolean operators
- C. Conjuctive operators
- D. Exclusive operators
- Correct Answer
- Boolean operators
- 1. Which of the following is a comparison operator in SQL?
Options- A. =
- B. <>
- C. `
- D. / Discuss
- 2. 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
- 3. Which of the following statements is true concerning subqueries?
Options- A. Does not start with the word SELECT.
- B. Involves the use of an inner and outer query.
- C. Cannot return the same result as a query that is not a subquery.
- D. All of the above Discuss
- 4. Which one of the following sorts rows in SQL?
Options- A. ORDER BY
- B. GROUP BY
- C. SORT BY
- D. ALIGN BY Discuss
- 5. What operator tests column for the absence of data?
Options- A. NOT operator
- B. IS NULL operator
- C. EXISTS operator
- D. All of the above Discuss
- 6. Oracle SQL developer is an Discuss
- 7. Which of the following is not a relational database?
Options- A. 4th Dimension
- B. Reflex
- C. dBASE IV
- D. FoxPro Discuss
- 8. A subquery in an SQL SELECT statement is enclosed in
Options- A. [ ]
- B. { }
- C. < >
- D. ( ) Discuss
- 9. The SQL SELECT statement is capable of
Options- A. Projection
- B. Selection
- C. Protection & Security
- D. Both A & B Discuss
- 10. 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
Technology problems
Search Results
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: Involves the use of an inner and outer query.
Correct Answer: ORDER BY
Correct Answer: IS NULL operator
Explanation:
SELECT "column_name"
FROM "table_name"
WHERE "column_name" IS NULL.
Correct Answer: Oracle SQL developer is an Oracle Database IDE
Correct Answer: Reflex
Correct Answer: ( )
Explanation:
A subquery in an SQL SELECT statement is enclosed in parenthesis (...).
Correct Answer: Both A & B
Correct Answer: Hard-coded SQL statements in a program language such as Java.
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.