gs gs113 Select Statement - The Where 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 9 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 the “WHERE” clause in Mysql?
Filtering out unwanted rows from result set
Filtering out unwanted columns from result set
Filtering out unwanted rows and columns from result set
None of the mentioned
Question 2: What will be the output of the following MySQL command?
SELECT * FROM employee WHERE title=’HEAD TELLER’;
All columns and rows belong to table employee
All columns but only those rows which contain ‘HEAD TELLER’ as a “title”
All columns don’t belong to table employee
None of the mentioned
Question 3: What will be the output of the following MySQL command?
SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);
All columns and rows belong to table employee
All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and 2013-01-24 as a “start_date”
All rows belong to table employee
None of the mentioned
Question 4: What will be the output of the following MySQL command?
SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (start_date=2013-01-24);
All columns and rows belong to table employee
All columns but only those rows which contain ‘HEAD TELLER’ as a “title” or 2013-01-24 as a “start_date”
All rows belong to table employee
None of the mentioned
Question 5: What will be the output of the following MySQL command?
SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);
All columns and rows belong to table employee
All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and start_date are greater than 2013-01-24
All rows belong to table employee
None of the mentioned
Question 6: What will be the output of the following MySQL command?
SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (start_date>2013-01-24);
All columns and rows belong to table employee
All columns but only those rows which contain ‘HEAD TELLER’ as a “title” OR start_date are greater than 2013-01-24
All rows belong to table employee
None of the mentioned
Question 7: What will be the output of the following MySQL command?
SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;
All columns
Only those columns which are mention with “SELECT” clause
Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title”
None of the mentioned
Question 8: What will be the output of the following MySQL command?
SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;
All columns
Only those columns which are mention with “SELECT” clause
Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title” and start_date as 2008-11-24
None of the mentioned
Question 9: What will be the output of the following MySQL command?
SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date>2008-11-23;
All columns
Only those columns which are mention with “SELECT” clause
Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title” and start_date>2008-11-23
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
