Oracle 1Z0-071 Quiz 56 Topic 1 Questions 276-280

Question: 1

View the exhibit and examine the structure of the EMPLOYEES table.

q1_1Z0-071

You want to select all employees having 100 as their MANAGER_ID manages and their manager.

You want the output in two columns: the first column should have the employee's manager's LAST_NAME and the second column should have the employee's LAST_NAME.

Which SQL statement would you execute?

ASELECT m.last_name 'Manager', e.last_name 'Employee'FROM employees m JOIN employees eON m.employee_id = e.manager_idWHERE m.manager_id=100;

BSELECT m.last_name 'Manager', e.last_name 'Employee'FROM employees m JOIN employees eON m.employee_id = e.manager_idWHERE e.manager_id=100;

CSELECT m.last_name 'Manager', e.last_name 'Employee'FROM employees m JOIN employees eON e.employee_id = m.manager_idWHERE m.manager_id=100;

DSELECT m.last_name 'Manager', e.last_name 'Employee'FROM employees m JOIN employees eWHERE m.employee_id = e.manager_id AND e.manager_id=100

Show Answer

Question: 2

Which three statements are true about multiple-row subqueries? (Choose three.)

AThey can contain a subquery within a subquery.

BThey can return multiple columns as well as rows.

CThey cannot contain a subquery within a subquery.

DThey can return only one column but multiple rows.

EThey can contain group functions and GROUP BY and HAVING clauses.

FThey can contain group functions and the GROUP BY clause, but not the HAVING clause.

Show Answer

Question: 3

Examine the structure of the EMPLOYEES table.

q3_1Z0-071

There is a parent-child relationship between EMPLOYEE_ID and MANAGER_ID.

You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_ID is 123.

Which query provides the correct output?

ASELECT e.last_name, m.manager_idFROM employees e RIGHT OUTER JOIN employees mon (e.manager_id = m.employee_id)AND e.employee_id = 123;

BSELECT e.last_name, m.manager_idFROM employees e LEFT OUTER JOIN employees mon (e.employee_id = m.manager_id)WHERE e.employee_id = 123;

CSELECT e.last_name, e.manager_idFROM employees e RIGHT OUTER JOIN employees mon (e.employee_id = m.employee_id)WHERE e.employee_id = 123;

DSELECT m.last_name, e.manager_idFROM employees e LEFT OUTER JOIN employees mon (e.manager_id = m.manager_id)WHERE e.employee_id = 123;

Show Answer

Question: 4

In which normal form is a table, if it has no multi-valued attributes and no partial dependencies?

Asecond normal form

Bfirst normal form

Cthird normal form

Dfourth normal form

Show Answer

Question: 5

Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1 table, which are not present in the SALES2 table.

q5_1Z0-071

Which set operator generates the required output?

AINTERSECT

BUNION

CPLUS

DMINUS

ESUBTRACT

Show Answer

Oracle 1Z0-071 Quiz:56 Topic:1 Questions:276-280