Consider the above tables A, B and C. How many tuples does the result of the following SQL query contains?SELECT A.id FROM A WHERE A.age > ALL (SELECT B.age FROM B WHERE B. name = arun)

DATA WAREHOUSING AND DATA MINING

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Consider the above tables A, B and C. How many tuples does the result of the following SQL query contains?SELECT A.id FROM A WHERE A.age > ALL (SELECT B.age FROM B WHERE B. name = “arun")

A	4
B	3
C	0
D	1

Explanation:

Detailed explanation-1: -SQL COUNT() function counts the total number of rows present in the database.

Detailed explanation-2: -Null values are treated as the lowest possible values. 9. Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.

Detailed explanation-3: -The EXISTS operator is used to test for the existence of any record in a subquery. The EXISTS operator returns TRUE if the subquery returns one or more records.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING