gs gs113 Nulls and Conditions and Miscellaneous - Condition Types - Quiz No.3
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 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 account_id, product_id, cust_id FROM account WHERE product_id IN (‘sav’, ‘chd’, ‘mm’);
Only those values are selected whose product_id is either ‘sav’, ‘chd’, ‘mm’
Only those values are selected whose product_id is either ‘sav’’
Only those values are selected whose product_id is either ‘sav’, ‘chd’
All of the mentioned
Question 2: What will be the output of the following MySQL statement?
SELECT account_id, product_id, cust_id FROM account WHERE product_id NOT IN (‘sav’, ‘chd’, ‘mm’);
Only those values are selected whose product_id does not belong to either ‘sav’, ‘chd’, ‘mm’
Only those values are selected whose product_id does not belong to either ‘sav’’
Only those values are selected whose product_id does not belong to either ‘sav’, ‘chd’
All of the mentioned
Question 3: Consider a database name “NVAEducation” whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id FROM nvaeducation Where subject IN (c, c++);
{5, 6}
{1, 2, 3}
{3, 4}
None of the mentioned
Question 4: Consider a database name “NVAEducation” whose attributes are intern_id (primary key), subject.
Intern_id= {1, 2, 3, 4, 5, 6}
Subject= {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
Intern_id= {1, 2, 3, 4, 5, 6}
Subject= {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id FROM nvaeducation Where subject NOT IN (c, c++);
{5, 6}
{1, 2, 3}
{3, 4}
None of the mentioned
Question 10: What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’T’;
Only those employees are selected whose last name started with ‘T’
Only those employees are selected whose last name started with other than ‘T’
All of the mentioned
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
