A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

A.GRANT select, insert, update ON student_grades TO manager
B.GRANT select, insert, update ON student_grades TO ROLE manager
C.GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
D.GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
E.GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
F.GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;

A.
B.
C.
D.
E.
F.

A. INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
B. INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
C. INSERT INTO employees VALUES ('1000','JOHN','NULL');
D. INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
E. INSERT INTO employees (employee_id) VALUES (1000);
F. INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

A. SELECT last_name, department_name FROM employees , departments(+);
B. SELECT last_name, department_name FROM employees JOIN departments(+);
C. SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E. SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);
F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);

A. GRANT select, insert, update   ON student_grades   TO manager;
B. GRANT select, insert, update   ON student_grades   TO ROLE manager;
C. GRANT select, insert, modify   ON student_grades   TO manager   WITH GRANT OPTION;
D. GRANT select, insert, update   ON student_grades   TO manager   WITH GRANT OPTION;
E. GRANT select, insert, update   ON student_grades   TO ROLE manager   WITH GRANT OPTION;
F. GRANT select, insert, modify   ON student_grades   TO ROLE manager   WITH GRANT OPTION;

A. INSERT INTO employees   VALUES ( NULL, ‘John’,‘Smith’);
B. INSERT INTO employees( first_name, last_name)   VALUES(‘John’,‘Smith’);
C. INSERT INTO employees   VALUES (‘1000’,‘John’,NULL);
D. INSERT INTO employees(first_name,last_name, employee_id)   VALUES ( 1000, ‘John’,‘Smith’);
E. INSERT INTO employees (employee_id)   VALUES (1000);
F. INSERT INTO employees (employee_id, first_name, last_name)   VALUES ( 1000, ‘John’,‘’);

A.WHERE lower(country_address) = "france"
B.WHERE lower(country_address) = 'france'
C.WHERE lower(country_address) IS 'france'
D.WHERE lower(country_address) = '%france%'
E.WHERE lower(country_address) LIKE %france%

A.The indexed column is declared as NOT NULL.
B.The indexed columns are used in the FROM clause.
C.The indexed columns are part of an expression.
D.The indexed column contains a wide range of values.

A.The inner query always sorts the results of the outer query.
B.The outer query always sorts the results of the inner query.
C.The outer query must return a value to the inner query.
D.The inner query returns a value to the outer query.
E.The inner query must always return a value or the outer query will give an error.