There are 10 rows in Table A and 0 Rows in table B. If you fire the following query:

Keep practicing — related questions

• There are 10 rows in Table A and 0 Rows in table B. Select * from A,B How many rows will be retrieved.
• What is the output of the below queries: if table A is having 16 rows: select count(*) from A where 10=10; ...
• What is the output of the below query: if table A is having 16 rows: select count(*) from A having 1=10;
• The table employee contains 20 records. What is the output of the query " Select 8 from Employee"?
• A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in t...
• A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in t...
• A new table has been created in the employee. There are no rows in the table.What would be the output of th...
• A new table has been created in the employee. There are no rows in the table.What would be the output of th...