MySQL Practice Test 10

1. 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

All of the mentioned

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

2. 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 employee will be selected who joined the organisation prior to 2007

Only those rows will be selected whose” end_date” should be NULL

Only those rows are selected whose “TITLE” should be ‘teller’

All of the mentioned

3. Which among the following operators is/are belongs to “Equality conditions”?

>/<

4. If emp_id contain the following set {1, 2, 2, 3, 3, 1}, what will be the output on execution of the following MySQL statement?

SELECT emp_id
FROM person
ORDER BY emp_id;

{1, 2, 3, 3, 2, 1}

{2, 2, 1, 1, 3, 3}

None of the mentioned

{1, 1, 2, 2, 3, 3}

5. 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’

All of the mentioned

Only those values are selected whose product_id is either ‘sav’, ‘chd’, ‘mm’

Only those values are selected whose product_id is either ‘sav’’

6. 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);

{5, 6}

{1, 2, 3}

{3, 4}

{2, 4, 5, 6}

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

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

None of the mentioned

All columns but only those rows which contain ‘HEAD TELLER’ as a “title” OR start_date are greater than 2013-01-24

All columns and rows belong to table employee

All rows belong to table employee

8. Which among the following operators is/are belongs to “Inequality conditions”?

Both <> and !=

9. What will be the output of the following MySQL statement “false OR Null”?

False

True

None of the mentioned

Null

10. Which command is used to create “Temporary tables” in MySQL?

CREATE VIEW

Both CREATE TABLE; and CREATE VIEW

CREATE TABLE;

None of the mentioned