Шукаєте відповіді та рішення тестів для Retake | Database Management Systems | Aldiyar Salkenov? Перегляньте нашу велику колекцію перевірених відповідей для Retake | Database Management Systems | Aldiyar Salkenov в moodle.astanait.edu.kz.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
What kind of rows does the UNION operation eliminate during operation by default?
The cats must be ordered first by breed and second by name. They are about to enter an elevator one by one. When all the cats of the same breed have entered they leave.
Which SQL statement helps to know what the running total weight of the cats is?
| name | varchar |
| breed | varchar |
| weight | float |
| color | varchar |
| age | int |
Which one of the following queries will select the number of unique departments from the Department table below?
| DepartmentNumber | EmployeeNumber |
| 11 | 3244 |
| 11 | 4442 |
| 12 | 1253 |
| 11 | 5003 |
| 13 | 1123 |
Which one is the correct syntax for applying UNION operator?
What would be the output of the below query?
SELECT MAX(MIN(SLSVLM)) FROM sales
| SLSVLM | SLSDate |
| 1 | 20121010 |
| 12 | 20121110 |
| 5 | 20120111 |
| 2 | 20120111 |
| -1 | 20120112 |
| 0 | 20120106 |
Which of the following is correct about the GROUP BY ROLLUP clause?
Table B
| ID |
|---|
| 1 |
| 2 |
| 3 |
| ID |
|---|
| 4 |
| 5 |
| 6 |
Which one do you think is the correct syntax of UNION ALL?