Sudheer Quiz2

Select the Syntax to be written in like statement for extracting strings that start with r and end with r

• r%%r

• rr%

• %r%

• r%r

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

• SELECT last_name, department_nameFROM employees e INNER JOIN departments d ON (e.department_id = d.department_id)

• SELECT last_name, department_nameFROM employees e LEFT JOIN departments d ON (e.department_id = d.department_id);

• SELECT last_name, department_nameFROM employees e RIGHT JOIN departments d ON (e.department_id = d.department_id);

• NA

In what order does SQL process the instructions

• SELECT - FROM - WHERE - ORDER BY

• SELECT - Where- From - ORDER BY

• SELECT - FROM - ORDER By - WHERE

• None

Which join would you use to create a query that returns ALL unique levels from Table B in below syntax

Table A ----- join Table B ?

• Left

• Inner

• Right

• None

If table A has 3 rows & table B has 3 rows. What is the maximum no of rows possible when A is left joined with B

If table A has 3 rows & table B has 3 rows. What is the minimum no of rows possible when A is left joined with B

A colulmn named 'city' from table 'orders_info' has 4 unique levels. How many rows will be there in output - select city, count(orders) from orders_info group by city ;

What will be the number of rows in output of this query - (Gender has 2 unique levels, location has 2 unique levels)

select gender, location, count(orders) from order_info group by gender

• 2

• 4

• Returns an error

• 3

Which is not aggregate function

• Sum

• Average

• like

• Count

We want to find the total sum (total order) of each customer. Which of the below statement is right

• None

• SELECT Customer,SUM(OrderPrice) FROM OrdersGROUP BY Orders

• SELECT Customer,SUM(OrderPrice) FROM OrdersGROUP BY Customer

• SELECT Customer,SUM(OrderPrice) FROM OrdersGROUP BY OrderPrice