MySQL Mock Test 10 - Sanfoundry

10%

Question 1 of 10

1. In the following MySQL query, “person_1” belongs to which category of table in MySQL?

CREATE VIEW person_1 AS
SELECT fname, lname, person_id FROM person;

Virtual tables

None of the mentioned

Temporary tables

Permanent Tables

Question 1 of 10

Question 2 of 10

2. Is there any error in the following MySQL command?

SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY left (fed_id, 3);

Depends

None of the mentioned

Yes

No error

Question 2 of 10

Question 3 of 10

3. 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;

None of the mentioned

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

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

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

Question 3 of 10

Question 4 of 10

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

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

All rows belong to table employee

All columns and rows belong to table employee

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

None of the mentioned

Question 4 of 10

Question 5 of 10

5. What will be the result of the following MySQL command?

WHERE TITLE=’teller’ OR start_date=’2007-01-01’

The employee is something other than a teller but was employed prior to 2007

All of the mentioned

The employee is a teller and was employed after January 1, 2007

The employee is a teller and was employed prior to 2007

Question 5 of 10

Question 6 of 10

6. Which operator is used to check the expression is not “NULL”?

None of the mentioned

IS NULL

NOT NULL

Question 6 of 10

Question 7 of 10

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

SELECT *
FROM employee
WHERE lname LIKE ‘_a%e%’;

All employees whose last name should have letter ‘a’ in second position and at least one ‘e’ in his name

All of the mentioned

All employees whose last name start with any letter but contain at least one ‘e’ in his name

All employees whose last name start with any letter but second letter should be ‘a’

Question 7 of 10

Question 8 of 10

8. What will be the order of sorting in the following MySQL statement?

SELECT emp_id, emp_name
FROM person
ORDER BY emp_id, emp_name;

Sorting {emp_id, emp_name}

Sorting {emp_name, emp_id}

Sorting (emp_id} but not emp_name

None of the mentioned

Question 8 of 10

Question 9 of 10

9. 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++);

{3, 4}

{5, 6}

None of the mentioned

{1, 2, 3}

Question 9 of 10

Question 10 of 10

10. What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?

SELECT d.name, count (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name

Aggregation of the field “name” of table “department”

None of the mentioned

Aggregation of the field “name” of both table

Sorting of the field “name”

Question 10 of 10

« Prev - MySQL Mock Test 9

» Next - MySQL Qualifier Test