gs gs113 Select Statement - The From Clauses - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Select Statement. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: How can we define the clause “FROM” in Mysql?
It defines the tables used by a query
It defines the linking of tables in Mysql
It defines the tables used by a query & linking of tables in Mysql
None of the mentioned
Question 2: Which of the following table exist in Mysql?
Permanent Tables
Virtual tables
Temporary tables
All of the mentioned
Question 3: “CREATE TABLE …” command is used to create which type of table in Mysql?
Permanent Tables
Virtual tables
Temporary tables
All of the mentioned
Question 4: “CREATE VIEW …” command is used to create which type of table in Mysql?
Permanent Tables
Virtual tables
Temporary tables
All of the mentioned
Question 5: What is the meaning of “Temporary Tables” in Mysql?
Rows returned by sub query
Permanent tables
Virtual tables
All of the mentioned
Question 6: “SELECT” clause cannot be used without which clause in Mysql?
FROM
WHERE
ORDER BY
All of the mentioned
Question 7: Which of the following statements is/are correct with respect to “VIEW”?
“VIEW” is a query that stored in the data dictionary
There is no data associated with “VIEW”
“VIEW” creates virtual tables in Database
All of the mentioned
Question 8: Find the missing clause from the following SQL statement?
CREATE VIEW person_1 AS SELECT fname, lname, person_id _________person;
FROM
WHERE
SELECT
None of the mentioned
Question 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;
Permanent Tables
Virtual tables
Temporary tables
None of the mentioned
Question 10: Which command is used to create “Temporary tables” in MySQL?
CREATE TABLE;
CREATE VIEW
Both CREATE TABLE; and CREATE VIEW
None of the mentioned
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
