Mysql miscellaneous Easy Questions and Answers

Which command is used to create “Temporary tables” in Mysql?

“Temporary Tables” are output format of any query.

What is the use of “VIEW” in Mysql?

All of above

Is there any error in this query?

SELECT emp.emp_id, 
 emp.fname, emp.lname, dep.name
FROM employee emp INNER JOIN department dep
ON emp.dept_id = emp.dept_id;

There will be no error in the query, as table name “employee” is replaced by ‘e’ and table name “department” is replaced by‘d’.

In the following query, “Employee_1” belongs to which category of table in Mysql?

CREATE VIEW Employee_1 AS
SELECT firstname, lastname, Employee_id FROM Employee;

“CREATE VIEW” creates “Virtual tables” only.

What is the use of “VIEW” in Mysql?

All of above

Mysql miscellaneous