MySQL Practice Test 10

1. Consider a database name “Sanfoundry” 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?

SELECT intern_id
FROM sanfoundry
Where subject IN (c, c++, oop);

2. What will be the output of the following MySQL statement?

SELECT *
FROM employee
WHERE lname LIKE ‘F%’ AND lname LIKE ‘%T’;

3. The following MySQL statement belongs to which “Condition Types”?

SELECT emp_id, fname, lname
FROM account
WHERE start_date<’2007-10-08’;

4. What is the meaning of “Range Conditions”?

5. Consider a database name “Sanfoundry” 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?

SELECT intern_id
FROM sanfoundry
Where subject NOT IN (c, c++, oop);

6. What is the significance of “ORDER BY emp_id DESC” in the following MySQL command?

SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id DESC;

7. Is there any error in the following MySQL statement?

SELECT e.emp_id, e.fname,e.lname,d.name
FROM employee AS e INNER JOIN department AS d
ON e.dept_id=e.dept_id;

8. Which among the following data types can be used with “Range Condition”?

9. What will be the output of the following MySQL command?

SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) OR (start_date=2013-01-24);

10. What will be the output of the following MySQL command?

SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);