Question 1

1SELECT ta.Player FROM Scores AS ta
2WHERE ta.Runs > ALL ( SELECT tb.Runs
3                      FROM Scores AS tb
4                      WHERE tb.Country = 'Brazil' AND tb.Runs > 90 )
5   AND ta.Runs > ANY (SELECT tc.Runs
6                      FROM Scores AS tc
7                      WHERE tc.Country = 'India')

Consider the table Scores given below. | Player | Country | Runs | |---|---|---| | Kohli | India | 86 | | Dhoni | India | 43 | | Pele | Brazil | 89 | | Gautam | India | 100 | | Lato | Poland | 78 | | Rahn | Germany | 55 | | Muller | Germany | 98 | | Rohit | India | 30 | | Klose | Germany | 95 | | Hardik | India | 67 | Figure 1: Scores The following query is executed on the Scores table. SELECT ta.Player FROM Scores AS ta WHERE ta.Runs > ALL ( SELECT tb.Runs FROM Scores AS tb WHERE tb.Country = 'Brazil' AND tb.Runs > 90 ) AND ta.Runs > ANY (SELECT tc.Runs FROM Scores AS tc WHERE tc.Country = 'India') How many tuples are returned by the above SQL query? Consider the log records at an instance of time and the statements given below. Table 2: Log records | $< T_0 \text{ start} >$ | |---| | $< T_0, A, 1000, 3000 >$ | | $< T_0, B, 500, 300 >$ | | $< T_1 \text{ start} >$ | | $< T_1, C, 790, 700 >$ | | $< T_0, B, 300, 200 >$ | | $< Commit\ T_1 >$ | | $< T_2 \text{ start} >$ | | $< Checkpoint\ L >$ | | $< T_2, D, 5000, 4500 >$ | | System crash | Identify the number of correct statements: - Undo $T_0$ - Redo $T_1$ - The value of $A$ is updated to 3000 - The value of $B$ is restored to 500 - The value of $C$ is restored to 790 - The value of $D$ is restored to 5000 If a relation R is in Fourth Normal form then, which of the following holds?