MySQL Questions and Answers – The from Clauses – 1

This set of MySQL Multiple Choice Questions & Answers (MCQs) focuses on “The from Clauses – 1”.

1. How can we define the clause “FROM” in Mysql?
a) It defines the tables used by a query
b) It defines the linking of tables in Mysql
c) It defines the tables used by a query & linking of tables in Mysql
d) None of the mentioned
View Answer

Answer: c
Explanation: None.

2. Which of the following table exist in Mysql?
a) Permanent Tables
b) Virtual tables
c) Temporary tables
d) All of the mentioned
View Answer

Answer: d
Explanation: Depends on the query.

3. “CREATE TABLE …” command is used to create which type of table in Mysql?
a) Permanent Tables
b) Virtual tables
c) Temporary tables
d) All of the mentioned
View Answer

Answer: a
Explanation: CREATE table is used to create permanent tables in database.
advertisement
advertisement

4. “CREATE VIEW …” command is used to create which type of table in Mysql?
a) Permanent Tables
b) Virtual tables
c) Temporary tables
d) All of the mentioned
View Answer

Answer: b
Explanation: CREATE VIEW is used to create virtual tables.

5. What is the meaning of “Temporary Tables” in Mysql?
a) Rows returned by sub query
b) Permanent tables
c) Virtual tables
d) All of the mentioned
View Answer

Answer: a
Explanation: “Temporary Tables” are output format of any query on Mysql.

6. “SELECT” clause cannot be used without which clause in Mysql?
a) FROM
b) WHERE
c) ORDER BY
d) All of the mentioned
View Answer

Answer: a
Explanation: “FROM” clause is necessary to point out tables in the database.

7. Which of the following statements is/are correct with respect to “VIEW”?
a) “VIEW” is a query that stored in the data dictionary
b) There is no data associated with “VIEW”
c) “VIEW” creates virtual tables in Database
d) All of the mentioned
View Answer

Answer: d
Explanation: None.
advertisement

8. Find the missing clause from the following SQL statement?

CREATE VIEW person_1 AS
SELECT fname, lname, person_id
_________person;

a) FROM
b) WHERE
c) SELECT
d) None of the mentioned
View Answer

Answer: a
Explanation: “CREATE VIEW” cannot be used without “FROM” clause.
advertisement

9. In the following MySQL query, “person_1” belongs to which category of table in MySQL?

CREATE VIEW person_1 AS
SELECT fname, lname, person_id FROM person;

a) Permanent Tables
b) Virtual tables
c) Temporary tables
d) None of the mentioned
View Answer

Answer: b
Explanation: “CREATE VIEW” creates “Virtual tables” only.

10. Which command is used to create “Temporary tables” in MySQL?
a) CREATE TABLE;
b) CREATE VIEW
c) Both CREATE TABLE; and CREATE VIEW
d) None of the mentioned
View Answer

Answer: d
Explanation: “Temporary Tables” are output format of any query.

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.