gs gs113 Nulls and Conditions and Miscellaneous - Condition Types - Quiz No.4
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 8 multiple choice questions (MCQs) to prepare and belongs to topic Nulls and Conditions and Miscellaneous. 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 will be the output of the following MySQL statement?
SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’F’;
Only those employees are selected whose last name started with ‘F’
Only those employees are selected whose last name started with other than ‘F’
All of the mentioned
None of the mentioned
Question 2: What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’;
Only those employees are selected whose first name started with ‘F’
Only those employees are selected whose first name started with other than ‘F’
All of the mentioned
None of the mentioned
Question 3: What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;
Only those employees are selected whose first name and last name started with ‘F’
Only those employees are selected whose first name started with ‘F’ but last name can be starts with any other letter
Only those employees are selected whose first name and last name started with any other letter except ‘F’
None of the mentioned
Question 4: What will be the output of the following MySQL statement?
SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;
All employees whose last name start with any letter but second letter should be ‘a’
All employees whose last name start with any letter but contain at least one ‘e’ in his name
All employees whose last name should have letter ‘a’ in second position and at least one ‘e’ in his name
All of the mentioned
Question 5: What will be the output of the following MySQL statement?
SELECT * FROM employee WHERE lname LIKE ‘F%’ OR lname LIKE ‘%T’;
All employees whose last name should started with ‘F’
All employees whose last name end with ‘T’
All employees whose last name should started with ‘F’ and end with ‘T’
None of the mentioned
Question 6: What will be the output of the following MySQL statement?
SELECT * FROM employee WHERE lname LIKE ‘F%’ AND lname LIKE ‘%T’;
All employees whose last name should started with ‘F’ and end with ‘T’
All employees whose last name start with ‘T’ and end with ‘F’
All employees whose last name should started with ‘F’ and end with ‘F’
None of the mentioned
Question 7: What will be the output of the following MySQL statement?
SELECT * FROM employee WHERE lname LIKE %bas% OR fname LIKE %bbs%;
All employees whose last name should contain substring “bas”
All employees whose first name should contain substring “bbs”
All employees whose last name should contain substring “bas” or first name should contain substring “bbs”
None of the mentioned
Question 8: What will be the output of the following MySQL statement?
SELECT * FROM employee WHERE lname LIKE %t%f%n%;
All employees whose last name contain ‘t’ in the second position
All employees whose last name contains ‘f’ in the fourth position
All employees whose last name contains ‘n’ in second last position
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
