Company: StateStreet_18oct
Difficulty: medium
Given the tables Active_Players (shirt_no INTEGER, player_name VARCHAR, match_played INTEGER) and Retired_Players with the same schema, which of the following SQL queries will be successfully executed? I) INSERT INTO Active_Players SELECT shirt_no, player_name, match_played FROM Retired_Players WHERE shirt_no = 37 II) INSERT INTO Active_Players (player_name, match_played) (SELECT player_name, match_played FROM Retired_Players WHERE shirt_no = 47) III) INSERT INTO Active_Players (player_name, match_played) VALUES (SELECT player_name, match_played FROM Retired_Players WHERE shirt_no = 57) Only I and II Only I and III Only II and III All I, II, and III What will be the output of the following C program? #include <stdio.h> int main() { int i = 3, j = 4, k = 5; k += ++i + (j = i = 2) ^ 2; printf("%d ", k * 1 && !0); j = (i = 3) || k; j -= i + ++j + 2 << 1; printf("%d ", j >> 2); i += i && j ^ 3; printf("%d", i && 3, i++); return 0; } 1 -3 1 1 -4 1 0