Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 37)

Question 176

View the Exhibit and examine the structure of the EMPLOYEES table.
You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees.
Which SQL statement would you execute?

A.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE m.manager_id=100;

B.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON e.employee_id = m.manager_id
WHERE m.manager_id=100;

C.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE e.manager_id=100;

D.SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
WHERE m.employee_id = e.manager_id AND e.manager_id=100;

Question 177

Examine the command:
SQL> ALTER TABLE books_transactions
ADD CONSTRAINT fk_book_id FOREIGN KEY (book_id)
REFERENCES books (book_id) ON DELETE CASCADE;
What does ON DELETE CASCADE imply?

A.When a row in the BOOKStable is deleted, the rows in the BOOK_TRANSACTIONStable whose BOOK_IDmatches that of the deleted row in the BOOKStable are also deleted.

B.When the BOOKStable is dropped, the BOOK_TRANSACTIONStable is dropped.

C.When a value in the BOOKS.BOOK_IDcolumn is deleted, the corresponding value is updated in the BOOKS_TRANSACTIONS.BOOK_IDcolumn.

D.When the BOOKStable is dropped, all the rows in the BOOK_TRANSACTIONStable are deleted but the table structure is retained.

Question 178

Which three statements are true regarding group functions? (Choose three.)

A.They can be used on columns or expressions.

B.They can be passed as an argument to another group function.

C.They can be used with a SQL statement that has a GROUP BY clause.

D.They can be used only on one column in the SELECT clause.

E.They can be used together with the single-row functions in the SELECT clause.

Question 179

Which two statements are true regarding working with dates? (Choose two.)

A.The RR date format automatically calculates the century from the SYSDATE function but allows the session user to enter the century.

B.The default internal storage of dates is in numeric format.

C.The default internal storage of dates is in character format.

D.The RR date format automatically calculates the century from the SYSDATE function and does not allow a session user to enter the century.

Question 180

View the Exhibit and examine PRODUCTSand ORDER_ITEMStables.

You executed the following query to display PRODUCT_NAMEand the number of times the product has been ordered:
SELECT p.product_name, i.item_cnt
FROM (SELECT product_id, COUNT (*) item_cnt
FROM order_items
GROUP BY product_id) i RIGHT OUTER JOIN products p
ON i.product_id = p.product_id;
What would happen when the above statement is executed?

A.The statement would execute successfully to produce the required output.

B.The statement would not execute because inline views and outer joins cannot be used together.

C.The statement would not execute because the GROUP BYclause cannot be used in the inline.

D.The statement would not execute because the ITEM_CNTalias cannot be displayed in the outer query.

Other Version: 4126Oracle.1z0-071.v2025-03-22.q314; 7455Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 25885Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 123Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 210Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 176

Question 177

Question 178

Question 179

Question 180

Download PDF File