gs gs113 Nulls and Conditions and Miscellaneous - Condition Types - Quiz No.2
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: Which among the following data types can be used with “Range Condition”?
Numeric data type
Temporal data type
String data type
Both Numeric and Temporal data type
Question 2: The following MySQL statement belongs to which “Condition Types”?
SELECT emp_id, fname, lname FROM account WHERE start_date<’2007-10-08’;
Equality conditions
Inequality condition
Range condition
None of the mentioned
Question 3: What will be the output of the following MySQL statement?
SELECT * FROM employee WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;
All employees details between 2007 and 2008
All employees details before 2008
All employees details from 2007 to 2008
None of the mentioned
Question 4: Fill the blanks with suitable options?
BETWEEN ______ AND ______
BETWEEN ______ AND ______
Upper and lower limit
Lower and upper limit
Upper and upper limit
None of the mentioned
Question 5: What will be the output of the following MySQL statement?
SELECT * FROM employee WHERE start_date>=’2007-01-01’ AND Start_date<=’2005-01-01’
All employees between 2007 and 2005
All employees from 2007 to 2005
Empty set
None of the mentioned
Question 6: What will be the output of the following MySQL statement?
SELECT customer_id, product_id, avail_balance FROM account WHERE avail_balance BETWEEN 3000 AND 5000.
Only those details will be shown whose as available balance form 3000 to 5000
Only those details will be shown whose available balance is more than 3000
Only those details will be shown whose available balance is less than 5000
None of the mentioned
Question 7: Which among the following operators is/are belongs to “Inequality conditions”?
<>
!=
=
Both <> and !=
Question 10: Find the error in the following MySQL statement?
SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
Yes
No
Range too high to compare
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
