Computer Science, asked by vigneshvick678, 2 months ago

You have 15 records in EMP Table and 5 records in DEPT table.

What will be the output of the following SQL statement?

SELECT Count()
FROM EMP DEPT

option
a.15
b. 5
c. 75
d. 0

Answers

Answered by poojan

Explanation:

Given SQL Statement is

SELECT COUNT(*) FROM EMP, DEPT;

Where, the EMP table contains 15 records and the DEPT Table contains 5 records.

When you use the syntax SELECT COUNT(*) FROM TABLE1, TABLE2; it does the cross product of two tables, as in TABLE1 X TABLE 2.

So, here the given SQL statement does the cross product of EMP and DEPT tables as EMP X DEPT.

The cross product is nothing but each record in table 1 is joined with each record in table 2.

So, the total number of records formed by EMP X DEPT is 15 x 5 = 75.

Learn more:

1. What are the maximum and the minimum number of rows returned by the R1 right outer join R2?

brainly.in/question/21195376

2. Noisy values are the values that are valid for the dataset but are incorrectly recorded. Is it?

brainly.in/question/6658996

Answered by babapakisstani

Answer:

what will be the output of the following statements IF A=15 , B=5

Explanation:

Previous Question

Next Question