Mysql

1.

Consider the following table in MySQL:

Table name: Employee

Employee_Id	First_Name	Last_Name	Salary	Joining_Date	Department
1	John	Wilson	10000	01-MAR-2013	Banking
2	Bob	Jones	80000	01-APR-2013	Insurance
3	Ben	Johnson	90000	01-APR-2013	Service
4	Mike	White	40000	01-APR-2013	Insurance
5	Tara	Green	50000	01-MAR-2013	Banking

Which of the following queries returns the position of a in the name Tarafrom theEmployee table?

select instr(FIRST_NAME,'a') from employee where first_name = 'Tara' select LOCATE('a',FIRST_NAME) from employee where first_name = 'Tara' select CHARINDEX('a',FIRST_NAME,0) from employee where first_name = 'Tara' select CHARINDEX('a',FIRST_NAME) from employee where first_name = 'Tara'

2.

Consider the following table in MySQL:

Table name: Employee

Employee_Id	First_Name	Last_Name	Salary	Joining_Date	Department
1	John	Wilson	10000	01-MAR-2013	Banking

Which of the following queries is used to return the length of the First_Name column from the Employee table?

select length(FIRST_NAME) from employee select len(FIRST_NAME) from employee select (FIRST_NAME) from employee None of these

3.

In MySQL, which of the following queries returns the details of the employees, who joined in the year 2014, from the Employee table:

Employee

Employee_Id	First_Name	Last_Name	Salary	Joining_Date	Department
1	Alice	Smith	10000	01-MAR-2013	Banking
2	Bob	Jones	80000	01-APR-2013	Insurance
3	Ben	Johnson	90000	01-APR-2014	Service
4	Mike	White	40000	01-APR-2013	Insurance
5	Tara	Green	50000	01-MAR-2014	Banking

select * from EMPLOYEE where year(joining_date) = '2014' select * from EMPLOYEE where SUBSTRING(convert(varchar,joining_date,103),7,4) = '2014' select * from EMPLOYEE where to_char(joining_date,'YYYY') = '2014' select * from EMPLOYEE where to_char(joining_date,'YYYY') = ('2014')

4.

In MySQL, which of the following queries is used to return the details of employees, who joined before March 1st, 2014, from the Employee table:

Employee

Employee_Id	First_Name	Last_Name	Salary	Joining_Date	Department
1	Alice	Smith	10000	01-MAR-2013	Banking
2	Bob	Jones	80000	01-APR-2013	Insurance
3	Ben	Johnson	90000	01-APR-2014	Service
4	Mike	White	40000	01-APR-2013	Insurance
5	Tara	Green	50000	01-MAR-2014	Banking

select * from EMPLOYEE where joining_date <'03/01/2014' select * from EMPLOYEE where joining_date <'2014-03-01' select * from EMPLOYEE where JOINING_DATE select * from EMPLOYEE where JOINING_DATE

5.

Consider the following table in MySQL:

Table name: Employee

Employee_Id	First_Name	Last_Name	Salary	Joining_Date	Department
1	Alice	Smith	10000	01-MAR-2013	Banking
2	Bob	Jones	80000	01-APR-2013	Insurance
3	Ben	Johnson	90000	01-APR-2014	Service
4	Mike	White	40000	01-APR-2013	Insurance
5	Tara	Green	50000	01-MAR-2014	Banking

Which of the following queries returns the details of the employees who joined after April 1st, 2014, from the Employee table?

select * from EMPLOYEE where JOINING_DATE> to_date('01/04/2014','dd/mm/yyyy') select * from EMPLOYEE where joining_date >'01/04/2014' select * from EMPLOYEE where joining_date > '2014-04-01' None of these

6.

Consider the following table in MySQL:

Table name: Employee

Employee_Id	First_Name	Last_Name	Salary	Joining_Date	Department
1	Alice	Smith	10000	01-MAR-2013	Banking
2	Bob	Jones	80000	01-APR-2013	Insurance
3	Ben	Johnson	90000	01-APR-2014	Service
4	Mike	White	40000	01-APR-2013	Insurance
5	Tara	Green	50000	01-MAR-2014	Banking

Which of the following queries is used to return the Joining_Time and Joining_date columns from the Employee table?

select to_char(JOINING_DATE,'dd/mm/yyyy hh:mi:ss') from EMPLOYEE select convert(varchar(19),joining_date,121) from EMPLOYEE select CONVERT(DATE_FORMAT(joining_date,'%Y-%m-%d-%H:%i:00'),DATETIME) from EMPLOYEE None of these

7.

In MySQL, which of the following queries returns the top 5 salaries from the table Employee that has a salary column and n rows?

select top 5 * from employee order by salary desc select * from (select * from employee order by SALARY desc) where rownum < 6 select * from employee order by salary desc limit 5 select * from employee order by salary desc limit

8.

In MySQL, which of the following queries returns the second-highest salary from an Employee table, whose First_name and Salary columns have Nnumber of records each?

select min(SALARY) from (select top 2 * from employee) select min(salary) from (select * from (select * from employee order by SALARY desc) where rownum < 3) select min(SALARY) from (select * from employee order by salary desc limit 2) select min(SALARY) from (select * from employee order by salary desc limit 2

9.

In MySQL, which of the following commands is used to display all the records in which the name starts with the letters alx and the phone number is 3444444 and to limit the records displayed from 1 to 9?

SELECT * FROM [table name] WHERE name like "alx%" AND phone_number = '3444444' limit 1,9; SELECT * FROM [table name] WHERE name like "alx%" AND phone_number = '3444444' Between(1,9); SELECT * FROM [table name] Having name like "alx%" AND phone_number = '3444444' limit 1,9; SELECT * FROM [table name] Having name like "alx%" AND phone_number = '3444444'

10.

In MySQL, which of the following functions returns the string representation of the binary value passed to it?

BIT_AND() BIT_COUNT() BIT_AND() ATAN2()

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Mysql

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner