Inspect the query: MysqlSELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004'; 4 rows in set (0.00 sec) MysqlEXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE dept_no='d004'; 2 rows in set (0.00 sec) Which two statements are true about the EXPLAIN output?

Question

Inspect the query:

Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004'; 4 rows in set (0.00 sec) Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE dept_no='d004'; 2 rows in set (0.00 sec) Which two statements are true about the EXPLAIN output?

Accepted Answer

C. The minimal number of rows possible are read.

Answer

A. All data for the result is read from the indexex.

Answer

B. The PRIMARY KEY is used for filtering in both tables.

Answer

D. The dept_manager table has 4 times as many rows than the employees table.

Inspect the query: Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004'; 4 rows in set (0.00 sec) Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN…

Question

Exhibit

Options

How the community answered

Community Discussion