Which of the following is used to distinguish the variables in SQL from the host language variables?

Related MCQs

• Which of the following is TRUE? (1) Host variables are declared anywhere in the program (2) Host variables are declared in the DECLARE section
• Which SQL function is used to count the number of rows in a SQL query?
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• Which is a procedural extension of Oracle- SQL that offers language constructs similar tothose in imperative programming languages?
•                                is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.
• Which of the following is used as the embedded SQL in COBOL?
• Which of the following SQL command can be used to modify existing data in a database table?
• Which of the following SQL clauses is used to DELETE tuples from a database table?
• If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________