Question: 1This constraint uniquely identify each row in a table. 2. Which of the following will be the output after executing this statement: SELECT LENGTH(ITDB202) FROM
1This constraint uniquely identify each row in a table.
2. Which of the following will be the output after executing this statement:
SELECT LENGTH(ITDB202) FROM dual;
3. Which of the following will be the output after executing this statement:
SELECT CONCAT(Query, Language) FROM dual;
4.
Examine the EMPLOYEES table and the given SQL statement:
| EID | Name | Dept | Salary |
| 1001 | Rashad | IT | 700 |
| 1002 | Salma | Admin | 500 |
| 1003 | Ahmed | IT |
|
SELECT Name, Dept, Salary
FROM employees
WHERE name LIKE %d AND salary IS NULL;
Which of the following will be the output after executing the statement?
5.Which operator can be used with a multiple row subquery?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
