What will be the result of the following query?WHERE end_date IS NULL AND NOT (title= teller OR start_date < 2009-05-05 )

The result set contains employees who both are tellers and started working for the bank in 2009 or later

The result set contains employees who are only tellers

The result set contains non terminated employees who both are non tellers and started working for the bank from 2009 or later

What will be the result of the following query?WHERE end_date IS NULL

1.	What will be the result of the following query?WHERE end_date IS NULL AND NOT (title= teller OR start_date < 2009-05-05 )
A.	The result set contains employees who both are tellers and started working for the bank in 2009 or later
B.	The result set contains employees who are only tellers
C.	The result set contains non terminated employees who both are non tellers and started working for the bank from 2009 or later
D.	All of above
E.	None of these
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

What will be the result of the following query?WHERE TITLE= teller OR start_date= 2008-02-02
What will be the result of the following query?WHERE TITLE= teller AND start_date < 2007-01-01
The following query belongs to which condition types?SELECT firstnameFROM EmployeeWHERE fed_id= 333-33-333 ;
The following query belongs to which condition types?SELECT firstnameFROM EmployeeWHERE title= Engineer ;
Does the following query belong to the Inequality condition ?SELECT product_type.name, product.nameFROM product_type INNER JOIN ProductON product_type.dept=Product.deptWHERE product_type.name<> customers_accounts ;
Is the following query belongs to the Equality condition ?SELECT product_type.name, product.nameFROM product_type INNER JOIN ProductON product_type.dept=Product.deptWHERE product_type.name= customers_accounts ;
What will be the output of the following query?SELECT *FROM StudentWHERE start_date BETWEEN 2009-05-05 AND 2010-05-05 ;
What will be the output of the following query?SELECT accountid, productid, custidFROM accountWHERE productid IN ( sav , chd , mm );
Find the error in the following query?SELECT custid, fedidFROM customerWHERE custid = I AND fedid BETWEEN 6000-00-000 AND 8888-888-000;
Consider a database name interviewmania whose attributes are intern_id (primary key), subject.Internid = {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 query?SELECT internidFROM interviewmaniaWHERE subject IN (c, c++, oop);

What will be the result of the following query?WHERE end_date IS NULL AND NOT (title= teller OR start_date &lt; 2009-05-05 )

Discussion

No Comment Found

Related MCQs

Reply to Comment

What will be the result of the following query?WHERE end_date IS NULL AND NOT (title= teller OR start_date < 2009-05-05 )