When you use the ANSI Syntax that includes USING clause, which of the following will be invalid?

Select one:

a.None of the options

b.No alias should be used in USING clause

c.Conditions must be included only in FROM clause

d.WHERE clause could be used to add other conditions

If you wish to create an inner join, but the two tables do not have a commonly named attribute, you can use a(n) __________ clause.

Select one:

a.JOIN ON

b.OF

c.HAS

d.USING

Employee (EmpCode, EmpTitle, Fname, Lname, Salary, JobCode, ShopCode,DeptCode) Job (JobCode, JobDesc, JobPayment) Which of the following queries displays employees (first and last names) and their jobs (job description), including those employees even if they have no job?

Select one:

a.SELECT e.Fname, e.Lname, j.JobDesc FROM employee e, job j WHERE e.JobCode(+)=j.JobCode(+);

b.SELECT e.Fname, e.Lname, j.JobDesc FROM employee e, job j WHERE e.JobCode(+)=j.JobCode;

c.SELECT e.Fname, e.Lname, j.JobDesc FROM employee e, job j WHERE e.JobCode=j.JobCode(+);

d.SELECT e.Fname, e.Lname, j.JobDesc FROM employee e, job j WHERE e.JobCode=j.JobCode;

Which of the following operators is used to compare value that its equal to one of the values returned by the subquery?

Select one:

a.Exists

b.IN

c.All

d.Any

INSTRUCTORS(instID, first_name, last_name, salary, course_code, department_id) Which SQL statement will display instructors who earn more than $2000 in each department but it only includes departments with average salary of $3500?

Select one:

a.SELECT first_name FROM instructors WHERE avg(salary) = 3500 HAVING salary>2000 GROUP BY department_id;

b.SELECT first_name FROM instructors WHERE salary>2000 HAVING avg(salary) = 3500 GROUP BY department_id;

c.SELECT first_name FROM instructors WHERE salary>2000 and avg(salary) = 3500 GROUP BY department_id;

d.SELECT first_name FROM instructors WHERE avg(salary)>2000 GROUP BY department_id;