JFE301Xuất hiện trong 1 đề thi
As shown below, when the SQL statement is executed on the relational database table “Staff”, which of the following tables is created? \nsql\nSELECT StaffID, BranchID FROM Staff WHERE BranchID = 'B03'\nUNION\nSELECT StaffID, BranchID FROM Staff WHERE Salary > 5000; \nStaff table: | StaffID | Salary | BranchID | |---|---:|---| | S01 | 2000 | B01 | | S02 | 4000 | B01 | | S03 | 3000 | B03 | | S04 | 8000 | B03 | | S05 | 3000 | B03 | | S06 | 4000 | B07 | | S07 | 6000 | B08 | \nThe answer choices refer to the following tables: **(a)** | StaffID | BranchID | |---|---| | S04 | B03 | **(b)** | StaffID | BranchID | |---|---| | S03 | B03 | | S04 | B03 | | S05 | B03 | | S07 | B08 | **(c)** | StaffID | BranchID | |---|---| | S03 | B03 | | S04 | B03 | | S05 | B03 | | S04 | B03 | | S07 | B08 | **(d)** | StaffID | BranchID | |---|---| | S03 | B03 | | S04 | B03 | | S05 | B03 | | S03 | B08 | | S04 | B08 | | S05 | B08 | | S07 | B03 | | S07 | B08 |
Các lựa chọn
A(b)
| StaffID | BranchID |
|---|---|
| S03 | B03 |
| S04 | B03 |
| S05 | B03 |
| S07 | B08 |
B(c)
| StaffID | BranchID |
|---|---|
| S03 | B03 |
| S04 | B03 |
| S05 | B03 |
| S04 | B03 |
| S07 | B08 |
C(d)
| StaffID | BranchID |
|---|---|
| S03 | B03 |
| S04 | B03 |
| S05 | B03 |
| S03 | B08 |
| S04 | B08 |
| S05 | B08 |
| S07 | B03 |
| S07 | B08 |
D(a)
| StaffID | BranchID |
|---|---|
| S04 | B03 |