gs gs113 Nulls and Conditions and Miscellaneous - Conditional Evaluation - 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 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 of the following operators is/are used in “Condition Evaluation”?
AND
OR
NOT
All of the mentioned
Question 2: Which of the following statements is/are correct?
True AND true =true
True AND false= false
False AND false= false
All of the mentioned
Question 3: Which of the following statements is/are correct?
True OR true =true
True OR false= true
False OR false= false
All of the mentioned
Question 4: Which of the following statements is/are correct?
NOT(true)=false
NOT(false)=true
Both NOT(true)=false and NOT(false)=true
None of the mentioned
Question 5: Which of the following statements is/are correct?
NOT(true AND true) =false
NOT(false AND false)=true
NOT (true AND false)= true
All of the mentioned
Question 6: Which of the following statements is/are correct?
NOT(true OR true) = false
NOT(false OR false)= true
NOT (true OR false)= false
All of the mentioned
Question 7: What will be the result of the following MySQL command?
WHERE TITLE= ‘teller’ AND start_date < ’2007-01-01’
Only tellers who began working for the bank prior to 2007 will be included
Any employee who is either not a teller or began working for the bank in 2007 or later will be removed from consideration
Only tellers who began working for the bank prior to 2007 will not be included
None of the mentioned
Question 8: What will be the result of the following MySQL command?
WHERE TITLE=’teller’ OR start_date=’2007-01-01’
The employee is a teller and was employed prior to 2007
The employee is a teller and was employed after January 1, 2007
The employee is something other than a teller but was employed prior to 2007
All of the mentioned
Question 9: What will be the result of the following MySQL command?
WHERE end_date IS NULL AND (title=’teller’ OR start_date < ‘2007-01-01’)
Only those rows will be selected whose” end_date” should be NULL
Only those rows are selected whose “TITLE” should be ‘teller’
Only those employee will be selected who joined the organisation prior to 2007
All of the mentioned
Question 10: What will be the result of the following MySQL command?
WHERE end_date IS NULL AND NOT (title=’teller’ OR start_date < ‘2007-01-01’)
The result set contains non terminated employees who both are non tellers and started working for the bank from 2007 or later
The result set contains employees who both are tellers and started working for the bank in 2007 or later
The result set contains employees who are only tellers
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
