SQL, C Programming, and OOP Concepts

Company: StateStreet_18oct

Difficulty: medium

Problem Statement

Question 1

Given the tables Active_Players and Retired_Players, which of the following SQL queries will be successfully executed? I) INSERT INTO SELECT... II) INSERT INTO (cols) (SELECT...) III) INSERT INTO (cols) VALUES (SELECT...)

Question 2

What will be the output of the program? #include 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 > 2); i += i && j ^ 3; printf("%d", i && 3, i++); return 0; }

Question 3

Which of the given-below statement(s) is/are true? I) Static polymorphism is method overloading. II) Dynamic polymorphism is method overriding. III) Overloading is faster than overriding due to compile-time binding. IV) Overriding return types can vary (covariant).