gs gs113 Select Statement - The Select 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: What is the meaning of “SELECT” clause in Mysql?
Show me all Columns and rows
Show me all columns
Show me all rows
None of the mentioned
Question 2: Which of the following clause is evaluated in the last by database server?
SELECT
WHERE
FROM
None of the mentioned
Question 3: What will be the output of the following SQL statement?
SELECT * FROM person;
Show all rows and columns of table “person”
Show all rows of table “person”
Show all columns of table “person”
None of the mentioned
Question 4: What will be the output of of the following SQL statement?
SELECT person_id, Fname, lname FROM person;
Show only columns (person_id, Fname, lname) and rows related to these columns
Show only columns (person_id, Fname, lname)
Show all rows
Show all columns except (person_id, Fname, lname)
Question 5: Can “SELECT” clause be used without the clause “FROM”?
YES
NO
DEPENDS
None of the mentioned
Question 6: Find the error in the following SQL statement?
SELECT *;
No Error
No table mentioned
Depends
None of the mentioned
Question 7: What will be the output of the following SQL statement?
SELECT * FROM person WHERE person_id=1;
Show all columns but only those rows which belongs to person_id=1
Show all columns and rows
Shows only columns person_id
None of the mentioned
Question 8: What will be the output of the following SQL statement?
SELECT person_id, fname, lname FROM person WHERE person_id=1;
Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1
Show all columns and rows
Shows only columns person_id
None of the mentioned
Question 9: Which clause is mandatory with clause “SELECT” in Mysql?
FROM
WHERE
Both FROM and WHERE
None of the mentioned
Question 10: Which among the following can also be included with “SELECT” clause while writing query in Mysql?
Literals
Expressions
User defined functions
All 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
