Question

Which SQL statement retrieves the EmployeeName and City columns from the Employees table? O LIST EmployeeName, City ON Employees; O FIND EmployeeName, City ON Employees; SELECT EmployeeName, City FROM Employees; O RETRIEVE EmployeeName, City FROM Employees; Which SQL statement finds the different cities in which national parks reside with no duplicate rows listed? SELECT DISTINCT city FROM natlpark ORDER BY city; O ORDER BY natlpark DISTINCT city; O ORDER BY city FROM natlpark; O SELECT city FROM natlpark ORDER BY DISTINCT city; In SQL, a manager asks for a list of employees to be sorted by last name rather than first name. Which command is used to do this? O ORDER BY O GROUP BY O SORT RESULTS O INDEX BY What is an advantage of using COUNT(*) with GROUP BY as opposed to counting occurrences of each distinct column? The results of the query can be sorted in ascending order. It is not necessary to know the values in the column in advance. The values in the column are pre-sorted by the GROUP BY criteria. It is not necessary to know the counting criteria in advance. Which SQL statement returns only the rows where a match is found in both Table 1 and Table 2? SELECT t1.*, t2.* FROM 1 RIGHT JOIN t2 on ti.il = t2.i2 O SELECT ti.*, t2.* FROM ti INNER JOIN t2 ON ti.il - t2.i2; O SELECT t1.*, t2.* FROM LEFT JOIN t2 on ti.il = t2.i2; SELECT t1.il UNION SELECT t2.i2; Three tables contain a reference column with the same datatype. Which SQL statement selects a specific column from each of three tables? O SELECT I FROM 11 UNION FROM 12 UNION K FROM 13; O SELECT I FROM 11 UNION SELECT FROM 12 UNION SELECT K FROM 13; O SELECT i, j, k FROM 11, t2, t3; O SELECT I FROM 1 AND SELECT FROM 12 AND SELECT K FROM 13;

Answer 1

Question 1:

Answer :SELECT EmployeeName,City FROM Employees;

Explanation :

• This SQL query will get the employee name and city from employees tables
• LIST , FIND,RETRIEVE are all invalid keywords.

*****************************

Question 2:

Answer :SELECT DISTINCT city FROM natlpark ORDER BY city;

Explanation :

• This SQL query will get the unique city without duplicate from natipark table.
• Here distinct will get the unique records.

*****************************

Question 3:

Answer :ORDER BY

Explanation :

• In SQL order by is used to sort the records
• group by is used to group the records
• SORT results and index by are invalid,

*****************************

Question 4:

Answer :It is not necessary to know the values in the column in advance

Explanation :When what values are present in the columns are not known even when counting can be done in advance and as required records can be sorted by using order by as and when needed.

*****************************

Question 5:

Answer :SELECT t1.*,t2.* FROM t1 INNER JOIN t2 ON t1.i1=t2.i2;

Explanation :

• INNER join in SQL used to join the two tables and will return the matching row based on some condition.
• Right join will return all rows from right table and matching rows from left table
• Left join will return all rows from left table and matching rows from right table

*****************************