MySQL Class 12 Quiz-6

Welcome to your MySQL Class 12 Quiz-6

Name

School Name

Q51. We can specify two columns in the ORDER BY clause of MySQL?

True

False

Q52. Write a query to display the details of all those employees whose salary is unknown.

Select * from employee where salary is unknown;

Select * from employee where salary is null;

Select * from employee where salary =null;

Select * from employee where salary = "null";

Q53. Write a query to display details of all employees who have been given a salary (i.e., salary is not null) and works in the department D1.

Select * from employee where salary = not null and dept_id = "D1";

Select * from employee where salary is not null and dept_id = "D1";

Select * from employee where salary = "not null" and dept_id = "D1";

Select * from employee where salary is not null or dept_id = "D1";

Q54. SQL provides a ______________ operator that can be used with the WHERE clause to search for a specified pattern in a column.

NOT

Q55. In MySQL "Like" operator uses two wild characters with where clause. Identify them from the following.

** and %

_ (underscore) and %

? and &

_ (underscore) and ?

Q56. Which of the following wild character (use with Like) represent exactly single character?

_(underscore)

Q57. Which of the following wild character (use with Like) represent multiple characters?

_(underscore)

Q58. Write a query to display details of all those employees whose name starts with 'M'.

Select * from Employee where ename like "M_ _ _ _";

Select * from Employee where ename like "M%";

Select * from Employee where ename = "M%";

Select * from Employee where ename like "%M%";

Q59. Write a query to display details of all those employees whose name ends with 'L'.

Select * from Employee where ename like "_ _ _ _ L";

Select * from Employee where ename like "L%";

Select * from Employee where ename = "L%";

Select * from Employee where ename like "%L";

Q60. Write a query to display details of all those employees whose name contains 'A'.

Select * from Employee where ename like "_ A _";

Select * from Employee where ename like "A%";

Select * from Employee where ename = "%A%";

Select * from Employee where ename like "%A%";