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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started